You could also try wingrep http://www.wingrep.com/download.htm. All the
fun and power of Linux file searches with a nice Windows GUI :-)
Shane
On 2/14/07, Scott Thornton [EMAIL PROTECTED] wrote:
thanks for all advice.
I will look into agent ransack, and agree its about time I tried Eclipse
Hmm,
The regular expression below does not work for me.
Using Agent ransack there is a Test option. It doesn't work with the test
phrase:
INSERT INTO MY_TABLE_NAME WITH (NOLOCK)
Oh well.
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hi,
A database I connect to is being migrated to the above.
I've connected to and tested my stored procedures etc, but wondered if anyone
has encountered any problems \ gotchas when connection to a 64 bit edition of
MS SQL? I imagine that there should not be anything, and I can't seem to find
(insert into).+(with \[nolock\]) -- note the square braces.
That RE would match:
INSERT INTO MY_TABLE_NAME WITH [NOLOCK]
but not:
INSERT INTO MY_TABLE_NAME WITH (NOLOCK)
Try:
(insert into).+(with \(nolock\))
Note that with most RE engines, the entire match must be on one line.
The
Hi Scott,
nope, we have never had a problem with it - just connect as per usual and
away you go...
(stopping idiots installing 32bit software is another question)
Lucas.
On 2/15/07, Scott Thornton [EMAIL PROTECTED] wrote:
Hi,
A database I connect to is being migrated to the above.
I've
Scott, if by the expression below you mean the one I gave you, I said I
had run it in AgentRansack and it had found files with that very SQL
statement in it. I didn't try the test option, but it did work. Have you
tried it other than the test?
/Charlie
http://www.carehart.org/blog/