You could list permissions for sysdts... tables and stored procedures with dts in their names in msdb database.

Unless the packages use Microsoft Data Link files (.udl) or pass the connection info in a global variable to the child packages, you'll have to change the connection in each...

Hi Jeff,

Do you have a question?

What you see listed under Management--Legacy--Data Transformation Services are the DTS packages. Open one by right-clicking and select "Open...". Note: the SQL 2000 DTS Designer components must be...

You can select data from INFORMATION_SCHEMA.VIEWS to use in your script.

There apparently is a value in the source column that won't convert to smalldatetime. You'll have to find it and either correct it or remove it. Try designating...

You can create a script that contains a series of sp_add_login (or sp_grantlogin if adding Windows logins), sp_add_user, and grant statements.

Example:

EXEC master..sp_addlogin 'App_Login1' ,'passwd', 'TempDB'

use yourdb

EXEC master..sp_adduser 'App_Login1','App_User1'

Grant SELECT on...

You have to either open each package or save them to files and search. Search SSC for something like "script all packages" or "save all packages" for scripts...

While sp_add_maintenance_plan and sp_add_maintenance_plan_db still work in SQL 2005, they'll be removed in a future version (maybe SQL 2008?) so MS recommends using the interface in SSMS to create them....

You've got it a bit backward. A member role inherits the permissions of the role it's a member of. Using your example, HRUser role can select and update...

Yep. Add that to the SELECT list and remove the WHERE clause.

Oh yeah. Old habits... Thanks, Gail

Add the user to master and grant EXECUTE on xp_servicecontrol. It won't have any other sysadmin permissions.

There must be ParcelID values in GIS_Data that don't exist in Field_Data so you can't create the foreign key because the data violates the foreign key constraint. You'll have...

It's a secutity catalog view rather than a table. You can't add rows to it directly, but all it lists are database users and roles so you when you...