i made the server connections to single user mode so there is no other connections to that i feel.

Hi,

SP3 of SQL Server 2005 is expected to be released by next month only

Thanks Dude it worked..

Those DB having autoclose option False are not able to delete only those set to true got deleted.

Ya i find that in OPTIONS ..It is presently FALSE.

Am using SQL SERVER Developer Edition i didnt find any such AUTOCLOSE option in property window of DB.How can i check the present status of AUTOCLOSE?? Is there any TSQL...

How to check whether the DB is in AUTOCLOSE or not and if so how to change that....

Databases not offline and ...if i delete mdf and ldf then am not able to access the database.but if i restore the database with a dump then mdf and ldf...

Are u trying copying after making the database offline?????Cant u take a backup and restore the database....

Check this

http://msdn2.microsoft.com/en-us/library/ms188388.aspx

am using sql server 2000 enterprise and am trying to connect to a remote sql server 2005 express server....am getting the error "the server doesnt exists or access denied"..

am having sql server 2000 enterprise when i tried to connect to sql server 2005 express its showing access denied..

what u mean by NIC

Hope ur database is in restoring state....Try Restoring the database with recovery option....

Thanks to all

I find the solution in DB level by giving sp_msforeachtable @command1="alter table nocheck constraint all"

Regards

Ratheesh.K.Nair

You are on the right path ...also change the compatibility to 90.