You could setup a RAM disk and run it that way. Sunbelt Software used to carry a product for NT that did this, not sure about 2000.

Steve Jones

steve@dkranch.net

I usually run SQLAgent as part of teh local admin group as well.

Steve Jones

steve@dkranch.net

See my first post. You setup the mail client software on the server.

Steve Jones

steve@dkranch.net

Once you have mail setup, you can set thsi for each job.

Steve Jones

steve@dkranch.net

If you need to worry about updates, you probably need to insert into a temp table and then move across. With DTS, you could script this, but it would be...

yes. What types of notifications do you want?

Steve Jones

steve@dkranch.net

It might be permissions. When you run from QA, it is running as your connection. When it runs from VB, it runs under the context of the Vb connection. Check...

Pls don't cross post. This is being answered in another thread. We check all the forums.

Steve Jones

steve@dkranch.net

Install Outlook.

Setup SQL Server as a domain account

Setup this domain account as a mail user (Exchange assumed)

Log in to the server as this user and configure Outlook to work.

From Enterprise...

You'd also have to automate checking of disk space, performance monitoring, etc.

If there are few problems, then there isn't much to manage. It's when you have problems that the scale...

Be sure if you open our firewall, you only allow connections from the IIS server. Here we have 2 NICs in the IIS server, one to the Internet and one...

sp_reassign_dtspackageowner

Steve Jones

steve@dkranch.net

I do not think so, but I could be wrong. I haven't used the Data Driven Query very much, but I have seen than any transforms in DTS are slow....

I agree with Nigel, but your post is not really clear. What are these two tables? What is the related? How is an identiity related to the update?

Steve Jones

steve@dkranch.net

Can you post a sample data file (a couple lines) and I'll see what we can do.

Steve Jones

steve@dkranch.net