SG SQL Server Usergroup

Hey there SQL brethren,

we are encountering unexplainable behaviour with Visual Studio (Team edition for Database professionals), where we use a Database project that includes Linked server definitions. The description of the situation can be found at

http://sgdotnet.org/forums/thread/200894.aspx

would appreciate if anybody can explain what causes such errors to occur. Thanks.

Hey Bro,

Noticed on your post on SGDOTNET "The database table references are already fully-qualified. As of now, it resolved itself and works. Which we do not really know why and how."

Would you mind sending me a private message that contains schema definition of both servers and the link server definition? Would love to replicate the scenario on my side and figure out how the reason behind it.

Pom

We seem to have found the solution
http://sgdotnet.org/forums/202717/ShowThread.aspx#202717

Open up the stored procedure that has the "offending" Linked server/table reference and simply edit the file (with nothing) and re-save it.

We certainly cannot figure out why it works this way...