I also agree that the correct option should be "None of Above" as many times I moved the Resource database while moving the system databases in SQL 2005 or it...

Check out the following script. You can use the SQL statment used in the script.

http://www.intellipool.se/forum/index.php?showtopic=1133

Regds,

R@j

Yes, you are 100% right.

Also if you want the user should be able to take backup of each and every database, he should be member of db_owner (which is NOT...

Here are lines from Books Online:

If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able to execute RESTORE. If the database exists,...

Hi Dean,

Yes, It is possible to create such triggers. These triggers are stored in the master database as objects. The events are related to database changes such as CREATE, ALTER,...

Hi,

There was a similar error reported in MS Forums. Below is the link to the issue and its resolution. Hope it will help you to solve your issue.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1433864&SiteID=1

Regds,

R@j

After upgrading SQL Server 2000 to SQL Server 2005, your SQL 2000 database maintenance plans are visible under the Legacy node of the Management folder in Object Explorer.

As per...