Prev: Spurious data being inserted in field
Next: Trouble getting execution plan
From: MN on 21 Jul 2010 16:02
Hi,
Could you give me an advice what are different between MSSQL$SQLEXPRESS and
MSSQL SQLEXPRESS? Sorry I am not good memory :"(

Thank you all.
From: John Bell on 21 Jul 2010 17:49
On Wed, 21 Jul 2010 13:02:37 -0700, MN <MN(a)discussions.microsoft.com>
wrote:

>Hi,
>Could you give me an advice what are different between MSSQL$SQLEXPRESS and
>MSSQL SQLEXPRESS? Sorry I am not good memory :"(
>
>Thank you all.


MSSQL$SQLEXPRESS is the service name for a default SQL Express
Instance. MSSQL SQLEXPRESS does not have any particular meaning AFAIK,
The default instancename for SQLExpress would be
computername\SQLExpress

The service name for a default instance of SQL Server would be
MSSQLSQLSERVER.

John

From: Erland Sommarskog on 21 Jul 2010 17:52
MN (MN(a)discussions.microsoft.com) writes:
> Could you give me an advice what are different between MSSQL$SQLEXPRESS
> and MSSQL SQLEXPRESS? Sorry I am not good memory :"(

MSSQL$SQLEXPRESS would be an instance of SQL Server, probably of Express
Edition, unless someone is pulling your legs. The other does not mean
anything in particular.

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: MN on 22 Jul 2010 09:28
Thank you John and Erland. I remember now :"-)

Best Regards.
NM

"John Bell" wrote:

> On Wed, 21 Jul 2010 13:02:37 -0700, MN <MN(a)discussions.microsoft.com>
> wrote:
>
> >Hi,
> >Could you give me an advice what are different between MSSQL$SQLEXPRESS and
> >MSSQL SQLEXPRESS? Sorry I am not good memory :"(
> >
> >Thank you all.
>
>
> MSSQL$SQLEXPRESS is the service name for a default SQL Express
> Instance. MSSQL SQLEXPRESS does not have any particular meaning AFAIK,
> The default instancename for SQLExpress would be
> computername\SQLExpress
>
> The service name for a default instance of SQL Server would be
> MSSQLSQLSERVER.
>
> John
>
> .
>
 | 
Pages: 1
Prev: Spurious data being inserted in field
Next: Trouble getting execution plan