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
Hopphopp Tschingbum!
Stoppwörter nennt man Wörter die in nahezu jedem Text in einer Sprache auftreten, wie beispielsweise Artikel (der, die, das) und Präpositionen (an, auf, unter). Aufgrund ihrer Häufigkeit und meist geringen inhaltlichen Bedeutung werden sie bei der Suche nach Texten und bei der Erstellung des dazu genutzten Index normalerweise nicht berücksichtigt.
Die Volltextsuche in SQL Server 2008 […]
Posted: September 6th, 2008 under SQL Server.
Comments: none
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