Are you referencing the variables with the variable dispensor or directly with dts.variables? If you are using the latter then you have to specify the readonly and readwritevariables in...

Provided the severname doesn't change all that will likely be needed is a restart of the services to use the new ip address..

CEWII

I would love to see the maintenance strategies for something like this..

CEWII

All of these things will work, but are you doing any source control? Don't you already have a copy of the way it was, and if not WHY?

CEWII

Assuming CC column is a varchar(16) or char(16)..

You could try a LIKE operator

something like

WHERE CCColumn LIKE '____________1234'

That is 12 underscores which in a LIKE operator equals any single character, in...

As I understand your question

SELECT SupervisorFirstName = e1.firstname,

SupervisorLastName = e1.lastname,

EmployeeFirstName = e2.firstname,

...

I was thinking there was some limit like 4000 characters on the LIKE operator but I can't find anything that says that. Going out on a limb, you might...

There are a number of ways to accomplish this, but my big question is how long does it take to do the extraction for each branch and how wide is...

The primary key column is like any other column with a unique constraint. If it is also the clustered index then you get dinged on the move from page...

I'd say lookup sp_trace_create and see if that would work for you..

CEWII

Wow, somehow I just don't see 542,272 terabytes as a major limitation.. I'd like to hear from a single site that has a database that big.. I'd really...

You can update it like any other column.. But if you are updating it, then is it really a primary key? Primary keys generally don't change.

CEWII

But you aren't being clear what you mean by features..

A DTS Package will have DTS features, end of story.

An SSIS package can have a DTS package embedded in it but...

I am a little unclear as to what you are asking.

If you have a DTS package in SQL 2005 it is a DTS package. You would potentially see it...

Can I ask a stupid question first, you are defining it as an INSTEAD OF trigger aren't you?

CEWII