By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

SQLServer 2K Update problem

P: n/a

Hi, I have problem sometimes when updating fields in a table in
SQLServer 2K. The fields are updated in a table from VBScripts using
ODBC connection. The problem is happening intermittently, once in a
blue moon some of the values gets updated out of 5 and sometimes none
and many times it will be working fine. I am lost where to find the
problem ? Is it in connection or Database or ??? So is there any
possibilities to check whether the ResultSet Update statement in
script has successfully performed updation or not ? Can I catch any
exception of resultset of the querydone or any indicator of rows
affected by the query ?
--
Posted via http://dbforums.com
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You need to probably open up "Profiler" and set it up to watch your sql
server for a while.

Once you notice a value hasn't been written, go over and pause the profiler
trace and start looking for problem sql statements.

Profiler has lots of capability, so be sure to look over the pages to get it
setup to capture just what you need otherwise you will bury yourself in data
to analyze. I would recommend watching the prepared t-sql statements if you
are issuing queries in code rather than using stored procedures.

Have fun, it's a great tool for solving mysteries.
"umeshgk" <me*********@dbforums.com> wrote in message
news:35****************@dbforums.com...

Hi, I have problem sometimes when updating fields in a table in
SQLServer 2K. The fields are updated in a table from VBScripts using
ODBC connection. The problem is happening intermittently, once in a
blue moon some of the values gets updated out of 5 and sometimes none
and many times it will be working fine. I am lost where to find the
problem ? Is it in connection or Database or ??? So is there any
possibilities to check whether the ResultSet Update statement in
script has successfully performed updation or not ? Can I catch any
exception of resultset of the querydone or any indicator of rows
affected by the query ?
--
Posted via http://dbforums.com

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.