Hmm..will readily admit that of your many personas this one I like the least (actually "not at all")...think you should definitely keep your lightspeed days hush-hush..

BOL help could be found under "distributed queries"...

There's (at least) an article on this - the discussion/ensuing comments make for a really good & informative read - also a post on the same topic...

1) where logic...

Some more suggestions:

In addition to making the ConsultancyBookingNumber an ID column, you could also specify default values (of NULL) for the various parameters so you don't have to do any...

Your best bet would be to start within BOL itself...it has pretty extensive (& comprehensive) documentation on triggers..

okay - then you just have to change that to "overwrite"...

maybe you have the "append to media" selected rather than the "overwrite existing media"?! At any rate, you can still start, stop, edit, delete etc. by rightclicking on the job...

what does a bike messenger do - is that the same as a courier ?!

ps:was the bike driven by motor or pedal power ?!

I would offer Steve (very stiff) competition in getting on that best-seller list..

I love (read: intensely passionate about) the power of words and how...

use convert and apply a style to get only the date...

select convert(varchar, getdate(), 101)

there're any # of formats that you can apply - check BOL for the one that fits...

"big brother chip implanted"...omg - are we in Oceania ?!

Yeah - that's scary! Don't blame your goat for being thusly got!

Maybe there's hope in that since so few know of this the id thieves fall into the category of...

Mine has been really random...sometimes I get it late at night...sometimes not at all

Jo - why don't you just set up a filter?! I...

Have you tried the alternative of : "SET ROWCOUNT 10" & then running your select to see if it makes a difference?!

Has your table grown considerably since last week (that's...

okay - will take your word for it!

But on the msn download site this is what they have (see below) and it does...