September 22, 2010 at 1:48 pm
Alvin Ramard (9/22/2010)
Hold on.We don't know if the problem was caused by a trigger, a view, or anything else.
We also don't know what problems might be caused by using a new table.
Please, be careful before offering suggestions based on assumptions.
What Jason just posted will help look for a trigger, but we don't know if that is the problem.
Sorry for the way the above may have sounded. I was a bit quick in posting.
Replacing the table name that was in the stored procedure with a new one may not be a good solution. Does the original table need to be updated? Are there other processes that query the orignal table that will now be hitting the worong table? These are just a few possibilities for what might go wrong.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 23, 2010 at 8:41 am
Alvin,
I'll first say thank you for the advice and I'll take that to heart but that decision is not mine to make. The network that we have is small (we have a staff of 3 that do design, implementation and admin) and my superiors would comment to me that "if it ain't broke don't fix it." At some point in the future I may be able to sway them in some way to do as you suggest.
Secondly, as this is more "development" than live deployment, I stage my development with a test environment first before I ever make anything live. This implementation is not going to be live until all of this is worked out, and as this is the only data manipulation that is going to be done, I'm pretty secure that we won't make a mess out of it.
Thank you
Doug
September 23, 2010 at 8:44 am
You're welcome, and good luck.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 23, 2010 at 8:55 am
Doug,
Good luck as well, and feel free to keep asking questions there. That will help you learn.
If you get stuck often, I'd continue to push for some hired help. Not permanent, but if you have specific issues, having a consultant that you can call for an hour or two can be a great investment. Making that case over time, or maybe even a 2-4 hour trial run, might really help you.
The important thing is that you learn while you're doing, whether that's here, or with a consultant.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply