Good point in pointing that out. That was a typo. Where I work everyone uses usp_ as a prefix.
Jim On Sat, Feb 7, 2009 at 7:54 AM, Sreenivas <[email protected]> wrote: > >>>> cmd.CommandText = "sp_FooBar"; > FYI,Don't use "sp_" prefix for stored procedure names ,bcoz sql server > checks system stored procedures(e.g:sp_executesql,sp_helptext ) to see > it first,then it comes to execute user written stored procs .So its an > overhead you are adding to your sql server.
