What are the partitions based off of? Since you are switching partitions based on DATE, is each partition year/month combo?

I second, third, whatever the old format!

I loved the featured content being right at the top of the email so it can easily be read through.

I've done something similar a few months ago ... however I just used a BCP out command to generate the files inside SSIS.

The overall flow was something like:

Sounds like you are being asked if you want to have automatic deployments happening to all your environments.

Is that the goal of managing the DB via TFS or...

I know this is an old topic, but just came across this issue myself and took a few hours to figure it out.

There are a few solutions to...

Do you mean create a variable and populate the linked server DSN within the variable?

That's what I ended up doing along with changing it to be serialized rather then in...

Not sure if you got an answer to your question but I am a little confused why you need to have multiple variables that are virtually the same thing:

Also i...

Why can't you do it this way? I am not sure why you are using variables in the select statement:

ALTER PROCEDURE [dbo].[sp_CopyFileScorerChanges]

-- Add the parameters for the...

I would def. go with this as well.

If this is a one time deal then you can just a SELECT * and copy/paste :hehe: