Thank you Yelena,

What's your opinion on adding sp_ABC stored procedure, so that it can be called in other databases where necessary?

R

Hello,

I only searched sqlservercentral for heavily used DBCC commands, then after googling, I found more stuff.

Thank you Siva Prasad.

Couple other links that sound interesting,

http://www.joesack.com/iprepindexdbcc.html

http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=446

R

A database gets the suspect status when the database runs out of disk space on the drive where the data files reside.

You can try to reset the status and create...

Thank you Kathi,

I realized that (can't have the same database server name), when I tried to install SQL 2K. So I had to uninstall MSDE and installed SQL 2K.

Well, I am trying to create a test case.

Here is the code to create table.

CREATE TABLE dbo.TestTran (

TransactionID ...

Hi Remi,

What other ways can I accomplish this task, if I choose not to use my own query.

Thank you.