Just giving the column a DEFAULT will not help you. Your third party application is not aware of the column, so it is not going to include the DEFAULT...

When the package is being run from a job or from xp_cmdshell, it runs on the SQL Server. First, this server must be an SSIS Server (not just an...

I would start by saying that starting a job with a trigger is probably not the right solution - regardless of the problem. A trigger is designed to be...

When a user disconnects, all SQL Server locks are released. You cannot have a resource locked without the associated spid. So, if you have users that are not...

You will have a couple of security issues. First - the running of the job. The best way to lock this down is as follows:

- Add the login...

Both will result in a table or index scan because indexes will be basically worthless, but the second one (using the function) will be slower because the function must be...

Your two requirements:

- Create multiple threads for a stress test

- Continously loop the task for a load test.

These would also tend to direct me toward Service Broker. A queue...

Your description of what you are trying to do is misleading.

I think you are trying to author reports using Visual Studio / BIDS 2008 and publish them to a Reporting...

I guess the first question is if there is a parallel period. In the case of a week 5 that is in a different month, what should it do?...

Yes, if the files end up in the same logical location, you can simply move them and start the SQL Services.

If they are not in the same logical location, you...

The emails are only on a failure of a step, so a single job seems to meet all of the given requirements.

What is the problem with creating a single Job Agent job with a step for each package?

Service broker would still require you to enter something into the broker queue - so you would need a trigger anyway. The advantage to using service broker would be...

My first recommendation would be to move ColdFusion to another server. MS SQL is much more efficient when it is not competing for hardware resources - particularly memory intensive...

You cannot do this.

Perhaps you could post what you are actually trying to do and someone can help you design a solution that will work.