If you are trying to setup Database Mirroring, it prefers to see a FQDN for the servers when entering partner information. If you don’t you’ll
Granting Execute Permissions
Following code can be used to Grant Execute Permissions to a Database Role, in a database. This is for SQL Server 2000; because in 2000
Normalizing-Denormalized Tables
I hope to write more article as time permits, but this is my first article that I posted on SQL Server Centrals :). I hope
Important Links for SQL Server 2008
Features Supported by the Editions of SQL Server 2008 http://msdn.microsoft.com/en-us/library/cc645993.aspx SQL Server 2008 Encryption Hierarchy http://msdn.microsoft.com/en-us/library/ms189586.aspx SQL Injection http://msdn.microsoft.com/en-us/library/ms161953.aspx Understanding and Manging the suspect_pages Table
Imporant Links for SQL Server 2005
Features Supported by the Editions of SQL Server 2005 http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx SQL Server 2005 Encryption Hierarchy http://msdn.microsoft.com/en-us/library/ms189586(SQL.90).aspx SQL Injection http://msdn.microsoft.com/en-us/library/ms161953(SQL.90).aspx Understanding and Manging the supsect_pages Table
Status Column in Sysusers
I have encountered issues after adding logins to the SQL Server 2000 databases where even though the servers show up in the user list they
SQL Canada (SQLCAN) 