After sleeping on this, I think that I might be able to setup a redirect through the local ODBC connector on the workstation???

I'll let everyone know

Thanks

Bill

We are using exchang and as far as I know SMTP is enabled on default port.

Bill

Thanks all

That makes complete sense now that I think about it. This fourm is great!

Bill

What I found from searching web pages:

sql agent needs to be run under a domain sqladmin account. It's working now

thanks

William

For whatever it's worth, I ran across this article. Highly recommending 2003 over 2000

http://www.sql-server-performance.com/operating_system_tuning_w2003.asp

William

Ben

Why is it a debate to turn on hyperthreading?

Thanks

William

Hi Robert:

I actually had to set the time back one hour

William

Worked like a champ!!!

Thank you so much

William

So to use this would the complete statement look like:

update table where record_id = 'abc'

set event_date = SELECT DATEADD(hh, DATEDIFF(hh, 0, '2007-01-03 09:59:59.997') + 1, 0)

Thanks

William

Yup, I'll give that a try in a while. Generally the developers don't have access to sa.

I'll let the thread know what happens when I try this.

William

This is just plain odd - we won't be using sa for the ODBC anyway. We are using Crystal 10 and one of the developers noticed this.

I even went...

I checked the views and they are owned by dbo.

I still can't figure this one out

Thanks

William

Thanks guys

Both solutions worked Great!!!!

William

Thanks All for your help.

In Summary

to locate orphaned records run:

SELECT

n.Customer_ID

FROM

Notes n

LEFT JOIN Customer c

ON n.Customer_Id = c.Customer_Id

WHERE

c.Customer_Id IS NULL

To remove orphaned records run:

DELETE FROM Notes

WHERE ...

Thanks Grasshopper.

I'll give that a try too. What you have offered makes complete sense.

Thanks

William