We were using the below query to find any users connected to a particular database in MSDE 2000.
select * from master..sysprocesses a, master..sysdatabases b where a.dbid = b.dbid and b.name = ''
Now we are planning to upgrade the Database to SQL Server 2008, After upgrading to 2008 and restored the SQL Server 2000 database backup. We are always getting a record with lastwaittype as "CHECKPOINT_QUEUE" in the above query result.
I want to know the following
1.Why the checkpoint_queue Record is coming? 2.How to avoid checkpoint_queue record?
Can anyone help me on this? Thanks in Advance.
Regards, Karthick R