Sharing knowledge does not lessen your store, often it gets you more. Success doesn't happen overnight and patience is key to living your dream life. Success is a journey not a destination
When I query the table via a Linked server, I get the following error.
Inconsistent Metadata
The workaround for this is to use OPENQUERY.
SELECT * FROM OPENQUERY(LinkedServerName, 'SELECT * FROM DBName.Schema.Table')
No comments:
Post a Comment