-
Recent Posts
Recent Comments
- Update Statistics fails with Error Number:–1073548784 “Could not allocate space for object ‘dbo.SORT” – ReplTalk on Stored Procedure to Sequentially Run SQL Agent Jobs
- steve kirchner on Whats a Good Rule for Max Degree of Parallelism?
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
- tim cronin on A Busy/Accidental DBA’s Guide to Managing VLFs
Archives
Categories
Meta
Tag Archives: Restore
Stored Procedures to Store and Get Database Users with All Permissions
Introduction Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the Generate Scripts wizard to script all logins and permissions. This approach can take several minutes and as I recently … Continue reading →
Posted in Security, User Management, Utilities
|
Tagged Permissions, Replication, Restore, Scripting Permissions, SSC
|
3 Comments