is the instance also 9.00.3042?

gail, intersting news, thanks, I will hold off too.

rod, does @@version return 2273 after you install?

forget that silly overcomplicated RDBMS, Oracle, SQL server much easier.

see this article:

http://support.microsoft.com/kb/314546

also read up on sp_help_revlogin

to set a database read only - alter database dbname set read_only

couple of golden rules

1) if you don't ask, you don't get

2) there are two times when you are most likely to get a raise - when you join a...

why not keep it as a database, change its name and make it read only as it will only be used for reporting. Move it to the new server using...

check the log produced by the install for errors:

%PROGRAMFILES%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

If this patch has a tendency to fail would sure like to know about it.Were you able to back...

thanks for the feedback...........

Buxton69 (7/10/2008)

---

It doesn't say that in the article though, for hotfixes it always states that it's cummulative, I presummed that it probably is cummulative but want to make sure.

its cumulative

It's...

If you are at 2039 (sp4) then you are applying the GDR which will apply all fixes up to and including 2273, patches are always cumulative unless its specifically designated...

are you connected locallty to the server or logged on remotely as a client? if the latter differences in version level of SSMS can cause this

jscii,

its hard to be 100% sure because theres a lot of info there and can't see the wood for the trees. I get the impression patch is not for windows...

well, looks like a done deal, so good luck. If you get performance problems make sure vmware admin is involved as well and its not just dumped on the 'database'....

thanks guys. I'll check both out. gsquared, any info on what to search for on the MS site?

its an either\or depending on your exact version of SQL (run select @@version), and compare that to the table in the FAQ section in

http://www.microsoft.com/technet/security/bulletin/ms08-040.mspx

Sharon,

I got the impression you were moving off the prod databases and leaving the dev databases on the existing machine. I dont know how powerful your existing machine is but...