connect giving InstanceName\SQLEXPRESS

To which edition of SQL Server you are connecting????

I checked the error logs but find only that particular database started. Searched for the word 'Delete' 'Drop' but no use...

I have error log ..Is that helpful.Can i find who deleted the database and when???

Schema have many purposes,One thing is you can create tables having same name under different schemas.

Thanks Gila..:D

Ya my user is a local admin.I tried using another login which is not a local admin and am not able to restart the server.

Once again thanks

No am not local admin ...I dont have administrative privileages .The user which am using is a SQL login and its not a domain user.

I tried using a new login with only datareader and datawriter database roles and access to only one DB.

Yes am using SSMS .Am using SQL authentication not windows

I think you tried to attach a SQL Server 2008 DB in SQL Server 2005.You cant attach 2008 DB in 2005

Whats tour database's present recovery model.

Go to registry-->software-->microsoft-->sql server-->instances...there you can find the instances installed in that particular machine.

Disclaimer:the path is not accurate

What time of information you want to know???

If you want to know the version use select @@version

for Service pack used select serverproperty('productlevel')

When migrating from SQL Server 2000 to 2005 there can be some issues relating to schema.So please check the objects that contain any schemas other than the default one.:)

Am with Jaypee.Better go for trigger 😀