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...
Software/Hardware used:
Software/Hardware used:
ASKED:
March 18, 2008 11:55 PM
UPDATED:
September 20, 2008 11:22 PM
RELATED QUESTIONS
- ACCESS 2007 and SQL Server 2005 Schema Updates
- Create Information_Schema view
- Is there a query to search text of all SQL Server database objects that reference a specific table/instance?
- Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?
- Restore a View Sql Server 2005
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
