User Id :    Password :      New Member   Forgot Password  
Topic: Why not to use prefix sp in store procedure
Sachin Jain
29 Oct 2010 at 10:56 PM
Why not to use prefix sp in store procedure.

Re: Why not to use prefix sp in store procedure
Gaurav
01 Nov 2010 at 12:29 AM

These prefix is used by master database so SQL server first searches in the master database and then in the current session database. So its time taken is much higher master database causes extra overhead and also get wrong result in case of same name in master database.

Total Replies: 1
 
Featured Text Ad

Featured Ad