Lowell - thank you. You are correct. I was going on the assumption that it would behave like a stored procedure.

Out of curiousity, is it possible within stored procedures...

According to MSFT,

why we cannot use “where isnumeric(Column) = 0” to null the data::

The reason is “isnumeric(Column)” check is in condition which executes before the “select” statement. Since we...

I had no primary key on the table and no guarantee of uniqueness on any given row. Because I was using the NaN column as part of the where clause,...

for troubleshooting, run the SQL services as localsystem and see if you continue to have issues.

see the following:

- http://simonsql.com/2011/04/26/how-to-troubleshoot-the-cannot-generate-sspi-context-error-message/

- http://blogs.msdn.com/b/psssql/archive/2009/12/30/cannot-generate-sspi-context-and-service-account-passwords.aspx

are sql services running as a domain account or as localsystem? are you using the actual host name to connect or a CNAME or A-record? what happens if you (ping...

**removed**

Ron - thanks for the link. I wasn't aware of that.

However, the ISNumeric query is working as I intend. I do get an overflow when trying to update those records...