Thanks Jeff it worked

I recieved the email, but hate giving out contact information in order to get any kind of pricing, then you get some sales guy hounding you for months

Thanks, work great

Nice job thanks

Thanks for your reply, but I figured it out last night, I added then server name under the alias tab in the Client Network Utility, then all the jobs fired...

The SPIDS are on the database server

We have an app server which calls a stored procedure on the database server which uses the UDF.

After restarting the server all the SPIDS...

Many SPIDS related to the UDF are still (last batch) open since 05/27/04

1 ProductName NULL Microsoft SQL Server

2 ProductVersion 524288 8.00.760

3 Language 1033 English (United States)

4 Platform NULL NT INTEL X86

5 Comments NULL NT INTEL X86

6 CompanyName NULL Microsoft Corporation

7 FileDescription NULL SQL Server Windows NT

8 FileVersion NULL 2000.080.0760.00

9 InternalName NULL SQLSERVR

10 LegalCopyright NULL © 1988-2003 Microsoft Corp. All rights...

Version 8.00.760 SP3