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.

Thanks Lucky thanks a lot ...It worked :w00t:

I think this is database level ....And this one comes back to default value when a new query window is opened...

Thanks to all ...:)

Thanks Karl 🙂

Have done it ....:D

I tried the dbcc shrinkfile after taking a log backup but still the log file is not shrinking ...Is there any option to truncate log???

Thanks All,

The problem is that after reviewing the codes they said that EXISTS and TOP have...

Hi Sugesh,

Used the GUI ...first i detached the db and copied the...

Hi Faheem

I went through the link but no solution for my...