but how would i know the reason for causing this problem.

unfortunately we have win 2003 standard which will not allow to add more memory.

3277 MB and AWE enabled

Here is the script i use

declare @dbname as varchar(80)

declare @msgdb as varchar(80)

declare @dbbkpname as varchar(80)

declare @datepart as char(1)

declare rs_cursor CURSOR for select name from master.sys.databases where state_desc = 'ONLINE'...

I would like to see what is in credential.

Also is it mandatory that if i associate a credential with domain user i need to give same pswd as domain user...

that is what i did , i can see the db name but its not visible when look at mgmt studio. what if that was renamed?

I can see the mdf and ldf files located on the disk which are used, how can i find the database name for those files?

all fiels will be moved wth in the same computer from one drive to another.

how can we write a script using cursor like

1.select 80 databases one by one using cursor

2. dettach database

3. Move file using xp cmd shell script from location A to B

4....

Yes, user has create database permissions along with Read/Write/ddl_admin.

Here is the thing...

User with above previlages to trying to move a database from one server to another server and getting that...

SilverFox

If...

I did a small test but wiered results..

User who has dbcreator role created a database "TEST" and I tried this query

and got this error

Msg 3701, Level...

I am looking for a work around. For sure i have to give them creator role but have to restrict them from dropping.

THough the user is not a owner of...

I am still confused how can a user with Read/Write/ddl_admin and dbcreator role deleted a production database. How can that happen though he is not owner of that database ?

If...