March 13, 2008 at 9:05 am
I was wondering if it was possible to create custom views in the master database that can be used from any other database.
The reason for this is that I have several views that query custom extended attributes from tables and columns used for documentation (e.g. MS_Description).
Currently I have to create these same views for every database, and when making updates to the views, remember to update every database.
I would rather create one single set of views in the master database that can run against any database, similar to the information_schema views.
Anyone have any ideas on if this is possible?
March 13, 2008 at 9:19 am
I would assume it is possible, although I do not know if you can add then to the sys sheba. I have added custom SPs to master for the same reasons. Of course I kept a copy of the create scripts elsewhere in case service packs or upgrades blasted them.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 17, 2008 at 3:45 am
Interestingly I can get it to work if I prefix the name of the view with sp_ but unfortunatly that doesn't work when I try to put the views under their own schema.
March 17, 2008 at 6:54 am
There's a back door that works in 2000, but the same method fails a permissions test in 2k5. Haven't found a way around it yet...
Funny how things are... I think 4 of us have all asked a similar question in the last 24 hours...
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply