Just to provide a link to another buildlist (also contains sql2000 and sql7 builds)

http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Does anybody know if this build list can be downloaded from some place ?

(for the moment I tend to keep up the copy/paste way

Indeed, there 's more than one reason to avoid the path of auto-updates.

Back to controlled releasemanagement and assuring uptime and avoiding surprises like the ones mentioned already...

just wanted to ref to the sp2a article by Andy Warren : http://www.sqlservercentral.com/columnists/pressrelease/2906.asp

and its comments :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=112&messageid=349577#bm351006

I guess a DDL-trigger might be the easyest way to do it.

thank you all for the replies.

I'll test the proposed paths.

Be sure to make backups of _ALL_ databases !!

With sp1 you could use

SQLServer2005SP1-KB913090-x86-ENU.exe /quiet /allinstances

The same can be done for sp2.

Check SQL2005SP2_SETUP_sqlhotfix.chm. The parameters are described.

You can apply the HF...

Your exists queries should do just fine !

And chances are they would be performing better.

Compare the execution plans ! and runtimes

probably someone use EM to change the table or used a script generated by EM.

It basicaly renames the old table, creates a newone, load the data, drops the old one...

- I've got no experience on this matter but ....

- can you give us an idea of the number of connections you're expecting (x/min)

- what TPM are you expecting ?

-...

your Q should be another thread, but this article contains some nice refs.

http://www.sqlservercentral.com/columnists/nboyle/speed_select.asp

that does rings a bell overhere 

"If you don't use it , you tend to forget it"

Also...

maybe clarifies collations and casesensitivity a bit for Bakr Ben Ayad

This was what we were refering to in our replies.

Putting all in...

or make the column case sensitive ...

...EXEC master.dbo.sp_MS_upd_sysobj_category 1 .. isn't a best practise !

Why marking a propriatary proc as system proc ?

I don't think it works the same way for...