Updating the database using information_schema
I am having database a and b i want to update database a according to updations in database b .b is same as a operations are done on b database and after complition a will get updated for permanent change? how can I do this automatically by using information_schema in sql server 2000

Answer Question   |  November 14, 2008  9:55 AM
INFORMATION_SCHEMA views, SQL Server 2000, SQL Server INFORMATION_SCHEMA views, SQL Server synchronization

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

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

Answer Question   |  March 17, 2008  4:30 AM
INFORMATION_SCHEMA views, SQL Server 2000, SQL Server 2005