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.
| Author |
Topic |
|
julechka
Starting Member
2 Posts |
 Posted - 2011-09-19 : 15:33:58
|
| Hello,I have a stored procedure that lives in DB1 joins tables from DB1 and DB2. The stored proc works great when I run it in management studio.However, when I call it from SSRS report it returns blank.in SSRS I set up a datasource to DB1 (where my stored proc lives) and loaded my dataset.My guess is that ssrs doesn't like it that i don't have datasource going to DB2? But why should I, since the logic is in stored proc.Anyone run into this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-20 : 02:49:17
|
| seems like its getting timed out when executing in ssrs. Normally how long does stored proc take to execute in Management studio? also if its possible try to prepopulate a table with data from DB2 and then use it in stored proc rather running linked server query each time to fetch it from DB2 when report is rendered ( i assume its in another server)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSRS join across databases in stored proc