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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-28 : 11:26:20
|
| reginald writes "Why is it that when temporary tables in stored procedures and triggers are used in loopings, the second up to the third row upwards is truncated and the loop variable was set to a null value? Considering I'm using MS SQL 2000 Advanced Server on Windows 2000 server, P4 PC 128MB RAM, 30 Gig hardisk partitioned to C: and D: - MS SQL 2000 placed on partition D:, tempdb data and log size set to 500 MB already. What should I do to arrest these problems? Thanks and more power to the SQL Team. What happens is when the trigger or stored procedure trys to update 4 rows only one up to the maximum of 3 rows are only updated." |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-28 : 12:14:19
|
| Reginald,Please post a sample of the code that is having troubles so we can review it. |
 |
|
|
|
|
|
MS SQL 2000 Temporary table rows truncated when used in loops and loop variable set to null value