Microsoft SQL Server vs SQL Server Express

ticktock123

Member

​

Joined

Oct 18, 2002

Location

Up in Good o' Minnesota

• Feb 24, 2009

• #1

I work for a company that sells software for people to use. My job is to install that software. SQL is required as the database for that software. Sometimes customers have SQL already installed and they have no idea what version they have. Since I want to keep what they currently have going, because they may have paid for it...

My question is this: How do you tell the difference between those M$ SQL Server (Full) and M$ SQL Server (Express).

 

petteyg359

Likes Popcorn

​

Joined

Jul 31, 2004

• Feb 24, 2009

• #2

On MySQL, the following does it. It probably works for any SQL server.

Code:

SELECT VERSION()

EDIT:

This tells me you want the following.

Code:

select @@version

 

OP

ticktock123

Member

​

Joined

Oct 18, 2002

Location

Up in Good o' Minnesota

• Feb 24, 2009

• Thread Starter
• #3

That is what I have seen a lot of different places. The problem that i have is they don't install the Mgmt studio for me to write that code in.

Any other ways?

 

petteyg359

Likes Popcorn

​

Joined

Jul 31, 2004

• Feb 24, 2009

• #4

Uh, why do you need this "Management Studio" to do a query? Just connect to the server using something else. If they can't tell you what version they have, nor give you enough access (username/password/remote connection permission) to find it out yourself...

 

OP

ticktock123

Member

​

Joined

Oct 18, 2002

Location

Up in Good o' Minnesota

• Feb 24, 2009

• Thread Starter
• #5

So i found out how. I have to use OSQL. When i am in i just type:

OSQL -S %computername%\ <INSTANCE NAME> -E

1> USE MASTER
2> SELECT @@VERSION
3> Go

 

gomerpile

Disabled

Joined

Feb 23, 2005

• Feb 24, 2009

• #6

Its always nice to have the management console and admin access to sql database adding other databases in your sql without the console, well hum m, I've been unlucky wiff that. Specially if you want to add a data base server for your website (pictures,journals ect ect). Express just dont cut it.

 

petteyg359

Likes Popcorn

​

Joined

Jul 31, 2004

• Feb 25, 2009

• #7

MS SQL Server (non-Express) is far beyond overkill for a personal website.

 

gomerpile

Disabled

Joined

Feb 23, 2005

• Feb 25, 2009

• #8

petteyg359 said:

MS SQL Server (non-Express) is far beyond overkill for a personal website.

Click to expand...

no such thing as overkill to the pc nerd

 

Neuromancer

Member

​

Joined

Oct 11, 2005

Location

Tau'ri

• Feb 25, 2009

• #9

Cant they click start, All programs and see which one they have installed?


It is more professional to be able to tell them of course....