Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases?
Home > IT Answers > SQL Server > Is there a way to create a view in Master in ...
SQL Server Ask the Experts
2445 pts.
0
Q:
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 views
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...
ASKED: Mar 18 2008  11:55 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Sep 20 2008  11:22 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0