InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 00:53:07 GMT20http://www.sqlservercentral.com/Forums/Topic889469-1631-1.aspxA cut and paste of the generating code from Safari (and Explorer) browser to SSMS on Windows 7 copies a number of invisible characters and corrupts the code. I don't know what the characters are but they are at the beginning of some lines and are not tabs, spaces.-Shrug-DamianMon, 03 Jan 2011 12:07:51 GMTdamian.wisehttp://www.sqlservercentral.com/Forums/Topic889469-1631-1.aspxSome linked servers are set up to only work for a given set of windows authentications.So, the job needs to be set up to run as one of those users.There may be some system admin tasks that have to be done to jiggle with the account settings so that will work.It's also possible to loop thru the list of linked servers and automatically test all of them either don't require a specific login connection or which require one but you are on the list.Don't have sql server up and running at the moment, but there are two system views, both obvious as dirt because of their names, that you can use for that purpose.Wed, 31 Mar 2010 05:25:08 GMTdavid_wendelkenhttp://www.sqlservercentral.com/Forums/Topic889469-1631-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL/69864/">Linked Server Connectivity Test</A>[/B]Wed, 24 Mar 2010 19:24:53 GMTr5d4