Archive for 'SQL Server'
AttachDbFilename
Today I tried to start a sample program which contains a connection string like this:
const string connectionString = @”Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\SampleInstanceStore.mdf; Integrated Security=True;Asynchronous Processing=True”;
I got the following error message:
System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file C:\Users\Martin\Some more subfolders\SampleInstanceStore.mdf failed. A database with the […]
Posted: May 28th, 2009 under SQL Server.
Comments: none
SQL Server 2008: Script Data
The SQL Server 2008 Management Studio has a nice little new feature which seems to be omitted from the documentation. The Script Wizard (Database - Tasks - Generate Scripts) now has a “Script Data” option. If selected the Wizard will generate INSERT statements for the data in the scripted tables. This can be very handy.
This […]
Posted: September 7th, 2008 under SQL Server.
Comments: 1
Report Manager 2005 Help 
The Microsoft SQL Server 2005 Report Manager web application has help pages in several languages. They display nicely in IE, but in Firefox they are reduced to a mere 
 is the unicode byte-order mark, coded in UTF-8. A first inspection with Firebug revealed that this application does not set the charset in the http […]
Posted: March 27th, 2008 under SQL Server, IIS.
Comments: none