Hi Grant, I have a 3rd party proc app that uses sp_add_job which I guiess calls sp_verify_job. 3rd party app fails on 2005 in sp_verify_job but works fine on SQL 2000....

Thanks Steve & Ray

Just wondering how you handle the various bits of a select that might change for each execution when wrapped up as a stored proc (paticularly the order by and where...

Thanks Steve, I'm probably being a bit thick...but how do you do it?

Thanks Dinakar - just got it.

Regards

Allen

Thanks Ian,

Well I fnally ran out of ideas - bounced the server and hey ho all is working again.

Oh dear - it just worked fine twice in a row and has now failed again! I think I shall bounce the server. Still failing on my desktop though!

Definately UltraEdit http://www.ultraedit.com/ handles massive text files.

It's got to bwe cricket.

All Tasks -> Restore Database -> General Tab -> Choose 'From Device' radio button -> Click Select Device button -> Add -> and choose your file.

You will provably need to...

Providing the table and it's indexes are not overly fragmented it should not matter. I would do a DBCC SHOWCONTIG to check. Also If you havent got one already one of...

I'm not sure that these values are maintained in syslogins anymore.

I would put a profiler trace on and in the Events tab select Securuity Audit.

Allen

All I can think of is on the properties of SQL Server Agent -> Job System tab.

Is the 'Limit size of job history log' set to zero?

Allen

Ist & 3rd should definately return the same number of rows - there is no join or where and the group by is the same.

There is a post here that might help (the one from Ryan Randall).

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=263744

I will admit - I don't know _why_ it works!

Allen

On your first query you are asking SQL for each CustomerNumber and the max(CustomerName) for that CustomerNumber - I guess each CustomerNumber probably only has one CustomerName so you get...