You shouldn't use sp_ to preface your stored procs. System stored procedures in SQL Server start with sp_. You may end up with a collision one day... Also, any SP that start with sp_, SQL Server will first search the master database for that stored procedure.
----- Original Message ----- From: "Tangorre, Michael" <[EMAIL PROTECTED]> Date: Monday, July 15, 2002 9:09 am Subject: Slightly OT: DB Object Naming Conventions > Does anyone here follow the following naming convention in SQL Server? > > Tables: tbl_tablename > Views: vw_viewname > Stored Procedures: sp_procedurename > > I'm just tyring to get a quick poll as to who might follow this > way of naming.. > > Thanks. You can reply off list to me.. > > Mike > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists