We don't provide dumps. We'll help answer questions and get your prepared if you don't understand things, but no dumps allowed on this site.

I agree with Bill. You need to study and go over the material as well as practice using it. If you have specific questions about what to expect, or you...

I'd love to do a "upgrade gotchas", but I haven't experienced enough. Maybe someone that's done a bunch or has a large environment can write me one!

The CREATE AGGREGATE seems...

I'd honestly start with 4 Guys from Rolla (www.4guysfromrolla.com) and go through some of their early ASP.NET stuff to get started.

If you have a bunch of people that need...

I think if you can control it and not fall apart if things don't go well, it's idiosyncratic. If it stops you from functioning, it's OCD.

Despite my daughter's attempts to...

You'd have to restore a backup of msdb. I'd try restoring one on another instance and then save the packages out as structured storage files.

You also might try opening them...

Sorry haven't seen a free one. Bug your boss, he should spring for the utility. It's not that much.

Third confirmation here. Whack the plan and re-set it up. I'd also check the logs for the plan and see if anything else is amiss.

The account can only connect to the instance it has rights to.

BTW, what's the app? Dynamics used to say this and I convinced them they were wrong.

Both are cars , 74 914 and an 88 911. The kids aren't quite there yet.

Hey, I've got a 33 year old car and a 19 year old one as well. I like old cars, but the wife doesn't. But she likes the Prius, which...

Congrats!!

I try to keep work in perspective and make the other parts of my life more important. Kids, spouse, hobbies, all are a good way to get away from the...

I'm not sure about the snow. It will certainly be something to watch, but my wife's big 2500 diesel should get us out. Or my 40hp tractor

I've done a DROP TABLE as the first task, then a CREATE table, then the transform. 3 tasks and that's worked.