You could schedule it as a OS task in sql agent. Other than that, I don't think there's a way to run an OS command without xp_cmdshell (unless you create...

Sure. Please post the entire piece of code, especially what's inside the cursor loop and I'll give it a shot.

Without knowing what you're doing with the cursor, it's near impossible...

What are you trying to do with the cursor? Post the entire code if possible, there's probably a better way.

I used to code review everything, but I don't have time any longer. The load's spread among a small group who do know well-performing code. However stuff slips through.

On the...

I've found that our DBA's don't (have to) do much in the area of performance tuning code, only do cursory reviews of code, don't do much when it comes to...

SELECT

@@Servername

Agreed

I found the short scenarios worse than the long ones. The time available for each scenario is proportional to the number of questions. In the ones with more questions I...

OK, let's give this a try...

SELECT

dbo.USERS_LOGIN.UL_CONTACT_SURNAME + ', ' +...

It's possible, but a little tricky. which of the rows that have the full name of Jim smith would you want returned?

We're not using NTLM anywhere.

The Kerberos patch is my prime suspect too, but why would a kerberos patch cause SQL Native Access Client to no longer be able to retrieve...

Update

Rolling back the security patches fixed the problem.

Now, out of four security patches, for  the telephone service, remote desktop, plug and play and kerberos, which could have caused this...

Could you post the C# code where you call the proc?