A while back I wrote a post, Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions Recently Manish Kumar asked an interesting question, what do you do if your proc accesses multiple or even all the databases on the server? So, instead of giving him a fuzzy answer in reply, I thought... Continue Reading →
Digitally Signing a Stored Procedure To Allow It To Run With Elevated Permissions
Have you ever had the need to give elevated permissions via a stored procedure above that what the user calling the procedure might have? Perhaps you've got a table in your database that contains top secret information and you only want that information to be accessed by via a proc, you're users are denied access... Continue Reading →
Scripting out SQL Server Objects without the GUI
I quite often find myself scripting objects out via T-SQL rather than using the GUI, it's not that I have anything against using the GUI to script out a Stored procedure, it's just that sometimes this can be time-consuming especially when there are alot of stored procedures in the Programmability folder. I know that... Continue Reading →