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
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect - Engineering
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
Error 18456, Severity 14: Login Failed States
The document referenced below explains all the states, this is just a summary. State Description 1 Only state returned in SQL 2000. Seems to be
SQL Canada (SQLCAN) 