When u create a database user u can give that user certain roles like db_owner ,db_ddladmin etc.These roles are fixed and u cannot add any more roles to that,out of...

Dont u have mail configures on ur system???

Hope u have outlook express on ur machine and mail configured on that..

Database Mail and SQL Mail both are different and DB mail requires SMPT Server.Higher versions of SQL Server dont have SQL Mail by default.

Check these links

http://technet.microsoft.com/en-us/library/ms175887.aspx

http://technet.microsoft.com/en-us/library/ms177418.aspx

Thanks Everyone

I have solved the problem by copying the LDF to another drive and then attached the database giving the new LDF path.

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"..