Home Forums SQL Server 2008 SQL Server 2008 - General Access table from different instance RE: Access table from different instance
Zeal-DBA
SSCarpal Tunnel
Points: 4332
More actions
December 19, 2012 at 2:13 am
#1569934
yeah OPENROWSET works, it requires connection string, it does'nt require linked server to configure, but "ad hoc distributed queries" should be enabled through sp_configure.....
thank you so much