http://support.microsoft.com/kb/899761

FIX: Not all memory is available when AWE is enabled on a computer that is running a 32-bit version of SQL Server 2000 SP4

MJ

--This script will generate all user permissions and the code to

recreate them as required.

SELECT C.name 'Schema',

...

Suspended = The session is waiting for an event, such as I/O, to complete.

http://msdn.microsoft.com/en-us/library/ms179881.aspx

MJ

http://support.microsoft.com/kb/324401

HTH!

MJ

How to manually remove a replication in SQL Server 2000 or in SQL Server 2005

http://support.microsoft.com/kb/324401

MJ

How to manually remove a replication in SQL Server 2000 or in SQL Server 2005

http://support.microsoft.com/kb/324401

MJ

How to manually remove a replication in SQL Server 2000 or in SQL Server 2005

http://support.microsoft.com/kb/324401

MJ

SELECT *

FROM [msdb].[dbo].[sysdtspackages90]

HTH!

MJ

http://www.db-staff.com/index.php/microsoft-sql-server/87-upgrade-sql-2005-cluster-to-sp3

Imp Points:

1. It is necessary to update each node of the cluster to get a SQL Cluster fully updated with all the tools and components to the latest Service Pack.

2....

There are several ways to achieve this in SQL Server 2000 - C2 level auditing or implementing third party tools. However, SQL Server 2005 introduced a new feature called DDL...

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ad2c591d-c890-49ff-a772-026d875b4011

RESOLUTION

=============================================

1. Find MSXML6.dll on the machine (typically located at c:\winnt\system32 folder).

Run regsvr32 \msxml6.dll - and test creating / saving an SSIS Project. If you don’t

have MSXML6.dll on your...

http://msdn.microsoft.com/en-us/library/ms178085.aspx

7.Calculate the number of rows per page (8096 free bytes per page):

Rows_Per_Page = 8096 / (Row_Size + 2)

The value 2 in the formula is for the row's entry in...

Just correcting Kalyani's comment:

Compared to the full recovery model, which fully logs all transactions, the bulk-logged recovery model minimally logs bulk operations, although fully logging other transactions.

MJ

Try:

http://sqlserverpedia.com/wiki/SQL_Server_Release_Date_Calendar

MJ

Try this query:

select object_name(si.object_id) As TableName,fg.name,si.type_desc

from sys.indexes si join sys.data_spaces fg

on si.data_space_id=fg.data_space_id

join sys.objects so on so.object_id=si.object_id

where so.type='U'

MJ