I know how it goes. Good luck on it.

Any reason to not just try it, on a test/dev copy of the database?

I don't think it'll work, but I'm curious as to why you wouldn't just try it and...

Create the maintenance plan, but don't schedule it in the plan (if you know what I mean). Instead, create your own job that calls the maintenance plan, and also...

Instead of doing the AB, ABC thing, I'd normalize it and have one per row. That'll make the whole thing much easier to work with.

pss (3/10/2009)

---

If I understand correctly, Table B has a composite key of Id1 and Id2, each being a value in one or more of Table A’s primary key.

Do you have...

Set up a range on the various measures. For example, work out what the lightest IO load is (probably 0), and the highest acceptable IO load (will depend on...

Don't bother moving to another forum. No need to start over. If you like, you can edit the original post and just add something that says "Accidentally posted...

You need to move this:

set @nextcompanylocid = @nextcompanylocid + 1

Needs to be before the END for the While loop.

Yeah, best find out all the business rules first.

If it's not a...

I just maintain a practice in life, as on this site, of keeping my cynicism optimistic, and my elitism populist. It seems to work out for me.

I have to agree with Jay about being able to test against real data to ensure outputs are consistent.

At the same time, things like SSNs can be randomized without affecting...

GilaMonster (3/9/2009)

---

Yup. A group by on all columns in a...

You're welcome.

The default mostly captures DDL commands. I thought it would have linked servers in that, but I guess not.

Instead of trying to modify the default trace, you'd probably be...