This is really a scripting problem. You can host this in DTS, but you'll be writing VBScript that can be run from the command line as easily as tucked inside...

SP2 had an issue and there were updates postSP2 that corrected issues with this task.

Jack makes a great point. Often the person that pushes the project through or gets it approved doesn't use the system. They "think" that people need something new, and if...

You can reply to a previous thread or topic and post an answer that way (or a new question).

The linked server syntax is four part naming, so server.database.schema.table.

Haven't heard of anything. What does the package do?

You might need to call Microsoft support for this.

What are the steps?

In the job properties, is each step set to move to the next step on completion? Are the jobs the exact same jobs in both instances?

You could...

Agree, add the user to the role rather than aliasing.

You can set the Execution Plan on in SSMS and check the costs yourself to see the differences.

We definitely need a GUI for Service Broker. I'm not sure one's coming in SQL 2008, but there is a lot of work being done on the manageability and tools...

Sorry, the link is fixed.

Please don't cross post.

The Monthname function will get you the month name, you can use datepart to extract the others, and then concatenate the strings together (CASTing required for the...

Once you have the month, you might need to use the Monthname function to get the full name. Look up date functions in Books Online.

The subquery allows you to find the date you want, the correlation does it for each client.

It's the way I'd do it as well.

Assuming you have downtime, you need to have both sets of storage visible to the server. This would allow you to "detach" and attach" the databases.

- You would "detach" the...

It will support quite a few, mainly dependent on you storage hardware. There's no good answer to this question as the type of query, complexity, indexing, as well as hardware...