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 |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2005-12-16 : 09:37:02
|
| It was fine. But now it's not!I have a 2 line stored procedure that creates a temp table. If executed from Query Analyser (exec sp_temptable) it creates the table.But when called from an Execute SQL Task task, it does not create anything, despite saying it was completed successfuly! AHHHH! |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-12-16 : 09:54:00
|
| It does create it...except it delete's it straight away afterwards. TEMP tables can have a VERY short life span....they die when out-of-scope.You may need to migrate up to a ##table. |
 |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2005-12-16 : 09:56:55
|
| But it is a ##table |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-12-19 : 06:08:28
|
| Well then you're beyond my level of (in)competance!You're original post didn't specify which type of temp table you were creating...detail is important to get faster results. |
|
|
|
|
|
|
Cannot call SP in Execute SQL Task (DTS)