Hello I have a linked server and when I execute this query, I can see the Database,
ex: ( http://msdn.microsoft.com/en-us/library/ff772782.aspx )
Select top 100 * from [mylinkServerName].master.sys.databases
I tried per this link - http://stackoverflow.com/questions/4091960/sql-server-linked-server-example-query
But when I try to query against one of the tables
I just get shown invalid object name for both of these
Select top 100 * from [mylinkServerName].[Mydatabase].[mytable]
Select top 100 * from [mylinkServerName].[mytable]
What could be wrong, what should I do ?:w00t:
Thanks !