Furthermore...

This seems to be occuring on only one machine?

I don't know if this makes a difference, however, I connect to the Server through an IP address, whilst others...

Initially when trying to link a table through Machine Data Source, which uses the DSN created through ODBC. An error message is displayed -

Connection Failed

SQL State 'S1000'

SQL Server...

Try initializing your variable before calling it.

Eg.

declare @comp_failed as int

@comp_failed = SUM(FAILED) from TIME_VW

set @strSQL = 'SELECT @comp_failed

where' + @STR

Emma Smyth

I've just been reading about error handling and, therefore, looked up your query.

"The RAISERROR and PRINT statements are not valid within a UDF. To detect any errors, you must...