Usage -Populate @list variable below with account(s),comma delimited list to script. -Save output to recreate:Login,Default DB,Server Roles,DB Access,DB Roles,DB Object Permissions. -- NOTE: -Stored procedures are created in Master, but are deleted -to limit by database see section /*Get a table with dbs where login has access*/ and change the where clause -to script all […]
2007-02-01 (first published: 2006-08-02)
4,421 reads
Populate @list variable with account(s) to script. Save output to recreate:Login, Password,Default DB,Server Roles,DB Access,DB Roles,DB Object PermissionsDB level permissions are scripted in all databases. Can recreate a single login, or accepts comma delimted list of logins.NOTE:Stored procedures are created in Master, but are deleted
2006-01-19 (first published: 2005-10-19)
1,690 reads
This procedure will resync all user/login sids, in all databases (unless limited). Excelent for use when restoring test environments.
2005-11-21 (first published: 2005-11-08)
1,734 reads
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
Hi All I have a table which contains the transactions done by cards. Below...
I have a lookup table that implements a system-generated Id for DRI purposes. The...
A client would like to be able to recognize similar free-texts in a text...
Ask SSC