Truncate data from all tables in a database
This script will truncate data from all tables in a database
2005-06-06 (first published: 2005-05-13)
484 reads
Grant EXECUTE permission to users
This procedure will assist in granting execute rights to a database user to all the stored procedures in a database The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to The assumption here is that the user already has access rights to the database mentioned […]
2005-05-05 (first published: 2005-04-19)
216 reads
Blogs
Microsoft Purview FAQ
By James Serra
I get many of the same questions about Microsoft Purview, so I wanted to...
Undercover Catalogue 0.4.5 Released – Database Module Bug Fix
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...
Saving Emergency Space on my Laptop
By Steve Jones
With my new laptop, one of the things I realized I’d forgotten to do...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
How to Add a New Shared Disk to a WSFC as a SQL Resource
Comments posted to this topic are about the item How to Add a New...
Question of the Day
Disabling Indexes
I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?
See possible answers