Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Master DB and Schemas

Author  Topic 

stumbling
Posting Yak Master

104 Posts

Posted - 2009-11-24 : 23:33:15
Hi there can anyone tell me if it is common practise to create schemas in the master database?
Cheers

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-25 : 00:17:01
I never do. I figure if any objects need to be created for some reason or another, then it should be put into a user database. For my custom DBA-type scripts and other objects, I put them in a database named DBA. I don't see any reason to use master.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

stumbling
Posting Yak Master

104 Posts

Posted - 2009-11-25 : 05:10:53
Yeh i figure myself that it should not exist there but my developer is trying to pull the wool over my eyes on schemas and i have asked him to prove his point.

He is trying to tell me that if you want to share schemas between databases that you must insert the schema into the master DB?

This goes against anything i have ever read or researched or been trained on.

The way i see schemas is that they are used on a per DB level but is there a way to group schemas from different DB's? I know one user can own may schemas and one schema can have many users associated to it.

But i am off the rails when he try's to say that for users to be able to be associated to schemas from different DB's that this must be done at a high level in SQL. I do not comprehend this LOL.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-11-25 : 13:01:26
Have the developer prove it on a test system.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

stumbling
Posting Yak Master

104 Posts

Posted - 2009-11-25 : 15:51:28
Yep that is my plan for today Thanks for the replys.
Go to Top of Page
   

- Advertisement -