In our database, we generate statistics by periodically calling a large number of stored procedures in the event.
Taking into account that there are two SP
Is there a conflict when using the same temporary table name?
temp1) in both stored procedures?
I checked the Questions and Answers in SO, they say that the scope of the temporary table is the current session. I think it means when we connect the db server with the clients.
But in my case, all the sps run on the server side. So, could someone explain this?