That's true, though the membership of those roles should be small enough that you can notify them that you want to restore the database. 

You could try running

ALTER DATABASE...

Sounds like you need to restrict access to the database before restoring.  You could set the database to RESTRICTED_USER by using ALTER DATABASE.  This would disconnect anyone who isn't a member...

Rob,

See "How to restore a database with a new name" under "RESTORE DATABASE" in BooksOnLine for the T-SQL commands needed to restore a database with a new name and new file names. ...

Nita,

There's no way to decypher the encrypted DTSRun command.  If you know which package you want to execute, follow

the instructions for generating a DTSRun command with dtsrunui given in...

Something like this?

select  left(u.name,20),

 cast(o.name as varchar(45))as 'object',

 case p.action

          when 193 then 'SELECT'

   when 195 then 'INSERT'

   when 196 then 'DELETE'

   when 197 then 'UPDATE'

   when 224 then...

I don't know how to get the info specifically for dbo, but if you run sp_helpuser with no parameters in a database, it will display the logins aliased to users.

Greg

Nita,

This question was answered in the administration forum.  Please don't post your question in multiple forums.  Most people who browse the forums will see a post no matter where it...

Duplicate post.  Use this thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=335776

Is the stored procedure encrypted?  sp_helptext won't display the text if it is.

Greg

Compare the permissions for sp_enum_dtspackages in msdb of the dev and staging instances.  That's the stored procedure that Enterprise Manager executes to list DTS packages. 

Greg

The Model database probably has the guest user in it, so when a new database is created, the user is also created and exists before the scripts are run.  See...

What's the error? 

The SQL2005 Import/Export wizard doesn't have the object copy option that the SQL2000 version had.  You're stuck with scripting the keys and indexes seperately or creating an SSIS package and...

Cathy,

I generally stay away from the Data Driven Query task because it's performance is so poor. 

I prefer to import data into staging tables then use TSQL in Execute SQL...

I don't really even think about retirement.  I think I could work in IT as long as I'm able and still be pretty happy.  I really like what I do,...