Re: Validation query
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 05/12/04
- Next message: Ralph Sharett: "Concatenation help needed."
- Previous message: Tom Moreau: "Re: Can you use osql in DTS?"
- In reply to: Bob Lee: "Re: Validation query"
- Next in thread: Bob Lee: "Re: Validation query"
- Reply: Bob Lee: "Re: Validation query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 12 May 2004 17:55:03 -0400
Why not just attempt to run the real query and if it fails, take appropriate
action? Why do you need to check if it is up first?
-- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql . "Bob Lee" <wliuei@hotmail.com> wrote in message news:eLSH0WGOEHA.2704@TK2MSFTNGP10.phx.gbl... Thanks your comments, Bojdiar, Tom. A further question: when I use the validationQuery, it seems to me adding an extra "query" on each connection. I am wondering this could cause an overhead on the transaction. The performance is a big issue on our application. How much will it affect the performance? Thx. Bob *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
- Next message: Ralph Sharett: "Concatenation help needed."
- Previous message: Tom Moreau: "Re: Can you use osql in DTS?"
- In reply to: Bob Lee: "Re: Validation query"
- Next in thread: Bob Lee: "Re: Validation query"
- Reply: Bob Lee: "Re: Validation query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
