Thanks to all and I am on Win 2003.

No firewalls and the UNC approach WORKS. I'm still baffled as to why the mapped drive won't work.

danke schön!!! Now I have to google ZANGLE to find out what it is. 🙂

Found it.

Q. What release of SQL Server 2005 will run on Windows Vista?

A. SQL Server 2005 Express Edition with Service Pack 1 will run on Windows Vista but...

d'oh!!! mea culpa

All the data is in one table.

d'oh!!! I can't tell you how many times I mis-counted those. Many thanks.

Thanks! If I understand correctly, the syntax should look something like:

update users set password =

(lower(substring(studemo.firstname,1,2)) + lower(substring(studemo.lastname,1,4)) + cast(datepart(day, studemo.birthdate) as varchar (2))

FROM users

inner join studemo ON users.username...

I've tried both the virtual IP and virtual server name for the sql server on the cluster; I'm not using using either node ip or machine names. SAC is recognizing...

I've tried both and received the same error.

Thanks for all the replies. The data is a teacher id; wish it would have been a char field.

d'oh!!!

One trigger does fire (9tr_slvswstuU fired, no change to address fields). I see this when I limit the update to only 1600 row (16 sec execution). There is...

Both are varchar (passwd is varchar(11) & ident is varchar (10)). Can you explain how I can monitor this and see where the bottle neck is located?

Fully qualifying the share folder fixed the problem.