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 - 2001-07-24 : 08:26:38
|
| David writes "In a system which equipment is writing log records to a sql db table 'A' via ODBC on a realtime basis if I run a stored procedure to update from table 'A' to table 'B' what chance is there of preventing log records being written to 'A'. Will table 'A' lock any uncommitted records as the stored procedure updates table 'B' and what locking should I define to prevent this happening." |
|
|
|
|
|
Record locks on database at Update time