Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suspend report requests from a table during an update

Status
Not open for further replies.
ChuckGann

ChuckGann

IS-IT--Management
Jun 16, 2004
18
US
Hi Everyone,

We are using SQL 2000 and DTS to populate some tables with summary data from other SQL tables. As part of this, we delete records in the destination table and then re-populate from the other tables. Our problem is that users can run reports on this summarized data at any time, and if they order a report during the update it may return invalid data.

Is there a way to suspend the reports from accessing the destination table until the processes are complete?

Thanks.
 
Status
Not open for further replies.

Similar threads

Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
346
drlex
drlex
ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
336
gk53
gk53
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
496
markjoseph1232
markjoseph1232
HoustonGuy
  • Locked
  • Question
CPU usage of a package using tables on another server
Replies
0
Views
93
HoustonGuy
HoustonGuy
swhitten
  • Locked
  • Question
Writing view to table - fastest/easiest way?
Replies
2
Views
103
swhitten
swhitten

Part and Inventory Search

Sponsor

Back
Top