I often use them with dynamic SQL.

I recently wrote a proc to search every column in every table in a database for a certain value and obviously I didnt...

Hi

nobody is arguing with the fact that cursors should never be used when a set based operation can be used.

What the author is saying is that the mantra...

Hi

you could still use

SQL Function "select @@SERVERNAME" which will return the current server.

if you execute it against a connection set to {local} , which is fine as long as you schedule...