Ok, the server is sql server 7.0.  There are 4 databases which are replicated onto another sql server 7.0 server.  All 4 publications have existed a while and have not had...

Joshua,

This is not the error number I get.  I get sql state 42000 and error number 14151.  These don't tell me much (just that replication has failed).  I did look...

Thanks for all of this.  Very useful and informative.

Ok, I worked out what I did.  I had the backup that I wanted selected but also had another one ticked lower down and so it was trying to back...

I tried to do this and definitely changed both places but I got a message saying 'you are trying to overwrite an existing database'.  I really need to do this...

Thankyou.  I still don't know how to specify last Thursday's backup though.  The only one I can find is called blah.BAK but when I go to all tasks - restore,...

Yes, that's it they are.  What are the implications of this?  Is it a good or bad thing?

That's great.  Thankyou!

Thanks, that makes sense. 

Thanks everyone, I will try a few of these.  I have tried the >= and <= solution but it still only brought back one time.  I'll keep trying though.

Oh sorry!  Forgot this was a sql server only site!  It enables you to set the number of characters allowed on a line when producing something like a comma separated...

Yes, it is SQL Server 7.  Thanks for that, it was fine all along.  I should have mentioned that at the start.

Thanks, I'll give this a try.

Joe,

As stated in my first post, I just wanted some advice on the actual query itself, and how to write it more efficiently.  I did not ask people to advise...

I don't have the option to start it though.  I have the options to stop or disconnect.  ??