I know that by using regular expressions, the \b is a word boundary; it might be a space/tab/Crlf, or it might be punctuation...period comma exclamation semicolon etc.

using regualr expressions, you'd...

SQL ORACLE is right...since "sa" never logs into the domain, it has no access to the computers and shares that exist on the network.

you'll have a similar issue if you...

I love SSC, and wander through it nearly every day .

things i'd like to see:

Something we had at one time, that was snipped out in the new design:

under "Recent Posts"...

that goes back to my original assumption...you said consecutive, and i stated my solution would work If you meant consecutive by the PK of the table...now you've changed the rules....

now...

my example still finds all suspected records...try it.

here's your statements cleaned up so they work:

the idea is joining the table on itself in order to do the comparison

--===== Create the...

well, text all the other blob typea are not allowed, but you can cast/convert to a varchar(8000) in order to work around it: this is typically what i would do:

Select...

here's the function:

I tripped over that issue as well;

below I pasted a function i made for encoding "illegal" characters, it might help you out to clean up the data, or get the...

ok, I'm assuming that by consecutive, you mean that the PK is an identity field, and that if you self join the table on itself by way of PK =...

behind the scenes, the GUI is creating a new table, then dropping the constraints on the old table,

dropping the table, renaming the new table to the proper name, and...

connections are not really handled by SQL server, but usernames/passwords/spids, once a conenction has been made is auditable.

If you need to know who is connecting by IP, you should capture...

yeah that binary AND-ING of a value isn't obvious;

basically, a binary array of zeros and ones, representing like 2^16 or something is used in status to keep track of on...

I have this laying around from a post i replied to previously: it does all the databases in one shot on a server, instead of calling sp_dboption repeatedly:

select name as...

I agree, it's a poor idea. It sounds more like the DBA gets confused with seeing thousands of tables, and to make it more "bitesize" he wants to move...

the Command SET XACT_ABORT ON makes error handling superfoulous.

This command rolls back the transaction, AND DISCONTINUES FURTHER PROCESSING, if any error is encountered....

so if any error is encountere,d it would...