Friday, June 16, 2006

TargetServersRole

Use this "TargetServersRole" available on SQL Server 2000 SP3 and above to grant users who requires to view the all the jobs listed on SQL Server for a normal user.

Use msdb
EXEC sp_addsrvrolemember 'Corporate\HelenS', 'TargetServersRole'
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)