User SP on Master DB

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » User SP on Master DB

User SP on Master DB

Rate Topic

Display Mode

Topic Options

Author

Message

Ratheesh.K.Nair

Posted Wednesday, November 07, 2012 9:12 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 2,415, Visits: 3,375

Hi Experts,

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

Post #1382046

George M Parker

Posted Wednesday, November 07, 2012 9:28 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 09, 2013 1:13 PM
Points: 516, Visits: 1,004

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.

Post #1382054

Ratheesh.K.Nair

Posted Thursday, November 08, 2012 1:36 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 8:57 AM
Points: 2,415, Visits: 3,375

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.

Post #1382319

George M Parker

Posted Thursday, November 08, 2012 8:18 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, May 09, 2013 1:13 PM
Points: 516, Visits: 1,004

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.

Post #1382525

« Prev Topic | Next Topic »

Permissions