Just to back up sushila, I was helping a friend import some genealogy data. She had a lot of data where she knew the year of birth and sometimes the...

Probably the main cause is DTS. If you store your DTS packages in SQL Server and edit them frequently you can end up with dozens of versions of each package....

How about you ask your question over at http://www.asp.net ??

You can not use a UDF as specified in your first example in the ExecuteSQL task. This is because the meta data about the parameters is not available.

Call your...

Ann

The time, effort and resources you expend backing up, and possibly restoring, the system databases is vastly outweighed by the consequences of not doing it. I'm of the opinion that...

Sounds like the infamous DLL versioning problem. The DTS SMTP Mail task is expecting a procedure to exist in the DLL but it doesn't.

Haven't played with that custom task myself, I just...

I agree, passwords should be written down. This is especially true for IT staff for DR purposes and in the event that you're not around when the password is needed, like...

DTS packages reside in the msdb database. So they're backed up when you backup the msdb database (you do back it up regularly don't you ?? )

If you want to...

Best bet is to change your Print statements to insert the text into a logging table.

Rather than repeat verbatim here, check the relevant topics in Books Online.

For starters try these,

Table and Index Architecture

Index Tuning Recommendations

Query Tuning

 

Check the FAQ over at http://www.sqldts.com

As an example of whats possible, I use this following function to email me reports about failure messages from my maintenance routines. At the end of the maintenance, if an...

Store the information from the form into a table in the database.

Create a stored procedure to format the data required in the body of the email into a string with...

You'll have to go down either path a, b, or something very similar.

You could obfuscate your table names and do all the data retrieval and processing in your client app....

No don't add a lookup. The lookup would only be used as part of the datapump and therefore switch it to row-by-row mode which would slow down your entire data...