<div>
Does global temporary table work across steps in the SQL Agent job<br />
<br />
&quot;ALL connections using them go out of scope&quot;<br />
When step1 completes, there are no connects to the tables. Does this constitute ALL connections<br />
Then when step2 starts, (probably a different session id), can it see GTT<br />
<br />
Thanks<br />
<br />

</div>


Does global temporary table work across steps in the SQL Agent job

"ALL connections using them go out of scope"
When step1 completes, there are no connects to the tables. Does this constitute ALL connections
Then when step2 starts, (probably a different session id), can it see GTT

Thanks



<div>
yes, in that case it would go out to scope (even the global)...why not use a user-table instead?
</div>


yes, in that case it would go out to scope (even the global)...why not use a user-table instead?

<div>
<div class="content wysiwyg-content">
on a sql agent job created 2 steps<br />
step1 creates temporary tables by running sql script<br />
step2 reads these temporary tables, does some processing and writes to a new table<br />
<br />
what i found was, as soon as the step1, exists, the temporary tables disappears<br />
<br />
how persistent are the temporary tables. can it be used across different sessions<br />
<br />
Thanks
</div>
</div>


on a sql agent job created 2 steps
step1 creates temporary tables by running sql script
step2 reads these temporary tables, does some processing and writes to a new table

what i found was, as soon as the step1, exists, the temporary tables disappears

how persistent are the temporary tables. can it be used across different sessions

Thanks

temporary tables in sql server 2005 how persistent is it

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.