I find the replication put many sprocs with sp_ prefix in our database. Do
you think that should be changed? I have been told not to use sp_. See
http://www.sqlmag.com/Article/ArticleID/23011/sql_server_23011.html.
Have never really thought about it, but I suppose the reasoning is that it's
a good way of differentiating these stored procs as system ones. If you are
concerned about the performance issues, then you could raise a connect
case...
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
Showing posts with label doyou. Show all posts
Showing posts with label doyou. Show all posts
Tuesday, March 6, 2012
Subscribe to:
Posts (Atom)