Viewing 5 posts - 1 through 5 (of 5 total)
george sibbald (2/7/2012)
people may also want to look at sp_help_job and xp_sqlagent_enum_jobs
Yes, especially when you are out of permissions to directly query sys tables.
February 7, 2012 at 2:07 am
Jeff, I must tell you that your solution is briliant as well!
June 14, 2011 at 1:08 am
Jeff, thank you for your effort measuring the two methods!
It is true, my solution is a way slower as it is now. That is so because there is no index...
June 14, 2011 at 1:07 am
No need for uncle Google in this case, spt_values is quite enough, unless you are querying some large data warehouse.
However, I agree that GetNums is a cool trick to generate...
June 13, 2011 at 6:44 am
Looks too much complicated for the goal, isn't it ?
June 13, 2011 at 1:45 am
Viewing 5 posts - 1 through 5 (of 5 total)