Access 2000, Access 2003, Access 2007 forms, Access 2007 functions, Access Database, Access Forms Database, Access Functions, Access reports, Binary data, CSV, Data structures, Database administration, Database Backup, Database connectivity, Database design, Database issues, Database management, Database migration, Database mirroring, Database servers, DB2 administration, DB2 Universal Database, DB2 Web Query, DBA, DELETE statement, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, Indexes, INSERT statement, IT careers, JDBC, JOIN statement, LOOP statement, Microsoft Access, Microsoft Access subforms, Microsoft Access tables, MySQL, MySQL Database, MySQL query, ODBC, QMF, Query optimization, SQL queries, Sybase, Timestamp, Triggers, UPDATE statement VIEW ALL TAGS
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
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...
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