Moved to 2005 forums.

The only way I've seen to synchronize these is manually. You need to script them out and move them as they change.

I think that query is a little broken at times. Not sure why, and it's a low priority. Sorry.

Please check the forum before posting. Moving to t-SQL

Sorry, slip of the finger. They are supposed to be hidden until that date, but I checked the wrong box. I'll clean it up.

Well, I'm one of the people running the public speaking merit badge for the local Boy Scouts, so hopefully I've learned a few things I can pass on.

I think part...

MCA - Technical

MVP - community

the MVP can include technical work, but there are people that just support the Microsoft community in some area, like me, that don't necessarily do...

Not to mention she might trip you or toss you off the track if you get too close!:w00t:

Here, here, be polite.

Ignorance != lack of intelligence.

I voted MVP, because I think it has more recognition, and it's more likely you can attain it. Both require hard work, but...

Working my way though college (and later) as a bartender/waiter, got to try lots of things I might not otherwise have done so.

Now I like to relax with a nice...

IF you are using something like a maintenance plan, and that's a good idea as you get started, be sure you enable logging. When something fails, check the log file,...

The order of the SELECTs shouldn't matter, AFAIK. The query optimizer is supposed to know what is where in a partitioned view and not query those sets that don't apply.

Not...

Couple things, is the type of job an OS job?

Also, you might need to give the entire path to cscript to get it to run. I'd run a dir *.*...

Congrats for passing the exam!

I'd agree that moving to 2008 makes more sense. It kind of "includes" all the 2005 knowledge.

Sorry, sp_trace_setstatus

http://msdn.microsoft.com/en-us/library/ms176034(SQL.90).aspx

Something must be starting it.

Don't forget that cloning doesn't mean you ignore data safety/control issues. Keep that production data safe! Even in test VMs.