You cannot use the SQL Server agent in SQL Server Express. The way I have done it before is to create a SQL Script, and then run it as a scheduled task each day, you could have multiple scheduled tasks to fit in with your backup schedule/retention. The command I use in the scheduled task … Read more
This is what I have, hope it helps: <?define ServerInstall=”SomeCondition” ?> <?define InstanceName = “YOUR_INSTANCE” ?> <?define SqlWebLink = http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLEXPR_x86_ENU.exe ?> <Variable Name=”SqlVariable” Type=”string” Value=”/SAPWD=some_password” Hidden=”yes” /> <!– Read SQL Server keys to find current instance and version –> <util:RegistrySearch Id=”SqlInstanceKeyFound” Root=”HKLM” Key=”SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL” Value=”$(var.InstanceName)” Result=”exists” Variable=”SqlInstanceKeyFound” /> <util:RegistrySearch Id=”SqlInstanceKey” Root=”HKLM” Key=”SOFTWARE\Microsoft\Microsoft SQL … Read more
Check out Introduction to ADO.NET Tutorial ADO.NET Tutorial Lesson 1 An introduction to ADO.NET I’m sure there’s plenty more out there – just google for “ADO.NET” and “Tutorial” …… UPDATE: If you want to connect to your local SQL Server Express, and connect to the “Northwind” database, and read the top 5 customers from the … Read more
You can’t do this through the wizard, because there are a couple of bugs. Even if I chose not to track changes and not to populate the index when it was finished, I still got an error about SQL Agent: Cannot load ‘Select or Create Population Schedules’ Full-Text Wizard form. SQL Server Agent is not … Read more
ok, it works now! guess it was a compound problem … the steps I took to resolve it are as such: Changed the following property in the connection string (note the subtle difference): AttachDbFilename=|DataDirectory|CustomerDb.mdf; Deleted the contents of the following directory: c:\Users\<user name>\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS. I thought I had looked for this before, but … Read more
Use a SqlCommand. This code will only keep the connection alive for a very short period of time (as long as your query is performant): DataTable results = new DataTable(); using(SqlConnection conn = new SqlConnection(connString)) using(SqlCommand command = new SqlCommand(query, conn)) using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command)) dataAdapter.Fill(results);
No, SQL Server Express LocalDB doesn’t accept remote connections. The idea with shared network folder might work, but only if you are able to make sure the LocalDB instance is shutdown before you try to copy the file. Also keep in mind that only one LocalDB instance can have any given database file open at … Read more
You need to commit the data. Each SQL command is in a transaction and the transaction must be committed to write the transaction to the SQL Server so that it can be read by other SQL commands. Under MS SQL Server Management Studio the default is to allow auto-commit which means each SQL command immediately … Read more
The problem with your connection string here is: <add name=”TrempimModel” connectionString=”data source=.\SQLEXPRESS;Integrated Security=SSPI; AttachDBFilename=|DataDirectory|aspnetdb.sdf; User Instance=true” providerName=”System.Data.SqlClient” /> You’re basically defining what “server” you’re connecting to – but you’re not saying what database inside the file to connect to. Also – the file extension for SQL Server Express database files is .mdf (not .sdf – … Read more
Maybe you have to execute the following in the Visual Studio Tools command prompt: aspnet_regiis -i You can read more about the ASP.NET IIS Registration Tool (Aspnet_regiis.exe) here.