While you're looking at robocopy, you might want to look at forfiles.exe also.

On most of our new servers, we have enough space to maintain several days backup history, so I...

Excellent question. Then I noticed who the author of it is, and realized... but of course!

It works on my 64-bit 2K8

The Dixie Flatline (2/5/2010)

---

I loved the touch of Ella, bb.

Wayne, and anyone else, I've taken the liberty of creating a forum specifically for DBCC TIMEWARP here.

"SSC ... it's not a...

Hey Steve... If us "Thread-izens"...

Right-click your Excel Source, and select "Show Advanced Editor".

Go the the "Input and Output Properties" tab.

Expand the "Excel Source...

ronaldkrex (2/5/2010)

---

I was just going to tell you I figure it out. You have Been very very helpful. Thank you so much. What do I do to vote for you...

The only ramification I can think of is what you've already stated: all of the domain accounts that services run under will need to be changed. Not trivial; but not...

by default, excel text fields have a max length of 255 when importing. If using larger than this, you'll need to set up that field as a memo and not...

I get that SQL keeps statistics on temp tables, but no on table variables. But I'm not clear how statistics on my temp table (or lack thereof on my table...

Does this do what you want?

select top 26 replicate(char( row_number() over (order by object_id)+64),3)

from sys.objects

If you want the word, then try putting a space before/after the wildcards.

To handle the situation when this word would be at the beginning/ending of the column, add a beginning/ending...

Chris,

Close, but you haven't given us quite enough information yet. Please provide DDL (CREATE TABLE) for the tables, and DML (INSERT INTO) statements to make and populate the tables. See...

I personally feel that this was the proper course of action for you to take. What...

@jeff - thinking outside the box again...:smooooth: