I did not realize that XCOPY was going away. I better start reading up and converting over to ROBOCOPY then.

I guess an ex-girlfriend in Cols counts..... 🙂

Unlike most people I have hardy ever been out of Ohio. I think I have been in 8 states total....

Columbus OHIO USA. I came here in 1983 to attend college and stayed. Previous to that I lived 45 miles north of Columbus. Kind of a boring...

YES.... Bring on baseball, above freezing temps and melt this snow so we can see grass here in OHIO!!!!!! First spring training game on TV is Friday!

If I understand you correctly use the windows XCOPY routine,

xcopy G:\backup\*.* \\otherserver\E$\backup2\ /d /c /y

The only way to change the database collation is to create a new db with the different collation and then move the objects and data into it. There is...

This is one of the most difficult things to figure out what is the culprit. I know from experience. I even envolved Microsoft Premiere Support. We were never...

Great script. I am going to add it to my bag of tricks! Thanks!

Yes, this week the all start reporting. (as the 20 inches of snow begins to melt here in Ohio and the Reds report to their new Spring Training home...

Great, Thanks!

Ah yes....if I close my eyes I can feel the sunshine now.... I say that as it begins snowing here on the way to a 30 hour snowstorm that we...

Oh I don't know... I have not seen any big signings by the Orioles in the off season so I can't say they could be over .500. As many...

I think the # of servers/databases one supports can be misleading. Here we have 25 prod servers running about 300 dbs production only... not counting test.... 200 of them...

I too never create stats stuff manually.

The other 'tool' to use for creating indexes is just to put the query into the explain tool, see what indexes it...

It is not that. This job has several steps and it backs up two dbs and file copies the backup files to the non production server. The other...