Showing posts with label upgrade. Show all posts
Showing posts with label upgrade. Show all posts

Friday, February 24, 2012

How do I do an Unattended install of "MSDE 1.0 sp4"?

I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch

but I need to do either a Silent or Unattended install.

Does anyone know how to do this? Does anyone know the

command-line command to do this?

I tried using...

sql70sp4.exe -a -f1 "unattend.iss"

....but that didn't work. It popped up a window asking where I

should extract the contents of the .exe (that shouldn't be appearing

either) and then after it extracted it didn't do anything else.

Any help is greatly appreciated.

see if this helps

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q233312

Sunday, February 19, 2012

How do I display/upgrade SQL license Info

In SQL 2000 you went to Control Panel and SQL Licensing to view licensing mode and qty. I have searched everywhere for the equivelant in 2005 including books online, knowledge base but can't find anything.

Anybody know where it is hidden as I need to check this server is set up for per processor and check how many processors?

Thanks

Richard

This does not exist in SQL Server 2005, it works by the honour system