General rule, you dont put user procs in master. When running if you
have the procs in you prod database sql will only look at that database
for the proc. You want to avoid having sql look at the master
unnecessarily. Also make sure your procs dont start with sp. This will
cause sql to look at master first for the proc before you prod database

Bainton Matthew wrote:

>Todd,
>
>This is admin stuff, too.
>
>I asked because somewhere in the back of my mind I could swear I read this sort of thing should be avoided where possible.
>
>Thanks,
>
>Matthew
>
>-----Original Message-----
>From: Todd Harness
>[mailto:mssqldba-ezmlmshield-x17687771.[Email address protected]
>Sent: 30 March 2005 18:49
>To: LazyDBA Discussion
>Subject: RE: User Stored Procedures In Database master
>
>
>I have some administration stuff that has to be run from master so I have those Stored Procedures there but not anything a user would need to run.
>
>-----Original Message-----
>From: Bainton Matthew
>[mailto:mssqldba-ezmlmshield-x47422406.[Email address protected]
>Sent: Wednesday, March 30, 2005 9:46 AM
>To: LazyDBA Discussion
>Subject: User Stored Procedures In Database master
>
>
>All,
>
>Just a quick one, what are people's attitudes towards having user-defined stored procedures in the master database? Yes? No?
>
>I'm only after a general consensus - but I'll provide more detail as to why if people really want to know.
>
>Thanks
>
>Matthew
>
>
>...
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>...
>
>...
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Website : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>For additional commands, e-mail: mssqldba-[Email address protected]
>
>
>
>
>

MS Sql Server LazyDBA home page