SQL Server schema
Hi,    How can i get the user names assigned to the Schema through (T-SQL) Regards; Rino

Answer Question   |  May 25, 2010  10:51 AM
SQL Server, SQL Server schema, T-SQL

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   |  September 20, 2008  11:55 PM
INFORMATION_SCHEMA views, SQL Server 2005, SQL Server schema