Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases?
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...
Answer Question
| Mar 18 2008 11:55 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server 2005, SQL Server schema, INFORMATION_SCHEMA view
Create Information_Schema view
Back in 2k, there was a backdoor that allowed you to create an INFORMATION_SCHEMA view. Backdoor yeilds a permissions error in 2k5. Is there any way to create a view in Master that would be accessabile from all databases like the Information_Schema views?Thanks for the help...--Jeff Moden
View Answer
| Mar 17 2008 4:30 AM GMT
| asked by
Jeff Moden
INFORMATION_SCHEMA view, SQL Server 2000, SQL Server 2005
