Russell,

You are the master. I finally understand!!!

Your clear example and comments finally made it come together in my head. I agree now that a constant on a left...

Jeremy,

I appreciate your detailed example, and have faced such queries myself. However, I believe what you present does not address my original point. You've given good reasons for...

Thanks for the comments. Yes, it works as described in BOL, just not as I would have thought.

How about some comments on the warning suggestion? Since the criteria...

A follow-up observation. Based on the explanation in BOL for outer joins, any criteria of inner join table column to a constant in an ON clause of an outer...

Gordon,

Based on the most popular "incorrect" answer, I'd say it was more than just you interpreting the...

You could, but its a whole lot easier to move a non-system DB. Just Detach it, move the files, then attach at the new location. You can detach/attach...

djohnson,

Thanks, I think you've uncovered a bug. Lines 5 and 9 need to have %2 and %3 in double quotes to handle the spaces you want to include in...

Brandt,

Ouch, sorry to hear that! If I had to guess, I'd say it might be due to other services like the Full-Text search and possibly analysis services not shutting...

Quotes are only needed when a parameter contains a space. No delimiter is needed. That is standard command line parameter passing. So in your example if you...

Michael,

Thanks, but I did that with the mssqlsystemresource ldf file intensionally. I believe MS expects both the MDF and LDF files for the Resource database to be in the...

OK, you guys got your wish. Please note that this is untested. I hope someone will test it and post the results! [/i]

Here is the MoveSql2005SysDbs.CMD file:

*****************************************

[font=Courier New]@echo...

Hi Ray, as you can see it is much requested. If I get the time I'll let post an update...

Vince

Great suggestions. If I get time to make the update I'll try to let you know. Work's picked up so not sure if/when that will happen...

Vince

Thanks, Robert, I'll add them in.

Andy,

I'm not very familiar with SMO or DMO, but you can only work with what portions of the object model are exposed. BackupDirectory is an exposed property, with...