Putting sp_ at the beginning of your stored procedure.

(Kenneth Fisher) Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So what does that do and why should we care? The primary effect is that if you put a stored procedure starting with sp_ in master you can call it directly from any database.

Read More - Register for Free Membership