Can you run the DTS interactively on the backup server?

If you're sure that you've reviewed all file accesses within and around the DTS and job, then monitoring to catch unknown...

The page at: http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx

shows that BI Development Studio is available with the standard and enterprise editions of the database. Express and workgroup get just the report designer...

I have SP4 on my desktop but SP3 on the server and don't see a problem like this. I used a select * where length(column)>900 to find rows like...

You can use the schtasks command (http://www.ss64.com/nt/schtasks.html is a good reference) to start a scheduled task, even on another server. You'll have to work out the permissions...

You have the right idea. The EXISTS is essentially done for each record in the parent and SELECT * FROM 19K will always return all the records in 19K...

Visual Studio is one of the hidden expenses of Report Services. Unless your shop skimps on licenses (it's very common), it can get expensive. Don't forget the extra...

These UDTs won't be terribly useful if they exist just in the database. They are a liability in that case. The real value is in the fact that...

I expect you'll see IntelliSense in SQL development tools soon. Though Microsoft does have a way of delivering truly useful development technology only after tantalizing developers with little bits...

Old fashioned rows are great. I use them all the time and probably will for a few more years. I haven't used UDTs yet, except maybe as constrained...

The reference and other sources indicate that a common problem is growth and proper growth parameters for TEMPDB. This is the simplest and an often overlooked parameter.

If...

Here's an example...

Let's say you are writing an application that presents a bill. That bill should not change over time and it's attributes won't be queried on for aggregation...

Databases don't have their own tempdb so several of these answers just didn't make sense. I have to say that it is common to use the terms "database" and...

The choice of example seems reasonable for demonstration, but does not seem at all reasonable for a real-world scenario.

The author asks the rhetorical question, "Why do we not...

This is a case of having to pick the "best" answer. Since the others didn't mention the table and weren't related, the "correct" answer was best. I can't...

They might resolve the misconceptions if they could write clear, explicit documentation and keep the web site up to date.

I guess we'll have to wait for Delaney to come out...