What edition of SQL Server are you using?

Do you have backups for the master database?

Wait till it's done running, and if it's got problems, backups will be your easiest way to recover it, most likely.

Start by communicating more with the senior people in your team. That sounds like the way to go, in my opinion.

Sounds to me like the master database may be having a problem. Have you run diagnostics (DBCC CHECKDB, etc.) on master?

Just to chime in, I'd go with SSIS. It's designed to do this kind of work. It's easy to get started in it (at least, I remember it...

You'll need to verify the command line parameters of the plan, as per the error.

Mike Austin-398977 (8/15/2012)

---

By your reasoning, all of us should be required to take a course in transmission repair before we're allowed to drive a car.

IMHO, the legacy the...

Split the query vertically, based on 0 vs non-0 in UnitsInStock, assign a "SortValue" column in each of those queries, union the two queries together, then do an outer query...

Not sure entirely what you're asking, since the post seems incomplete, but it's looking like a typical "you need a Calendar table" type question. In a Calendar table, you...

call.copse (8/15/2012)

---

All sounds fine to me GSquared. I would expect such a perspective from a DBA type. I would whole-heartedly agree with having one person in charge of the data...

I can't speak to the Sharepoint part, since I don't admin that, but on the rest of it, side-by-side is going to be easier to fail-back from, but takes a...

The solution is more communication with him. Keep it simple, keep it short, but keep it going regularly. It will help.

If he's actively hostile, that's a different situation...

call.copse (8/15/2012)

---

Ouch! Nice monstering GSquared! I'm sure I deserved it.

By default if you query an object in EF / L2S you will get all (mapped) columns back. This is not...

Don't bother with C. Make everyone learn Malboge (http://en.wikipedia.org/wiki/Malbolge).

More fun that way.

I have a Galaxy 10.1, but I hear they can't sell those any more in most markets, till the lawyers are rich enough ... er ... the lawsuit is resolved...