Client was noticing high number of Page Splits/sec in relation to Batch Request/sec; however could not figure out why. They were not have performance issue but
Category: SQL 2000
OSQL and Code Page Settings
Credit: Carl B. (SQL Server Central, Link) In SQL Server 2000, when using OSQL it is difficult to work with import files that are in
Error 14274: Cannot add, update, or delete a job (or its steps or schedule) that originated from an MSX server.
You can get this error when trying to modify the properties of a Job after the SQL Server has been renamed or cloned into another
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
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) 