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 |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2008-08-18 : 14:59:03
|
| Hi guys, I have one issue that I am not able to get any hint on. Please let me know if you have experienced this. I made copies of tables in a temporary databsaes. Copy is done in groups. When I run the process (SP) couple of times, all the tables are not copied from all groups and in every run, new set of tables are not copied. For instance say if table 1, 2, 3 were not copied in run1, in run2 table 5, 6 might not get copied. What might be the problem? Can it be coz of space issues eventhough the SP did not fail? Thanks guys for any reponse on this. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-08-18 : 15:22:17
|
| We can't possibly answer that question without the code. Why don't you run the statements (of the SP) in a query window statement by statement outside the context of the SP. You can check for success and/or problems as you go along. It will probably be obvious when you encoutner a problem or error.EDIT:If you have a lot of control-of-flow statements in there be sure to test that your execution flow is what you expect.You can also add print statements at all the steps so you can examine the "log" afterwards to check your code flow, execution times, rowcounts, etc.Be One with the OptimizerTG |
 |
|
|
|
|
|
Copying Tables Inconsistently