which column of yours is a datefilter?

If you are practicing some basic querying then http://sqlzoo.net should be very handy.

select convert(varchar,getdate(),111)

Hi Lynn,

I have seen that happen in SQL 2k when someone updates sysjobs directly by setting enabled = 0.

Disabling a job using sp_update_jobs stops it correctly.

The wierd part is that...

@jason,

Its logical.I was just trying to be self critical 🙂

@shinobigoh,

The option I can think of, for jobs, in that case would be to create a dts package for transferring jobs.

Trigger...

@JohnC,

If you need accuarate numbers then go for count(*). If approximate stuff wud do then use sp_spaceused/SP_ROWCOUNT provided in the article.

Probably your Update stats took a sample scan. Try,

Update statistics...

Oopsie..I didnt read the question correctly. Just saw OP's 'what abt jobs' and replied.

Apologies shinobigoh and Jason for my dumb response.

Recession has taught us that we need to resort to the cheapest option where ever possible 😀

Thats because statistics for the table is not updated

Fire 'update statistics tablename' and check the results again.

You can always script all the jobs from Enterprise manager from

Management->SQL server agent->All tasks->Generate SQL scripts

generates the script for all the jobs on the server

Logins cant be scripted directly from the management studio with the same password....

@gerald.drouin,

While loops do offer a solution for hierarchy based solution, but CTEs are simpler, cleaner way of solving the recursive problems. If correctly used, they offer better performance than while...

The one under SQL Agent gives log details about scheduled jobs alone.

The one under Manangement->Sql Server logs is the one that stores SQL error logs. I prefer to use sp_readerrorlog...

Welcome 🙂

@paul-2,

I guess the original poster needed a solution using the partition clause.

I have just made small change to pauls method1. It should work

[code="

SELECT S.column1,

...