ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 sql report, locking

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
jknowlton Posted - 02/07/2006 : 15:43:36
Hi,
Our DBA instructs us to query our sql server database using nolock hints like this: Select * from table1 (nolock)
My question is, with Report Portal SQL Designer, do we now have to write our sql this way (nolock) phrases to the sql we create? Or, perhaps it would automatically not lock?
Thanks,
Jeff
1   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 02/13/2006 : 23:49:01
This feature is added to Build 100

http://www.reportportal.com/forum/topic.asp?TOPIC_ID=266

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page