My comments are not intended to offend the author or the forum editor(s), but a clarification of my understanding of the purpose of the QOD.

Toreador - just answer them for your own benefit and consider some are incorrect (unfortunately), some are silly (like holidays), and occassionaly some are useless.

Ok, maybe now I have vented...

There have been many interesting posts and I will have to agree everyone has a valid opinion (by definition). I must be in the minority since I consider the QOD...

Frankly I am quite disappointed with this "correct" answer. While I agree many people might use Books OnLine or experiment in SSMS before answering, that minimizes the value of the...

Based on BOL, I believe new data added to the database will be written to the original data file before the new data file grows if the original data file...

There could be a number of factors in play here. Did you specify an Initial Size for the new data file? Also, what is the Autogrowth setting for this new...

You need to install the Microsoft SQL Server 2005 Backward Compatibility Components. This download includes the necessary DTS runtime objects. If you want to maintain your DTS packages within SQL...

Create the variable "sSQLString" as type String. The value is not relevant (I deleted the default -1) because you will change it in the Script Task.

Your ActiveX Script appears to be identical to another post where I provided a solution earlier this week: http://www.sqlservercentral.com/Forums/Topic626389-148-1.aspx.

My solution is as follows:

1. Create a user variable sSQLString

2. Create a Script Task (not ActiveX Script Task because they are deprecated in SQL 2008) as follows:

Name = Set SQL...

Munna,

The statement shown is part of an ActiveX Script task modifying the SQL statement for a DTS Execute SQL task.

An example for this functionality in SSIS can be found at:...

Sorry, my error. I meant to say that SQL Backup Lite does not support encryption.

About four years ago one of my client databases grew so large that native SQL backup ran over 8 hours (longer than the window of time available) and we decided...

I experienced a similar issue, although I was still running DTS on SQL 2005. The resolution was to grant the SQL agent user create/update permissions to the WinSCP folder. It...

Sorry I didn't read http://www.cio.com/article/27099/_Signs_You_re_About_to_Get_Fired earlier...

1. Your company is sold. - true, about 2 years ago

2. Your company is not making money. - not as much as the...