You know what... I completely misread your original problem. I thought you were saying that you were unable to reindex the DB until you recompiled this SP, which was...

Well, if I'm clear on what you're asking, it's about log files, right?

Well, truncating would be removing all inactive portions of the log. So your log is full with...

It looks like you're using a config file, right?

When you run something from bids, it runs from your local workstation, and when you run it from the server,...

You can't do it that way. You can backup to a network drive, but you can't enter creds in the backup command.

The way you're doing it, you...

It may be empty, but still physically the same size.

Do dbcc sqlperf(logspace) to see how full the log is. If it's showing nothing, then there's your answer.

Well, The simplest answer is always the best... so why don't you just do a join in your source connection?

Barring that, a lookup transform should get you there too.

So you're saying that your packages are now taking an extra minute?

If that's a huge problem, then have you tried seeing if something is blocking? Perhaps you have contention...

The point of a firewall isn't to block legitimate business. If he doesn't want to open it up, then just let the bosses know and they can deal with...

This is easy enough to look up in bol so try to do a little reading next time.

Here's what I got out of bol...

BACKUP DATABASE Sales

FILEGROUP =...

He's right... you can't attach downward.

There's no reason why upgrading your clients would effect the domain controller, so AD will remain in tact.

I've recently upgraded to vista too, and the only issue I...

No, you're right... recompiling and reindexing are completely autonomous ops and shouldn't have anything to do with each other.

Have you done a checkDB on it?

OK, what's the exact error?

Geez dude... table1 looks like it's severely fragmented... or severely under-indexed. To have I/O stats that far out of whack there's something going on there. That's what...

Hey there GSquared... at almost every place I've been, maint plans just stop working at some point. And they don't handle changes very well at all. I don't...