should. It will have issues when it restarts.

Steve Jones

steve@dkranch.net

Haven't seen it. You might try using profiler to capture the traffic and look for something funny happening.

Steve Jones

steve@dkranch.net

haven't tried. don't use that piece of #$^^%$

Steve Jones

steve@dkranch.net

select * from msdb.dbo.sysjobhistory

Steve Jones

steve@dkranch.net

don't have notes here and never set it up. I know you can get it to work by setting up Outlook as an SMTP client.

I have a few URLs, but...

Hopefully it wasn't our email newsletter?

I agree with Brian. In ANY environment, ALL accounts SHOULD HAVE a password.

Steve Jones

steve@dkranch.net

1. Yes

2. Not sure. I think this may cause issues, but I'm not sure.

Steve Jones

steve@dkranch.net

You reinstalled v6.5? Was this on the same OS or was it upgraded? I've seen some funny behavior of v6.5 on W2K and have moved all servers back to NT4.

Steve...

I believe this is a SQL 2000 item. You might need to upgrade the SQL version.

Steve Jones

steve@dkranch.net

Use the Execute SQL task.

Steve Jones

steve@dkranch.net

see other post

Steve Jones

steve@dkranch.net

In SQL 2000, create the db first with the correct collation. Then detach, copy over and attach.

Steve Jones

steve@dkranch.net

If you have added extended stored procedures, then you might have an issue if it is not installed on Node B. Keep in mind that there is a real copy...

I think this is ok, but I am wary of the appending. I always write a new t-Log backup and overwrite so that I have multiple files to restore, but...

Nice Brian.

Steve Jones

steve@dkranch.net