The decision is not made during the generation of the execution plan. It can only be made while data is being added to your table variable. If you...

In addition to the maximum number of columns, you cannot make a record size larger than 8k.

You really need to explain to your client that this is a really bad...

Avoid a trigger.

You can do this with an identity column and then a computed column that concatenates everything together for you.

I would suggest that you pad the incrementing number to...

Go into the package configurations dialog and create a new configuration. Browse for an existing file. When you have selected the existing file, you will be prompted to...

The easiest way is to add a step to the restore job that calls msdb..sp_start_job for the job you want to kick off when the restore completes.

Remember that sp_start_job is...

1) Yes, it is feasible to store the images in the database. Disk space is cheap these days.

2) You can do this, and some will argue it is better...

They do log the same "detailed" information on a 64 bit server as on a 32 bit server as long as you are running them in 64 bit mode by...

This is pretty easy - just make the insert SET-Based:

[font="Courier New"]CREATE TRIGGER trg_FileTransfer_OnInsert

ON FileTransfer

AFTER INSERT

AS

/* Update all existing records - do this first so you don't update newly inserted records...

SSIS will probably handle what you want. You will probably want to manage pieces of the load differently.

For very small tables (< 1000) records, there is a Slowly Changing...

sp_spaceused gets it's row count from the partition statistics rather than counting the actual numbers of records. If your statistics are not up to date, the number may be...

ParameterDirection.Output is an enum. It does not indicate the value of your output parameter. To get the value of the output parameter, you need to get it from...

You can also right-click on a package from within Management Studio and export it to the file system. SSIS packages never get "compiled". They are XML definitions, not...

substring is not the same as split, but that is a function you would need to use.

You are talking about IVR - Interactive Voice Response. This is much more on the phone system end than on the database end. There is nothing built into...

You really should be using a derived column component for these two issues. Don't use the script component unless you have to. Splitting and a conditional statement can...