Thanks, I thought I tried that, but obviously had a typing error somewhere. Just tried again and that worked. Told you it was a stupid question.

Thanks for the prompt reply.

A little more information.

If I run the following the query completes instantly;

select top 10 * from Table_A

however If I run

Select top 10 * from Table_A

order by time_occurred

The query runs for...

Sorted and for all of you that are interested....

Set up a simple windows scheduled task that executes a batch file. Within the batch file I have the following

rem @echo off

sqlcmd...

Thanks for the link http://standalonesqlagent.codeplex.com/ but need something that's not in Beta.

I understand that you can set up a backup task using windows scheduler, but how, I need help with the syntax.

Looking at windows scheduler, Windows 7

click create task (all the...

I had some help with this, and this seems to work.

Hi, not sure that will work as this table has thousands of records and your query lists the entries...assuming I'm reading it correctly.

this is where I have managed to get...

I have managed to clean out msmerge_history. This table within the distribution database was 7GB containing 10m records and growing. Running the SQL maint task;

agent history clean up: distribution which...

I managed to set the tasks up, but the distribution db continued to grow. looking at what table was the cause of this size it turned out msmerge_history contains 10m...

I have managed to clean out msmerge_history. This table within the distribution database was 7GB containing 10m records and growing. Running the SQL maint task;

agent history clean up: distribution which...

You are correct in that the jobs should be created automatically however they wernt in this example.

In my setup Server A is the Publisher / Distributor and Server B is...

I had this same problem and the only resolution that I found was to create a publication with the same name (using the same database) then delete it immediately (choose...

Thanks for the reply, this makes sense. I have completed additional investigation and the problems I encountered all stem from an incomplete merge replication setup. I say this as in...

I have the same problem. Running SQL 2005sp2 Merge replication (Push). I noticed Distribution.MDF was growing larger that I would expect. I was missing the task 'Agent history clean up:...

This is great. Thanks WayneS this worked a treat.

Doobya, thanks for your feedback. Just for my info what do you mean when you say ‘you can't use datediff() like that...