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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

record lock

Status
Not open for further replies.
aka45

aka45

Programmer
Apr 4, 2006
13
US
how to avoid record locking in SQL server while querying through crystal reports? is there a way to insert with NOLOCK when we send a query?
Thanks in advance.
 
Sort by date Sort by votes
A query from Crystal shouldn't be doing an insert anyway, so I don't understand the question.

I generally suggest setting up a user account for all Crystal Reports that is a read only account.

-k
 
Upvote 0 Downvote
I am not inserting the records.Reports are running against a production database and when the table is very large its locking the table.
 
Upvote 0 Downvote
Crysal does not have the No lock option available, and it does lock the database when using big tables.

a work around would be to use commands or Stored Procedures and write the (No Lock) in the Sql statement


-Mo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

dovl
  • Locked
  • Question
presenting all records that meet a condition plus the first record only that does not meet the cond
Replies
1
Views
594
lbass
lbass
sal21
  • Locked
  • Question
create report without database in vb 6.0 and recordset
Replies
0
Views
611
sal21
sal21
lm1340
  • Locked
  • Question
How to only get records that have data in at least one of many tables 1
Replies
2
Views
603
lm1340
lm1340
Almie
  • Locked
  • Question
Display record with identical field data
Replies
2
Views
121
hilfy
hilfy
DJWheezyWeez
  • Locked
  • Question
Dynamic parameter not showing every record 1
Replies
1
Views
99
PeterDimitrov
PeterDimitrov

Part and Inventory Search

Sponsor

Back
Top