Jeff Sims-413169 (8/27/2012)

---

I have a table that is storing the data file information. I need to pull out of that table the SUM of file_sizes located on each...

We restore the bulk of our DBs daily from a DR copy - might be my pessimistic nature but I'd prefer to know my backups are good rather than assuming...

Thanks Gazareth and Gail for the quick response!

Nope. The raw data was deleted off this server...

It would help to see the table definition and query you're working with but are the 4 columns in question the only 4 being used from that table? I...

Unfortunately we're not only upgrading from 2000 to 2008 R2 but we're also migrating over to a new domain which doesn't trust (and I'm told will never trust) the existing...

Thxs Jeremy but no dice.

Changed the "path" system variable, rebooted and am still getting the "SQL Server 2000 DTS Designer components are required to edit DTS packages..." message.

Yep, my bad Elliott.

However that was where I put them, I just forgot to note it in my steps taken.

Bump - I'm also having this issue.

Short background on what I'm trying to do: modify a DTS package originally from SQL Server 2000 in 2008 R2 64-bit (Windows Server 2008...

Yep, my bad.

I'd have to agree with Sean about not needing a loop for this but if I understood your question, what's causing your infinite loop is the "while (1=1)" condition.

Elliott Whitlow (9/22/2011)

---

I would also reject any code that does not fit the spec and make them fix it. It would not take much time before the developers started...

Thanks Scott, makes sense.

pjdiller (9/22/2011)

---

Once the configuration wizard is run and SMSQL knows where all your datafiles, filegroups, etc are distributed on whatever volume they're on, I believe SMSQL will...

Yep, it helped feed my growing unease for implementing SMSQL.

We're currently in the throes of carving up an aggregate for 4 db...

Yep, based on your scenario (updates & variable length columns) I'd leave some room in an attempt to minimizing page splits as Gail pointed out. The only time I'd use...

This gets you the second requirement. Sure it could also be used to back into the first. Best of luck with this.

DECLARE @tmp TABLE (

strLastName VARCHAR(50)

, strFirstName VARCHAR(50)

, datAdded DATETIME

,...