Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

MS SQL Server role db_create_dts

By Paulo Luis,

For several times i had faced a problem of having “special” users, that need to create and run their own DTSs.
I produced this script after implementing all the steps needed to allow normal users to do and run their DTSs.
I hope it will be helpful at least for some of you.

Total article views: 267 | Views in the last 30 days: 1