accessing remote databases for data query updates in SQL Server Query Analyzer (OPENROWSET)

Enable AD Hoc distributed Queries:

' Show advanced Options ', 1

Reconfigure

' Ad Hoc distributed Queries ', 1

Reconfigure

When you are finished using, close ad Hoc distributed Queries:

' Ad Hoc distributed Queries ', 0

Reconfigure

' Show advanced Options ', 0

Reconfigure

Operation:

' SQLOLEDB ' ' SQL Server name ' ' User name ' ' Password '

' SQLOLEDB ' ' SQL Server name ' ' User name ' ' Password '

' SQLOLEDB ' ' SQL Server name ' ' User name ' ' Password '

' SQLOLEDB ' ' SQL Server name ' ' User name ' ' password ', database name. dbo. Table name) as

accessing remote databases for data query updates in SQL Server Query Analyzer (OPENROWSET)