we use SQL2005 std edition! What version ArcGIS are you using?

that would be the path i would recommend 😉

yeah i already checked with him. He wasnt trying to upgrade the SBS instances just one of the 2 new instances

Matt, it would seem he has a mixture of sql2000 instances, 2 of the instances are the MSDE which SBS installs. The other 2 seem to be developer edition

malcolmwatt (1/18/2009)

---

When I connect to any of the 4 instances via SSMS . . . the @@version comes back as:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) ...

how did you get on?

he was probably looking for something along the lines of

sql server stores data on disk in pages which are 8Kb in size. 8 pages make up one extent and these...

as well as the version get the following

select @@servername, serverproperty('servername')

it seems you have 2 instances referencing COW0, my guess is you upgraded the wrong one hence why you see the sql2000 version number. Are the 2 extra instances MSDE...

yes just seen the COW0 instance in the registry too. Scroll across to the right on the right hand pane, what are the installed instances?

what instance name are you typing...

so besides the 2 default desktop engines you have an instance

MSSQL$COW0, what instance are you logging into via SSMS?

Todd Engen (1/8/2009)

---

Change the account that SQL runs under to a local user account instead of the Local System account. For example, create a normal user account named SQLSVC,...

presumably you have access to the source for the CLR functions you are to migrate?

what compression were you using within Litespeed?

on a database that contains a lot of...

SBS installs 2 desktop engine instances. One for Sharepoint and one for SBSMonitoring.

Can you post a registry screenshot of the following key

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server