Search This Blog

Monday, March 2, 2009

Stupid SQL Tricks

http://www.sqlservercentral.com/articles/Administering/procedurecache/591/

Do not use sp_MyProc. SQL server will look for the stored procedure in Master database first. Name the procedure spMyProc and it does not happen.
Posted by Gary Kindel at 11:30 AM
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)