Solves the problem... and you can check the script for quality control.

y not running it yourself?

That's a completly different topic.

Can you post the DDL along with the requirement of the system?

As anyone measured the cost of sending the whole list of parameters all the time on the network?

Also has anyone ever used a timestamp column to ensure that the row...

As anyone ever tested this thouroughly (the cost of passing all the parameters all the time, VS the cost of the nullif(isnull, Colname)) execution).

If you know that only 1 column...

Jeff Moden (9/18/2008)

---

Heh... not exactly true...

SELECT *

INTO #MyHead

FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',

...

Yes you need to create it first, including column definitions.

Can't be done, must be a temp table.

Also make sure you have enough HD space whereever you put the backups!!!

Here's the gist of the logic, it's in pseudo-code because I don't have a server to test it on ATM.

Make sure you test on dev server first!

SET ROWCOUNT 500000

DELETE FROM...

C'est sure que tu peux renommer des fichiers en .net, mais je connais pas le code qui fait ça.

En plus, si les DB sont online sur le server sql, tu...

Cool, thanks for letting us know!

Fait une recherche dans Books Online.

ALTER DATABASE DbName WITH MOVE

Je me souviens plus du nom exact de l'option qui suit (et j'ai pas sql server ici)... ça va prendre le...

... and why did you decide the create such a column in the DB / select statement?

will.rowland (9/16/2008)

---

Good point. I didn't know if actual solicitations were allowed, especially since I can't guarantee this will turn into an actual job offer, but...

We are located in Austin,...