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.

Check the installation once again ...hope u have Installed in C drive only...

Try executing create table statement one by one..

Marcus is right i think ..either the path doesn't exists or u dont have permission in that.

Thanks Tommy that was really nice ............