http://www.sqlskills.com/blogs/paul/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

http://www.sqlskills.com/blogs/paul/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

MJ

Try by running dbcc opentran() under that database and see the oldest transaction. Check what spid it has and whts it doing in background(might be a old left out connection...

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