Re: Scheduled LONG queries

Graeme Slogrove ( graeme@fdd.net )
Fri, 13 Feb 1998 20:02:34 "GMT"

> As we evolve our Emerald installation, we have started to require
> increasingly more complex TSQL statements to be run on a scheduled
basis.
> The 256 character limit is starting to cause problems.

Try rather writing these as stored procedures. Them simply call the SP
from the Task Manager, hoping of course that you haven't named your
task with a name of more than 256 characters ;)

Cheers!
Graeme

----
Posted by WebMail