Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Linked Server

Author  Topic  vinothn Starting Member 1 Post Posted - 2010-03-17 : 10:08:58 Hi All, I am working on linked server. I need to pull data from server1 to the server2 for which I have written a CLR procedure and deployed it in server2. I have also linked the server1 to server2. I have employed a windows service which runs at a speccific time to pull the data from server1 using the CLR proc avail in server2. But when ever the procedure is executed through windows service there is an exception in the log stating " 'xxx' is unexpected token. Expecting white space at Line 1....". Please help me to identify the problem. Note: when I execute the procedure manually it works fine as expected. Cheers, Vinoth N