Archive for February, 2008
Recently, I have had to install a named instance of SQL Server 2005 along side a default instance of SQL Server 2000. The 2000 server had the following collation configured: SQL_Latin1_General_CP1_CI_AS. For testing purposes, we had to make sure the new instance had the same collation setting.
If you want to determine the Collation setting for a particular database in SQL Server: Open Query Analyzer (or SQL Management Studio) Select your database Execute the following query: SELECT DATABASEPROPERTYEX(db_name(), ‘Collation’) SQLCollation; Hope this helps.
I have needed to check my SQL Server Collation settings recently. Here is a SQL Query to find your server’s collation setting. SELECT SERVERPROPERTY(‘Collation’) AS ‘Collation’ Hope this helps.
So Brian alerted me to an Internet fad that I was unaware of… the creation of my own fake band. Here are the details: So, the latest internet meme (fad) that’s going around is the band album cover theme. You pick random words and pictures from Wikipedia and Flickr and combine them to create your […]