SQL Tricks

Delete all tables EXEC sp_MSforeachtable @command1 = “DROP TABLE ?”  Grant execute permissions to all stored procedures to a specific user CREATE PROC grantexecutepermission( @UserName NVARCHAR(250)) AS DECLARE curse CURSOR …