hi

i removed instance of sql express 2005 and nothing left in control panel
programs window, then i installed sql express 2008 , but when i went to
services i sow that a service with name sqlexpress is still running why and
from where i ca clean it ?

SQL Server Express Edition is installed using "SQLExpress" name and as a
Named Instance.

So, as you had already uninstalled your SQL Server 2005 Express Edition,
your current SQLExpress intance must be your SQL Server 2008 Express Edition
instance.

Why don't you simply connect to it and use the following commands to verify
its version:
SELECT SERVERPROPERTY('productversion')

OR

Go to SQL Server Configuration Manager and go to properties of your
SQLExpress service (from the "SQL Server services" node) and go to Advanced
tab. There, you'll find "Version" information. If it's 10.x then it's SQL
Server 2008.

--
Ekrem Önsoy

Hi

and thanks for the replay, but when i installed the new instance of sql 2008
express
i named it DevSQLexpress so its not same name plus i can see both in the
services
window sqlexpress and devsqlexpress ???
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643

"Ekrem Önsoy" wrote:

Now, can you see an item named Microsoft SQL Server 2005 on the list of
Add\Remove Programs?

I know, you said that "nothing left" but I want to be sure that you actually
uninstalled the instance itself. Because when you go to Add\Remove Programs
and when you click the Uninstall button a window appears. If you do not
choose an instance name to be removed and if you choose only the shared
components then those shared components will be removed but not the instance
itself.

--
Ekrem Önsoy

"Pure Heart" msdn.com> wrote in message
news:1E519E65-D3F1-40B4-B800-326FBBE20875@microsoft.com...

hi

no nothing is there in control panel, i remember i removed even the instance
but maybe im not sure, but i remember when i installed sql 2008 and named the
instance sqlexpress i got an error, so if the instance is left and running
how can we check and how can it be removed ?

thank you
--
Ammar S. Mitoori
IT Head QIMCO Co.
Tel : +9744831199
Mobile : +9745378400
Fax : +9744831643

"Ekrem Önsoy" wrote: