Difference between SQL Server Express Utility and SQL Server Server

What is the main difference between SQL Server Express Utility and SQL
Server Server Management Studio Express? Can they both be used to
connect to SQL Server 2005 databases? Which one do you folks prefer?
Thanks,
J.S.J.S. wrote:
> What is the main difference between SQL Server Express Utility and SQL
> Server Server Management Studio Express? Can they both be used to
> connect to SQL Server 2005 databases? Which one do you folks prefer?
> Thanks,
> J.S.
I think the overview on this page says it all:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> I think the overview on this page says it all:
> http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
It mentions about the SSMSE but not about the SQL Server Express Utility.
Thanks,
J.S.|||J.S. wrote:
> Tracy McKibben wrote:
>> I think the overview on this page says it all:
>> http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796
>
> It mentions about the SSMSE but not about the SQL Server Express Utility.
> Thanks,
> J.S.
My mistake, I thought you were comparing the Express GUI to the full
product. Isn't the Utility product a command-line tool?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Tracy McKibben wrote:
> My mistake, I thought you were comparing the Express GUI to the full
> product. Isn't the Utility product a command-line tool?
It might well be. I have only been using SSMSE but I'll install the
utility tool and see how it works.
Thanks,
J.S.|||SSEUtil is a command line tool designed mainly to allow you to work with
User Instances. The other tools can't start up a user instance for example
but must attach to a running instance so if you are going to use the
standard SQL Server tools you may have to use SSEUtil to start up the user
instance first. There's more information on user instances here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"J.S." <jss@.nospam.com> wrote in message
news:Ot3c83JGHHA.2464@.TK2MSFTNGP06.phx.gbl...
> Tracy McKibben wrote:
>> My mistake, I thought you were comparing the Express GUI to the full
>> product. Isn't the Utility product a command-line tool?
> It might well be. I have only been using SSMSE but I'll install the
> utility tool and see how it works.
> Thanks,
> J.S.