>> That said, though, claiming it's detrimental to performance is wildly false.
Erm, no it is true... check BOL. Naming it with "sp_" can reduce reduce performance. When you call a stored procedure that starts with sp_, SQL Server always checks the master database first, even if the stored procedure is qualified with the database name. >From BOL. "Stored procedures with the prefix sp_ are first looked up in master. If a user-defined stored procedure has the same name as a system-supplied stored procedure residing in master, SQL Server always finds the system-supplied stored procedure. Expect different results as compared to earlier versions of SQL Server. Expect a difference in behavior when calling user-defined stored procedures with the sp_ prefix. Either explicitly qualify the name of the user-defined stored procedure, or rename the user-defined stored procedure." Also Google user stored procedures + SP_ -----Original Message----- From: Phillip Beazley [mailto:[EMAIL PROTECTED] Sent: 05 December 2005 14:10 To: CF-Talk Subject: RE: Stored Proc At 03:51 AM 12/5/2005, you wrote: >NOTE: You should avoid using "sp_" as the prefix for user stored procedures >- it can be detrimental to performance. The purpose of that, in this case, is use in any database without having to specifically create the procedure in each when created in the master database. I'd forgotten about mentioning that. You'd also need to grant permissions to it, a la: grant execute on master..sp_latLongDist to public ; If you're not the administrator of the database server, though, yeah - you should probably not prefix it and probably can't create it in the master database. That said, though, claiming it's detrimental to performance is wildly false. >-----Original Message----- >From: Phillip Beazley [mailto:[EMAIL PROTECTED] >Sent: 03 December 2005 16:15 >To: CF-Talk >Subject: Re: Stored Proc This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226064 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
