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.
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 |
|
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. |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
stumbling
Posting Yak Master
104 Posts |
Posted - 2009-11-25 : 15:51:28
|
Yep that is my plan for today Thanks for the replys. |
 |
|
|
|
|