I don't think the VB application uses the dbmail procs to send emails. But I'm wondering about the permissions you mentioned. I created the batch (.BAT) file on the server...

Lowell, I tried your code but somehow I was able to update data in the locked table.

I tried :

BEGIN TRANSACTION

SELECT * FROM tblMyTable WITH (TABLELOCKX)

and I got an error message:

"TABLELOCKX"...

I have an Execute Package Task where the field Package Name is empty. Are there any situations where this field can be empty? This task needs to know which package...

Question #1:

I noticed there is a sysdtspackages table and a sysdtspackages90 table. I'm currently running my DTS packages on SQL Server 2005. We installed the DTS components add-on. So which...

But what I don't understand is that the package runs without any problems. So is this just a UI problem?

Sorry, I figured it out.

I saw the "Add Topic" button available only while I was in this forum (SQL Server Newbies). But the button wasn't there when I was in...

I've been inherited a DTS project.

Can you explain why the global variable needs to be recreated when it shows <not displayable> ?

Is this a bug?

I'm in a situation where a...

It is a SQL table and it holds the NEXT value. There are multiple rows in this table, one row for each table that needs to be incremented. This table...

I understand what you are saying but can you give me an example of how this can be done. How can I ensure that when a number is issued, that...

As it turns out, the Execute Package Task is definitely executing on the production server. But I'm curious about what you said, the package may run simultaneously on a separate...

<< Why do you have questions that could be answered by yourself on a test system within an hour? >>

Bru, if you look at the left side of the page,...

The reason why I need to learn DTS is because my client is still using them. I don't have a choice right now. I need to support his current system....

Hi Greg,

If I understand correctly, if I open the DTS in SQL Server Management Studio (2005) and save it under a different name, it'll still be saved as a DTS?