Luke identified that it's no problem running it concurrently.

i call it ugly search becauuse it's not something you want production users to use, and image you have a 12 million...

this might help;

i create a proc i called "uglysearch" which searches every varchar,char,nvarchar and nchar column for a string.

it returns the table and column, as well as the sql to...

there's no builtin search specific to the cliptext window, but the file of snippets you collect is saved in the \EditPlus 2\ folder as a text file ending in .ctl,...

hope this helps...this is the model i use for find and replace in text fields.

in this case, the sample is replacing a relative HTML link witha full http: link,...

can you paste the query as text here as well? it helps to be able to see that as text and not as an image in order to help better.

lol encrypting is a good answer. way to go!

there's an excellent stored proc called sp_generate_inserts Written byNarayana Vyas Kondreddi

http://vyaskn.tripod.com

he's got one for 2000 and 2005 and it generated statements like...

you can use the table value function as a joined table or as an in() statment as well, if it's not obvious: i used a #tmp table,b ecause you might...

i think what you are asking for is exactly what full text indexing actually does.

it creates the word list for you, maintains an editable list of noise words, and handles...

Sergiy you've got a lot of experience; if you were starting from scratch, how would you handle an email notification requirement?

I'm sure I have developer tunnel vision with an email...

also to follow up on this part of your question:

Say I enter a record on 10/15. On 10/21 at at 12:00 am what happens to the table so that my...

well, here's what i would suggest; instead of tracking 5/10/20 day, lets keep the emailID of the email you sent because somethign was 5 days old.

[font="Courier New"]

CREATE TABLE tblTest

(

ID INT...

i disagree that a trigger is needed; part of the scheduled job should be doing a query like this:

select * from tbltest where...

the convert() function has some special formats when converting date time...the format 112 is what you are looking for:

declare @cmd varchar(255)

SELECT CONVERT(VARCHAR,getdate(),112) + '.txt'

SELECT @cmd='osql -E -S Servername -i d:\query.sql...

Hi Greg;

remember that a trigger needs to just handle data, and not do business logic like sending an email...an email might take 5 seconds to actually finish doing the handshake...