atikdesai (2/24/2011)
Actually this SP has been developed by some other person and he left.
Well that sort of thing happens from time to time 😉
You should still be able to understand what it is doing, and why it needs to create a real table. It seems unwise to modify something you don't understand yet.
Please tell me how I can sign the procedure with a certificate or key to grant CREATE TABLE within the procedure only.
There is a Microsoft tutorial here:
http://msdn.microsoft.com/en-us/library/bb283630.aspx
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi