User SP on Master DB

Question

User SP on Master DB

VastSQL

SSC-Dedicated

Points: 36097
More actions
November 7, 2012 at 9:12 am

#264486

Hi Experts,
Is there any problem if developers create user SP on master DB??

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

George M Parker SSCertifiable Points: 5412 More actions · Answer 1

Ratheesh.K.Nair (11/7/2012)
Hi Experts,
Is there any problem if developers create user SP on master DB??

It depends on what you mean by "problem" and what the stored procedure is doing. While it's allowed, it's usually not best practice to create user stored procedures in the master database.

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 2

The procedure is used to take CPU statistics,backups,update statistics,shrink ,fragmentation etc.

These procedures i think created by DBAs but extensively used by developers.

George M Parker SSCertifiable Points: 5412 More actions · Answer 3

Ratheesh.K.Nair (11/8/2012)
The procedure is used to take CPU statistics,backups,update statistics,shrink ,fragmentation etc.
These procedures i think created by DBAs but extensively used by developers.

In that case, I would typically create a SQLAdmin or DBA_Admin database and install the stored procedures there. That being said, it doesn't "hurt" to install them in the master database.