Not cool to make fun of a new poster who doesn't speak good english >>>

USE tempdb

GO

CREATE TABLE dbo.Demo

(

id int NOT NULL IDENTITY(1,1)

, x AS id * 2

)

GO

INSERT INTO...

And there I was thnking you knew everything about everything ;). Now that dream is gone for me.

That would be a shame for you to wait 5 hours for us to answer while reading 1 page of text takers 2 mins.

The SQL Server 2005 SP3 Readme files...

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...