I agree with Dotathinker, how can 2 and 3 be correct? As the entire transaction is under uncommittable state which is -1.

As per docs from Microsoft please note the below...

• This reply was modified 4 years, 9 months ago by  sam_mastermind.

Hi.

Are there any clr functions used. If so, please check whether that is actually causing the issue.

Or it may happen due to a memory leak , which can...

Hope this link will help you a lot : http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Can-CHECKDB-repair-everything.aspx

Hi Friends,

Please do not bother about the points. Ultimately it has shown us a different way of referencing a non persistent computed column reference. But obviously performance wise it is...

Yeah. Option A and D are the correct one. Although a very good question.

Hi,

Is there any specific benefits you will get by migrating it to windows 2008 clusters.

Thanks a lot.

May be the way I framed it, looks like as you said(homework ?/ Exam ? / Interview ?). But truly I want to know it............... and i think that is...

can u really make a emergency mode database to single user mode in sql server 2000, i have tried it but it failed. Can u help in this regard.............

Hi guys if you are taking a disk backup there is no need to use this options ,this are basically used in case of taking tape backup.

Using dbcc loginfo one can view a transaction log ,but seeing the transaction log for a particular transaction i don't think is possible in sql server 2000 .

Though i am...

try this one ::fn_get_sql(Sql_handle)

try this one.....

sp_configure 'allow update options',1

reconfigure with override

update the sysdatabases status column with the value -32768 for msdb database

the msdb will go into emergency mode.

Migrate the table data to from...

yes gailshaw is correct ,but i like to add that before rectifying your code just understand one thing that there are two kinds of deadlock ,namely cycle deadlock and conversion...

Go with count value is not supported in Sql server2000 engine , it is supported only in sql2005