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,442 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,765 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,755 reads
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Comments posted to this topic are about the item Displaying Money
Comments posted to this topic are about the item The Slow Growing Problems
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers