Did you get an error message when trying to install sp3?

What about what is recommended via microsoft updates.

Also what did the documentation say when downloading sp3 about the pre-requisites?

Well not really, it would almost be correct in Access which is probably where that all started.

The deletes and updates (especially in joins) are quite differente betwen Access and SQL...

I never had that problem nor read about it, I'll let the other prod dbas handle this one.

That's what I mean, you need to know where that table is, make an inner join to it and present the right data.

You need to learn this to be autonome,...

I'm going a a limb here and assume that this data in held in another table. Hit F1 in enterprise manager and do a search for inner join. ...

Do you have anything else to go on (like windows log). That seems a bit thin to go on to me.

Now that I had the night to sleep it over, I'd actually implement both.

The trigger fires the user-friendly warning, then when doing DML in the table to change whatever, the...

Don't know for sure, but you can get management studio express (free download). Then see if you can connect (that's where I'd start, I never had to do this...

I had the same problem, you need sp2 of sql server 2005 on vista (nothing less for compatibilty)... and quite a few updates on VS 2005 iirc.

Plan A would be to do that client side... assuming you are not violating the rule to send back more data than needed.

sanjeev_krs2004 (12/17/2008)

---

I added one hard drive to the server as I told you guys that I dont have any space on the existing setup. I was forced to add new...

You can always backup to external disk, or network drives. On prod server I'd never change recovery mode without backing up first.

Of course dev can be another beast... I...

That's the wrong sequence... BACKUP FIRST... then do the rest.

make sure to advise and get approval that if anything goes wrong, no point in time recovery is available between the...

Same problem with dates!!!

You need to store all the data for the minimum safe range needed... which is often a buttload of data!

Hey Joe, don't you have an article or two posted on the subject.

It might be a good place to put a link to it!

TIA.