How to tell what SQL 2005 version I'm runing?

Hey everyone,
We have a server that is running SQL 2005 but we don't know if it's full SQL
2005 or SQL 2005 Express. Can someone tell me how I can find out?
We DON'T have SQL Server Mangement Studio installed.
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************> We have a server that is running SQL 2005 but we don't know if it's full
> SQL 2005 or SQL 2005 Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
Anywhere?
If you're going to manage SQL Server, you should have it SOMEWHERE. If not
regular Management Studio then at least the express version (which is free).
http://tinyurl.com/j7wjl
From there you can run
SELECT @.@.VERSION;|||underprocessable|||You should be able to tell something from your services applet in control
panel / administrative tools. By default I think a SQL Express instance
will be listed as SQL Server (SQLEXPRESS).
But, what on earth could you be doing with SQL Server? If you can't even
connect to it in order to see what edition it is, how are you managing it,
how do you expect to create databases, etc.? This is why I suggested
getting at least Management Studio Express. It doesn't do everything, but
it is better than zero.
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Clayton Sutton" <none@.none.com> wrote in message
news:lXM%h.208335$RF.182058@.fe02.news.easynews.com...
> Hey Aaron,
> We need to know which version we have installed so we will know how to
> back it up. If is't the Express version then NetBackup will not back it
> up with their SQL Agent. However, if it's the Express version then we
> have to us a command line to back it up. But we don't know which version
> is installed.
> Here is a screen shot of what I have installed.|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:uVOXCDPkHHA.1340@.TK2MSFTNGP04.phx.gbl...
> You should be able to tell something from your services applet in control
> panel / administrative tools. By default I think a SQL Express instance
> will be listed as SQL Server (SQLEXPRESS).
> But, what on earth could you be doing with SQL Server? If you can't even
> connect to it in order to see what edition it is, how are you managing it,
> how do you expect to create databases, etc.?

>This is why I suggested getting at least Management Studio Express. It
>doesn't do everything, but it is better than zero.
Well, this is one reason I want to know which version is installed so I will
know which Management Studio to install, the full version or the Express
version.
SQL is running on a SharePoint 2007 server. SharePoint needed SQL, however,
no one can remember if the full version or the Express version was installed
during instalation.
Clayton

> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:lXM%h.208335$RF.182058@.fe02.news.easynews.com...
>|||> Well, this is one reason I want to know which version is installed so I
> will know which Management Studio to install, the full version or the
> Express version.
Well, since Management Studio Express is free, it is not going to hurt you
to install it.
And if you had access to Management Studio (e.g. on a SQL Server
installation CD), then I guess you could look at the CD to see which edition
you have, since it's printed on the label. :-)

> SQL is running on a SharePoint 2007 server. SharePoint needed SQL,
> however, no one can remember if the full version or the Express version
> was installed during instalation.
Have you looked at the SharePoint site, or the SharePoint documentation?
Surely it is listed there somewhere. Also, did you try looking in the
services applet like I suggested earlier?|||How about connection with SQLCMD and execute below?
SELECT @.@.VERSION
GO
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clayton Sutton" <none@.none.com> wrote in message
news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
> Hey everyone,
> We have a server that is running SQL 2005 but we don't know if it's full S
QL 2005 or SQL 2005
> Express. Can someone tell me how I can find out?
> We DON'T have SQL Server Mangement Studio installed.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it. Y
ou can find it at:
> http://www.nikoli.net/itunepod
> *******************
>
>|||Hey Aaron,
After I got in to work today I checked the services on that server and it
looks like we are running SQL Express. This is what it says: SQL Server
(SQLEXPRESS).
Thanks for your help dude! Now I will install the Management Studio.
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:%23nHfu0RkHHA.1828@.TK2MSFTNGP05.phx.gbl...
> Well, since Management Studio Express is free, it is not going to hurt you
> to install it.
> And if you had access to Management Studio (e.g. on a SQL Server
> installation CD), then I guess you could look at the CD to see which
> edition you have, since it's printed on the label. :-)
>
> Have you looked at the SharePoint site, or the SharePoint documentation?
> Surely it is listed there somewhere. Also, did you try looking in the
> services applet like I suggested earlier?
>|||Hey Tibor,
Thanks for the advice, however, I don't know how to use the sqlcmd command.
Got any tips? I tried the /? but that didn't help much.
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:edgGDLVkHHA.568@.TK2MSFTNGP02.phx.gbl...
> How about connection with SQLCMD and execute below?
> SELECT @.@.VERSION
> GO
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Clayton Sutton" <none@.none.com> wrote in message
> news:GqM%h.317607$1Z1.222052@.fe03.news.easynews.com...
>|||Sorry Aaron,
I was looking at the wrong server. Looking at the "right" server services
it says: SQL Server (OFFICESERVERS).
TIA,
Clayton
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
*******************
"Clayton Sutton" <none@.none.com> wrote in message
news:j2%%h.274750$9i2.95644@.fe06.news.easynews.com...
> Hey Aaron,
> After I got in to work today I checked the services on that server and it
> looks like we are running SQL Express. This is what it says: SQL Server
> (SQLEXPRESS).
> Thanks for your help dude! Now I will install the Management Studio.
> --
> TIA,
>
> Clayton
>
> P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
> You can find it at: http://www.nikoli.net/itunepod
> *******************
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in
> message news:%23nHfu0RkHHA.1828@.TK2MSFTNGP05.phx.gbl...
>