Home > IT Answers > SQL Server > Create Information_Schema view

Question

Asked: Mar 17 2008 4:30 AM GMT
Asked by: Jeff Moden

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

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

Help

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

IMPROVE THIS ANSWER

View History

RATE THIS ANSWER

0
Click to Vote:

Last Answered: Mar 17 2008 6:36 PM GMT by Mrdenny

Not that I know of. Everytime I've tried to create an object in the sys schema I get an error.

What's the end result of the view you are trying to create? SQL 2005 has tons of data exposed via the DMVs.