Hi all,

Thanks for your help, I got my answer.

Looks Like the URL Provided is for SQL Server 2005, and I want the same in SQL Server 2000 also. For that reason only I have added another topic in...

Thank you all for your feed back. Yes, the operating system is on 64-Bit and I too got the my answer.

Thanks once again.

Apart this,

can we change the active logins to inactive ?

Thanks A Lot,

it helped me.

Will let you know if there is any issues.

Thanks Again.

After Restarting my system problem got solved

try by running below query:

DBCC updateusage 'DBNAme'

check the properties

Thanks

Regards

I think for the database In Recovery status no user can connect to them.

So there will be other problem in deleting the Database.

Have tried by right click on database and...

hi Elisabeth,

The article is fine, but I am unable to of procedure to change the licencing mode in the present installed one.

But it was nice article.

Thank you.

Thank you Chris Harshman.

It's worked for me, and need another small query on this situation only.

I have the table with the below information already:

Col1 ...

Thank you All,

I ahve recreated the snap sht database.

Thanks a lot Buddy, I got answer.

Can you please explain the procedure for partitioning a table ?

But today it got succeeded when we reran the Job after 6 hours of Job failure.

Thank you.

But will these consistency errors effect the updatestats job ?

When I executed the stored procedure directly it got executed successfully.