JoyWorksToo

icon location USA icon location My collection of scripts either developed or scavenged online that helped me over the years.. Some are complex others simply not worth memorizing.

Results 2 issues of JoyWorksToo

Update sp_DBPermissions.sql line 400 type_desc to NVARCHAR

to: type_desc NVARCHAR (60) NULL, from: type_desc nchar(60) NULL to remove extra space at end of type_desc

IDEA: Keeping tables and using TRUNCATE

I run sp_DBPermissions from my own DB keeping and purge data as needed. Right now I need to drop the tables before I re-run each time. So can a new...