I think what you are looking for is almost built in:

in MS SQL Server Management Studio, browse to Server>>Security>>Logions (NOT [specific database]>>Security)

right click on the existing user you want to...

I believe you simply have to shrink the msdb database.

running sp_cleanup_log_shipping_history will remove rows from the history tables, but that just created free space--the space is still reserved for future...

you created them using your admin account, but when you connected with SSIs Express, did you connect as that same user, or as a SQL Server login, like 'sa'?

that might...

can youc hange your primary key? instead of using some integer value, use the combination of HandheldId + Image_Surr_Key; that way Image_Surr_Key can repeat, but the combination of handheld...

I put a copy of PKzip25 in a zip file, along with a .SQL file containing an example, which you can download here

yes, the logic is the...

when converting a number to datetime, the date portion is left of the decimal place, and the time portion is to the right of the decimal point.

I think it really...

Matt Miller (2/27/2008)

---

Lowell - if you're on 2005 - use CLR instead to create the REGEX expressions instead. The XP is nice in 2000, but you can do better...

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: