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 😀

Try giving all database roles except db_denydatawriter and db_denydatareader

So you are using windows login and connecting to sql server 2000 right??

Hope you have given the password expiration for that login.:)

I think thats not possible as this will cause security concerns.:D

Solved the issue 😀

Better Restart the server from services-->SQL Server.Also check whether you have enable TCP/IP and Named pipes.