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 |
|
Beginer2012
Starting Member
45 Posts |
 Posted - 2012-06-07 : 15:07:19
|
| Hello,I have many SQL reports in one project. Each report has its stored procedure. I have a procdure load_data that loads data into a global table. The reports' procedures check if the global temp table exist and calls procedure load_data. However, I figured that each reports is calling load_data each time I call them. Does each report connects using a different database session ?Is there anyway to make it use the same session ?Thank you |
|
|
|
|
|
SQL reports database session