Home > IT Answers > SQL Server > Is there a way to create a view in Master in ...
Help

Question

  Asked: Mar 18 2008   11:55 PM GMT
  Asked by: SQL Server Ask the Experts

Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases?


SQL Server 2005, SQL Server schema, INFORMATION_SCHEMA view

In SQL Server 2000, you can use a backdoor to create your own view in INFORMATION_SCHEMA... In SQL Server 2005, I get a permissions error though. Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases like the INFORMATION_SCHEMA views? Thanks...

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Sep 20 2008  11:22 PM GMT  by Mrdenny




I do not believe that there is any way to do this. It appears that Microsoft has removed our rights to the sys and INFORMATION_SCHEMA schemas.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register