Biztalk Discoveries, Experiences

Should I Use the sp_ Prefix for Procedure Names?

SQL Server gives name-resolution preference to the master database for procedures that have the sp_ prefix. SQL Server looks for a compiled plan for the procedure associated with the master database and doesn't find it because, in this case, the sp_Select1 Read More...

Posted Tuesday, July 01, 2008 5:27 PM by Sundara Prabu .T | 1 Comments