Mgt Studio Express vs Mgt Studio "Full" questions

I am currently using Management Studio Express to administer remote SQLServer databases I support as a DBA. I notice that I cannot "see" DTS packages on the remote server from Express, but when I login directly to the server (Term Services) and use the local Management Studio (Full?), that I CAN see the DTS packages.

1) What are the other differences between Management Studio Express and Management Studio "Full"?

2) Is it possible to aquire and install (upgrade) on my workstation, to Management Studio "Full" so that I can take advantage of the additional capabilities the "Express" version does not have, in order to manage my remote servers?

TIA,
Phil Streiff, MCDBA

There are quite a few differences between SSMS and SSMS-Express.

You can obtain (and be properly licensed for) SSMS with SQL Server Workgroup, Standard and Enterprise Edition.

|||

Thanks Arnie,

I will definitely upgrade to SSMS now, based on your input.

I suppose I have to pay for the SQL2K5 Standard or Workgroup license, even though I'm only installing the Mgt Studio on my workstation and not the whole database engine.

Phil

|||

SS 2005 Workgroup Edition is about $750 with 5 CALs. (Maybe better pricing is around.)

IF you were in a dev environment, you could get SS Developer's Edition for about $50. But I don't think that it would be legit to manage production servers.

Maybe one or more of your clients provide you with SSMS to manage their servers.

For definitive licensing questions, call the licensing folks at:

Licensing –VL Contact
(800) 426-9400

Good Luck!

Mgmt Studio and Sql 2000

I have a local server I just upgraded to 2005. Everything went well. But,
I
also have a remote sql 2000 server I still need to connect to. Can't seem
to get the tcp/ip connection to old server to work. Go back to old 2000 too
l
and it works fine, but I'd prefer to stay in one environment and migrate to
the new tool. Any ideas?What errors do you get?
-Sue
On Tue, 25 Jul 2006 06:47:02 -0700, Janet
<Janet@.discussions.microsoft.com> wrote:

>I have a local server I just upgraded to 2005. Everything went well. But,
I
>also have a remote sql 2000 server I still need to connect to. Can't seem
>to get the tcp/ip connection to old server to work. Go back to old 2000 to
ol
>and it works fine, but I'd prefer to stay in one environment and migrate to
>the new tool. Any ideas?|||As background - in SSMS, I checked the sql native client connectivity and
tcpip is enabled, alias is listed with correct ip and port. Error is:
===================================
Cannot connect to CASCE.
===================================
This version of Microsoft SQL Server Management Studio can only be used to
connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)
Program Location:
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerType.Microsoft.SqlS
erver.Management.UI.ConnectionDlg.IConnectionValidator.CheckConnection(IDbCo
nnection conn)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.CheckConnection()
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()
"Sue Hoegemeier" wrote:

> What errors do you get?
> -Sue
> On Tue, 25 Jul 2006 06:47:02 -0700, Janet
> <Janet@.discussions.microsoft.com> wrote:
>
>|||That's the error you get when you try to connect to SQL
Server 7 or earlier with SSMS. Double check the version on
the other remote server when you connect with Query Analyzer
using select @.@.version.
-Sue
On Wed, 26 Jul 2006 10:28:02 -0700, Janet
<Janet@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>As background - in SSMS, I checked the sql native client connectivity and
>tcpip is enabled, alias is listed with correct ip and port. Error is:
>===================================
>Cannot connect to CASCE.
>===================================
>This version of Microsoft SQL Server Management Studio can only be used to
>connect to SQL Server 2000 and SQL Server 2005 servers. (ConnectionDlg)
>--
>Program Location:
> at
>Microsoft.SqlServer.Management.UI.ConnectionDlg.SqlServerType.Microsoft.Sql
Server.Management.UI.ConnectionDlg.IConnectionValidator.CheckConnection(IDbC
onnection conn)
> at
>Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.CheckConnection()
> at
>Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectorThread()
>
>"Sue Hoegemeier" wrote:
>|||Sue, holy toledo! You're right! My contact TOLD me they were running sql
2000, but they're running sql 7. I know that the new SSMS won't work with
that - read that in the documentation. Ah, well. Have to keep the old tool
s
around, I guess. Thanks so much for forcing me to double-check.
"Sue Hoegemeier" wrote:

> That's the error you get when you try to connect to SQL
> Server 7 or earlier with SSMS. Double check the version on
> the other remote server when you connect with Query Analyzer
> using select @.@.version.
> -Sue
> On Wed, 26 Jul 2006 10:28:02 -0700, Janet
> <Janet@.discussions.microsoft.com> wrote:
>
>

Method of connect machine?

I work with sql server 2000 and I want to make remote access with another computer .

I want to know what is method

This link will provide you the various ways to connect to SQL Server and access data for your .NET application.

Data -.NET Tutorials for SQL Data
http://dotnetjunkies.com/QuickStartv20/howto/doc/adoplus/xmlfromsqlsrv.aspx

|||I don't mean that I connect machine with sql server2000 by another|||

Please help us understand what you are attempting to accomplish -because it is confusing what you want.

I work with sql server 2000 and I want to make remote access with another computer .

|||

I will explan by another way:

I program database application with sql server 2000 Engine and want to publish it . how can I connect all other machine throw my application with database .

|||

The 'Tutorials' I offered above have a lot of good information about how to connect an Application to SQL Server.

Also, perhaps www.connectionstrings.com may be helpful.

|||

These links should get you started:

http://msdn.microsoft.com/vstudio/express/beginner/

http://msdn2.microsoft.com/en-us/library/ms345332.aspx

http://support.microsoft.com/kb/914277

Method of connect machine?

I work with sql server 2000 and I want to make remote access with another computer .

I want to know what is method

This link will provide you the various ways to connect to SQL Server and access data for your .NET application.

Data -.NET Tutorials for SQL Data
http://dotnetjunkies.com/QuickStartv20/howto/doc/adoplus/xmlfromsqlsrv.aspx

|||I don't mean that I connect machine with sql server2000 by another|||

Please help us understand what you are attempting to accomplish -because it is confusing what you want.

I work with sql server 2000 and I want to make remote access with another computer .

|||

I will explan by another way:

I program database application with sql server 2000 Engine and want to publish it . how can I connect all other machine throw my application with database .

|||

The 'Tutorials' I offered above have a lot of good information about how to connect an Application to SQL Server.

Also, perhaps www.connectionstrings.com may be helpful.

|||

These links should get you started:

http://msdn.microsoft.com/vstudio/express/beginner/

http://msdn2.microsoft.com/en-us/library/ms345332.aspx

http://support.microsoft.com/kb/914277

Message size limitations on Service Broker?

Hi Everyone
Does anyone know if there is/isn't a size limitation on the Service
Broker. I have a remote machine running with express 2005 and I would
like to send message to/from the machine in Head Office running SQL
Server Enteprise 2005.
Thanks in advance
EricThe max message size of the service broker is 2 gigabytes (one billion
Unicode characters) if I am not mistaken.
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
<ricolee99@.gmail.com> wrote in message
news:1158184604.504436.77770@.m73g2000cwd.googlegroups.com...
> Hi Everyone
> Does anyone know if there is/isn't a size limitation on the Service
> Broker. I have a remote machine running with express 2005 and I would
> like to send message to/from the machine in Head Office running SQL
> Server Enteprise 2005.
> Thanks in advance
> Eric
>

Message size limitations on Service Broker?

Hi Everyone
Does anyone know if there is/isn't a size limitation on the Service
Broker. I have a remote machine running with express 2005 and I would
like to send message to/from the machine in Head Office running SQL
Server Enteprise 2005.
Thanks in advance
Eric
The max message size of the service broker is 2 gigabytes (one billion
Unicode characters) if I am not mistaken.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
<ricolee99@.gmail.com> wrote in message
news:1158184604.504436.77770@.m73g2000cwd.googlegro ups.com...
> Hi Everyone
> Does anyone know if there is/isn't a size limitation on the Service
> Broker. I have a remote machine running with express 2005 and I would
> like to send message to/from the machine in Head Office running SQL
> Server Enteprise 2005.
> Thanks in advance
> Eric
>

Message size limitations on Service Broker?

Hi Everyone
Does anyone know if there is/isn't a size limitation on the Service
Broker. I have a remote machine running with express 2005 and I would
like to send message to/from the machine in Head Office running SQL
Server Enteprise 2005.
Thanks in advance
EricThe max message size of the service broker is 2 gigabytes (one billion
Unicode characters) if I am not mistaken.
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
<ricolee99@.gmail.com> wrote in message
news:1158184604.504436.77770@.m73g2000cwd.googlegroups.com...
> Hi Everyone
> Does anyone know if there is/isn't a size limitation on the Service
> Broker. I have a remote machine running with express 2005 and I would
> like to send message to/from the machine in Head Office running SQL
> Server Enteprise 2005.
> Thanks in advance
> Eric
>

Message Queue Task

Simple Question.

I have a requirement to read XML Messages from a Remote private MSMQ.

These messages are essentially Database records that will need cleaning up and insterting into a Local Database table.

Is this possible with SSIS?

Would Biztalk be a more suitable tool for this type of process?

If its possible, are there any resources taht can point me in the right direction?

Thanks for your help!

J.

That is what the Message Queue task is for, so it seems possible, though I don't have personal experience with using it to read a Remote private queue.