Linked Server Issue - SQL Server Forums

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 2005 Forums

Analysis Server and Reporting Services (2005)

Linked Server Issue

Author

Topic

avmreddy17
Posting Yak Master

180 Posts

Posted - 2008-08-06 : 17:11:42

Can I create the data set in the reporting service using the Stored Proc on a linked Server like this

EXEC [666-BO-TRMG].TradeManagerHistory.dbo.usp_GetATSReportByAccount 'RBCTECH2' , '08/05/2008'

and the 666-BO-TRMG is a SQL Server 2000 Server

It throws me an arr

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-08-06 : 18:31:06

Please Post the Error.