Hello, I have two linked sql servers, of which the remote server has a \ in it's instance name,
I've tried brackets, no brackets, escape characters, however I can't seem to get T-sql to recognize the remote server name. Can someone provide some advice?
SET TRM1 = (select count(*) from [DDSNPBK2\CUSQl2008].[BWR].[dbo].[history] where station like ('MITLB1%') and Convert(Char(10),h_time,126) like @Today )