Sorry,

I changed them to

SET ANSI_NULLS On

GO

SET QUOTED_IDENTIFIER On

GO

Vishal

Good thinking, i got a message about quoted identifyers being inorrect so I changed the script to inculde the following

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

and it worked. ...

Slightly off topic I know, but the way films depict cracking passwords or encryption with just a few keystrokes (think the film swordfish is a wonderful example of this) ...

i'D go for HOlly from red Dwarf (TV) but if it has to be a movie then I would go for the 'unix GUI Interface' in Jurassic Park, as even...

OK, Thanks. Will have a dig in that area then.

Someguy (7/29/2008)

---

Some questions:

1) I hear that the batteries in a typical hybrid need to be replaced around 80k - it that true? If so, it completely outweighs the gas savings,...

Playing the devils advocate here...

The prius and others like the Honda civic hybrid may have a large carbon footprint but I think all cars have to a...

I recomend the bulk copy out of the data. I had to do this to all our dbs (30+) and tried various methods this was the quickest by a long...

Hi,

 Something I forgot to put in my previous mail is that the goverment here in the uk. Run a scheme whereby you can buy a bike with the required equipment...

Another Interesting mail.

  Steve,

   I love my cars too, having had several high powered motors, I currently have an RX-8 and recently I have been thinking about changing it, but...

Thanks for the suggestion, I think we are going to start again from the tables upwards

Andrew,

 Thanks for the pointers but still no further below is more info

 

Execution Plan below (not sure how this will look)

1 1 Select     @Count = count(*)   From    ...

I gues your right re 4s, but its one of those things that you hope to have covered everything and tried every avenue to tighten things up, and maybe learn...

Hi,

I am fairly new to VBs scripts and thought is this just what I need to update Our old Batch file process that does the same thing. But when I...

Thanks, Ramesh that did the trick