SQL-Server-Scripts

SQL-Server-Scripts copied to clipboard

Better filter @IncludeMSShipped when @DbName is ALL

1

Hi, first of all, thanks for this tool. After that, I tried following command: `sp_DBPermissions @Output = 'Report' , @IncludeMSShipped = 0, @DbName = 'ALL'` And it turns out there...

jeffchulg

Target database is in an availability group

1

I get the error below when running the following command against a SQL Instance which contains any databases configured for AlwaysOn EXEC [dbo].[sp_DBPermissions] @DBName = 'ALL', @output = 'report'; "The...

mjhf19

In summary: - renamed Note file because if you try to extract entire ZIP from Github using Powershell, it fails. - Added Output parameters to on-premise procedures so that it...

jeffchulg

Column level permissions

1

I've had several requests to add column level permissions to sp_DBPermissions.

sqlstudent144

Fix grant/revoke scripts for impersonate on sp_SrvPermissions

1

Comment from Jason Thurston I had some trouble with the generated revoke and grant scripts for impersonation. I made a code change to get it to work. Not sure whether...

sqlstudent144

None of the script handles unicode very well.

sqlstudent144

None of the scripts handle unicode very well.

sqlstudent144

None of the scripts handle unicode very well.

sqlstudent144

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

JoyWorksToo

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...

JoyWorksToo