Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise thi
s
for a customer who would be quering over the WANHi
http://www.microsoft.com/sql/editio...rd/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WAN

Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise this
for a customer who would be quering over the WANHi
http://www.microsoft.com/sql/editions/standard/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WANsql

Difference between Standard and Enterprise Edition

Where can I find about differences between two edition. I need to advise this
for a customer who would be quering over the WAN
Hi
http://www.microsoft.com/sql/edition...d/default.mspx
"Tariq" <Tariq@.discussions.microsoft.com> wrote in message
news:FF73CE26-9939-4621-83B9-67222E648CE9@.microsoft.com...
> Where can I find about differences between two edition. I need to advise
> this
> for a customer who would be quering over the WAN

Difference between SQL2k Enterprise & Developer editions?

What are the Differences between those two SQL versions
i mean except that with in the developer edition only 1 user can login

on what version is it better to develop ?
does the developer ver. include something that the entprise does not ? (or vice versa)
(say in theory i can choose on which version to work ;-))

thanx, max.Directly from Microsoft's site:

Developer edition is designed to allow developers to build any type of application on top of SQL Server. It includes all the functionality of Enterprise Edition but with a special development and test end-user license agreement (EULA) that prohibits production deployment. It is the ideal choice for Independent Software Vendors (ISVs), consultants, system integrators, solution providers, and corporate developers developing and testing applications because it is cost effective, runs on a variety of platforms, and can be upgraded for production use to SQL Server 2000 Enterprise Edition.

It is the only edition of SQL Server 2000 that gives the licensee the right to download and install SQL Server 2000 Windows CE Edition (SQL Server CE). The Developer Edition licensee also has the right to redistribute SQL Server CE-based applications to an unlimited number of devices at no additional cost beyond the purchase price of SQL Server 2000 Developer Edition.|||SQL Server 2000 has the following editions:

Personal Edition
Standard Edition
Enterprise Edition
Developer Edition
Desktop Engine
SQL Server CE
Evaluation Edition

Personal Edition can work on the Windows 98, Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Workstation 4.0 with Service Pack 5 or later and on the all editions of Windows 2000. This edition is related to SQL Server 7.0 Desktop Edition.

This edition has some restrictions:

maximum 2 CPU
no Distributed Partitioned Views
no Log Shipping
no Parallel DBCC
no Parallel index creation
no Failover clustering
no publishing for transaction replication
maximum 2Gb RAM

Standard Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.

This edition has the following restrictions:

maximum 4 CPU (up to 8 CPU on the Windows NT Enterprise Edition)
no Distributed Partitioned Views
no Log Shipping
no Parallel index creation
no Failover clustering
maximum 2Gb RAM

Enterprise Edition can work on the Windows NT Server 4.0 with Service Pack 5, Windows NT Server 4.0 Enterprise Edition and on the Windows 2000 Server/Advanced Server/DataCenter.

This edition can use:

up to 32 CPU on the Windows 2000 DataCenter up to 8 CPU on the Windows 2000 Advanced Server and on the Windows NT Server 4.0 Enterprise Edition up to 4 CPU on the Windows NT Server 4.0 and on the Windows 2000 Server
up to 64Gb RAM on the Windows 2000 DataCenter up to 8 Gb RAM on the Windows 2000 Advanced Server up to 4 Gb RAM on the Windows 2000 Server up to 3 Gb RAM on the Windows NT Server 4.0 Enterprise Edition up to 2 Gb RAM on the Windows NT Server 4.0
Distributed Partitioned Views
Log Shipping
Parallel index creation
Failover clustering
The Developer Edition can be used by developers to create and debug stored procedures and triggers. This edition comes with its own compact disc and can be upgraded to SQL Server 2000 Enterprise Edition.

The Desktop Engine has no graphical user interface and is related to the MSDE, not to the SQL Server 7.0 Desktop Edition. The size of Desktop Engine databases cannot exceed 2 GB. The Desktop Engine can use maximum 2 CPU.

The SQL Server CE edition can work only on the Microsoft Windows CE, so it has all restrictions of this operation system (can use only 1 CPU, no Parallel index creation, no Full-Text Search and so on).

The Evaluation Edition can be used only for the test purposes to learn more about the new features and enhancements and should be uninstalled after a 120-day evaluation period.

difference between SQL standard Edition and Enterprise Edition

Hi, there,

We are running SQL 2000 & SP4 with our ASP.NET application, now we plan to upgrade to Enterprise Edition due to the huge diffirence in price. Can any one of u give an brief introduction of the difference between these two, and what is the advantages of enterprise edition?

Any suggestion will greately appreciated.

Shermaine

There's a good comparison of the various versions of SQL Server here:-

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

shermaine wrote:

now we plan to upgrade to Enterprise Edition due to the huge diffirence in price.

That seems logical.

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
ShermaineHi
A list of features is at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
The higher spec hardware support is at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
John
"xiaomei" wrote:
> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterprise
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine|||Also know that if you are running Windows XP you cannot install enterprise
edition
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1|||Dear John,
Thanks so much.
Have a nice day!
Shermaine
"John Bell" wrote:
> Hi
> A list of features is at:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
> The higher spec hardware support is at:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> John
>
> "xiaomei" wrote:
> > Hi, there,
> > I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> > with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> > to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> > any one of u tell me the difference between standard Edition and Enterprise
> > Edition due to there is a huge difference in price.
> >
> > Thanks in advanced
> >
> > Rgds
> > Shermaine|||Hi, thanks a lot.
Yes, we will run on windows 2000 server.
BTW, Does Microsoft still provide evaluation copy download for Windows SQL
2000 Enterprise Edition?
Thanks
Shermaine
"Prospero via SQLMonster.com" wrote:
> Also know that if you are running Windows XP you cannot install enterprise
> edition
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
>|||Hi
An evaluation copy would only be needed if you are going to use the
additional features. I would not load this into a live environment. An
alternative might be to use the developer edition in your test environment,
if this is for stress testing then you should use similar hardware to the
live environment.
John
"xiaomei" wrote:
> Hi, thanks a lot.
> Yes, we will run on windows 2000 server.
> BTW, Does Microsoft still provide evaluation copy download for Windows SQL
> 2000 Enterprise Edition?
> Thanks
> Shermaine
> "Prospero via SQLMonster.com" wrote:
> > Also know that if you are running Windows XP you cannot install enterprise
> > edition
> >
> > --
> > Message posted via SQLMonster.com
> > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
> >

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't wan
t
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
ShermaineHi
A list of features is at:
http://msdn.microsoft.com/library/d...br />
1cdv.asp
The higher spec hardware support is at:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
John
"xiaomei" wrote:

> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't w
ant
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterpris
e
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine|||Also know that if you are running Windows XP you cannot install enterprise
edition
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200601/1

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
Shermaine
Hi
A list of features is at:
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
The higher spec hardware support is at:
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
John
"xiaomei" wrote:

> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterprise
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine
|||Also know that if you are running Windows XP you cannot install enterprise
edition
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200601/1

Difference between SQL 2000 st. and SQL 2000 Enterprise

Hi there
I feel a bit silly here. If spent the last 45 mins searching the web trying
to find a definite list of the differences between SQL 2000 Standard and SQL
2000 Enterprise. All the links at microsoft.com seem to redirect to the 2005
version. If anyone can link me to a feature comparison or know the numbers
off the top of their head I would be grateful. The most pressing question is
this:
What if I buy a standard edition and install it on a server with 4Gb RAM,
would I:
Violate my license since standard only supports up to 2 Gb?
or would the SQL server simply just use only 2Gb RAM and work just fine and
no license would be violated?
Thanks in advance
IbIb,
In your SQL Server 2000 Books Online is a topic "Features Supported by the
Editions of SQL Server 2000" that will give general guidance on features.
Installing standard edition on a server with more RAM will not violate a
license. SQL Server will only use as much memory as it can.
RLF
"Ib Schrader" <ibschrader@.gmail.com> wrote in message
news:e1LaFcw6HHA.2632@.TK2MSFTNGP06.phx.gbl...
> Hi there
> I feel a bit silly here. If spent the last 45 mins searching the web
> trying to find a definite list of the differences between SQL 2000
> Standard and SQL 2000 Enterprise. All the links at microsoft.com seem to
> redirect to the 2005 version. If anyone can link me to a feature
> comparison or know the numbers off the top of their head I would be
> grateful. The most pressing question is this:
> What if I buy a standard edition and install it on a server with 4Gb RAM,
> would I:
> Violate my license since standard only supports up to 2 Gb?
> or would the SQL server simply just use only 2Gb RAM and work just fine
> and no license would be violated?
> Thanks in advance
> Ib
>|||The information is in Books on Line, the documentation. You could
download and install that from the Microsoft site, or read it on the
web.
http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx
That should put you int he neighborhood.
Roy Harvey
Beacon Falls, CT
On Thu, 30 Aug 2007 15:09:36 +0200, "Ib Schrader"
<ibschrader@.gmail.com> wrote:
>Hi there
>I feel a bit silly here. If spent the last 45 mins searching the web trying
>to find a definite list of the differences between SQL 2000 Standard and SQL
>2000 Enterprise. All the links at microsoft.com seem to redirect to the 2005
>version. If anyone can link me to a feature comparison or know the numbers
>off the top of their head I would be grateful. The most pressing question is
>this:
>What if I buy a standard edition and install it on a server with 4Gb RAM,
>would I:
>Violate my license since standard only supports up to 2 Gb?
>or would the SQL server simply just use only 2Gb RAM and work just fine and
>no license would be violated?
>Thanks in advance
>Ib
>|||Books online..never knew something like that existed.
Thanks to both of you
"Roy Harvey" <roy_harvey@.snet.net> wrote in message
news:nmidd351bfo31q14ee6hufgq5jf75r2e89@.4ax.com...
> The information is in Books on Line, the documentation. You could
> download and install that from the Microsoft site, or read it on the
> web.
> http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx
> That should put you int he neighborhood.
> Roy Harvey
> Beacon Falls, CT
> On Thu, 30 Aug 2007 15:09:36 +0200, "Ib Schrader"
> <ibschrader@.gmail.com> wrote:
>>Hi there
>>I feel a bit silly here. If spent the last 45 mins searching the web
>>trying
>>to find a definite list of the differences between SQL 2000 Standard and
>>SQL
>>2000 Enterprise. All the links at microsoft.com seem to redirect to the
>>2005
>>version. If anyone can link me to a feature comparison or know the numbers
>>off the top of their head I would be grateful. The most pressing question
>>is
>>this:
>>What if I buy a standard edition and install it on a server with 4Gb RAM,
>>would I:
>>Violate my license since standard only supports up to 2 Gb?
>>or would the SQL server simply just use only 2Gb RAM and work just fine
>>and
>>no license would be violated?
>>Thanks in advance
>>Ib

Difference between Enterprise Manager and Query Analyzer

Hi All,

What are the pros and cons between using Enterprise Manager or Query
Analyzer for my queries.

Currently I use Enterprise Manager because I prefer the interface and
only use Query Analayzer when queries time out in Enterprise Manager,
but I'm sure there must be more to it.

Regards,
Ciarn(chudson007@.hotmail.com) writes:

Quote:

Originally Posted by

What are the pros and cons between using Enterprise Manager or Query
Analyzer for my queries.
>
Currently I use Enterprise Manager because I prefer the interface and
only use Query Analayzer when queries time out in Enterprise Manager,
but I'm sure there must be more to it.

Query Analyzer is a tool that I use daily, and it's always open on my
desktop. Enterprise Manager I only start if I need to work with Agent jobs.

As far as I know EM does not even have a query window. Probably you are
using the Query Designer, which may look nice, but which may add junk to
your queries. And there is a whole lot of things you do in it. Only in a
query window in Query Analyzer (or a command-line tool like OSQL), you can
use all T-SQL statements.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql

Difference between Enterprise and Developer Editons

Hi All,
What is the difference between the Enterprise and Developer Editions of SQL
server? I am not a developer but some of the developers in our organization
have asked me to determine the difference. We are an MSDN subscriber and we
are currently using the Developer Edition.
Thanks for the help,
JohnEnterprise and Developer are functionally equivalent. The difference is that
Developer is licensed only for development and testing use, not for
production.
David Portas
SQL Server MVP
--|||Hi,
See the below link:-
http://www.microsoft.com/sql/techin...ing/ChoosEd.doc
Thanks
Hari
SQL Server MVP
"Cobra967" <Cobra967@.discussions.microsoft.com> wrote in message
news:AAAEA29E-7986-442D-B9FA-D6D887E25C21@.microsoft.com...
> Hi All,
> What is the difference between the Enterprise and Developer Editions of
> SQL
> server? I am not a developer but some of the developers in our
> organization
> have asked me to determine the difference. We are an MSDN subscriber and
> we
> are currently using the Developer Edition.
> Thanks for the help,
> John

Difference between Enterprise and Developer Editons

Hi All,
What is the difference between the Enterprise and Developer Editions of SQL
server? I am not a developer but some of the developers in our organization
have asked me to determine the difference. We are an MSDN subscriber and we
are currently using the Developer Edition.
Thanks for the help,
JohnEnterprise and Developer are functionally equivalent. The difference is that
Developer is licensed only for development and testing use, not for
production.
--
David Portas
SQL Server MVP
--|||Hi,
See the below link:-
http://www.microsoft.com/sql/techinfo/planning/ChoosEd.doc
Thanks
Hari
SQL Server MVP
"Cobra967" <Cobra967@.discussions.microsoft.com> wrote in message
news:AAAEA29E-7986-442D-B9FA-D6D887E25C21@.microsoft.com...
> Hi All,
> What is the difference between the Enterprise and Developer Editions of
> SQL
> server? I am not a developer but some of the developers in our
> organization
> have asked me to determine the difference. We are an MSDN subscriber and
> we
> are currently using the Developer Edition.
> Thanks for the help,
> John

Difference between Enterprise and Developer Editons

Hi All,
What is the difference between the Enterprise and Developer Editions of SQL
server? I am not a developer but some of the developers in our organization
have asked me to determine the difference. We are an MSDN subscriber and we
are currently using the Developer Edition.
Thanks for the help,
John
Enterprise and Developer are functionally equivalent. The difference is that
Developer is licensed only for development and testing use, not for
production.
David Portas
SQL Server MVP
|||Hi,
See the below link:-
http://www.microsoft.com/sql/techinf...ng/ChoosEd.doc
Thanks
Hari
SQL Server MVP
"Cobra967" <Cobra967@.discussions.microsoft.com> wrote in message
news:AAAEA29E-7986-442D-B9FA-D6D887E25C21@.microsoft.com...
> Hi All,
> What is the difference between the Enterprise and Developer Editions of
> SQL
> server? I am not a developer but some of the developers in our
> organization
> have asked me to determine the difference. We are an MSDN subscriber and
> we
> are currently using the Developer Edition.
> Thanks for the help,
> John

Difference between "Database -- > Users" and "Security --> Users"

Hi Team,

In SQL Enterprise Manager, when we expand "Database -->Users", we see the

users there. When we expand "Security --> logins" we see the same users there.

Can you differentiate these two.

Thanks

Santhosh

Logins are the accounts used to connect to the SQL Server, users are the accounts used within individual databases. So it is possible (not very useful, but possible) to have a login so that you can connect to the server but not be able to actually do anything in any databases. Each login must be mapped to a user in each database that the login needs to use.

Permissions in a database are assigned to users not to logins.

You should read up more on users, logins, and permissions in Books Online.

Diferrential Backup's

MS 2000 Server MSSQL 7. For an experiment I set up a differential backup
with Enterprise Manage on a training database. I cannot figure out how to
reconfigure the backup; turn it off, rename it, set new time, etc. Is
there anyway to at least turn this differential backup off? ThanksHi
That backup should be run from a scheduled job that appears in the
Management/SQL Server Agent/Jobs branch in Enterprise Manager, you can then
right click and disable or delete the given job.
John
"JD Henderson" <jdhend@.hotmail.com> wrote in message
news:MPG.1a173dac5a7c2c1a989680@.msnews.microsoft.com...
> MS 2000 Server MSSQL 7. For an experiment I set up a differential backup
> with Enterprise Manage on a training database. I cannot figure out how to
> reconfigure the backup; turn it off, rename it, set new time, etc. Is
> there anyway to at least turn this differential backup off? Thanks|||Thanks John
In article <bol5ef$4j6$1@.sparta.btinternet.com>,
jbellnewsposts@.hotmail.com says...
> Hi
> That backup should be run from a scheduled job that appears in the
> Management/SQL Server Agent/Jobs branch in Enterprise Manager, you can then
> right click and disable or delete the given job.
> John
> "JD Henderson" <jdhend@.hotmail.com> wrote in message
> news:MPG.1a173dac5a7c2c1a989680@.msnews.microsoft.com...
> > MS 2000 Server MSSQL 7. For an experiment I set up a differential backup
> > with Enterprise Manage on a training database. I cannot figure out how to
> > reconfigure the backup; turn it off, rename it, set new time, etc. Is
> > there anyway to at least turn this differential backup off? Thanks
>
>

Diap-up Connection Problem

Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>

Diap-up Connection Problem

Hi,
I want to replicate data between two SQL Servers but I have connection
problem:
Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
Server A dials to server B. Server A can ping server B (using IP) and I
registered the SQL Server of B on A (in E.M). But server B cannot ping
Server A. I have disabled any kind of anti-virus or ISA service. All of
ports are open, no active firewall. What are the other things that I must
check?
Any help would be greatly appreciated.
LeilaRun tracert to determine exactly where it is failing. It could also be a
name resolution problem. ping -a should help you with this.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Leila" <Leilas@.hotpop.com> wrote in message
news:e1YmastyGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I want to replicate data between two SQL Servers but I have connection
> problem:
> Server A: Win 2003 SP1, SQL Server 2000 Enterprise Edition SP3
> Server B: Win XP SP2, SQL Server 2000 Personal Edition SP3
> Server A dials to server B. Server A can ping server B (using IP) and I
> registered the SQL Server of B on A (in E.M). But server B cannot ping
> Server A. I have disabled any kind of anti-virus or ISA service. All of
> ports are open, no active firewall. What are the other things that I must
> check?
> Any help would be greatly appreciated.
> Leila
>

Dialup Dead - Slammered again?

HI I am trying to logon to a remote server with Enterprise Manager via
dialup, which worked fine for the last 6 months. I can connect to the
server but Now I am getting the egg timer for ever when expanding the
database node. At the same time my dialup maxes out (around 3 kB / sec)
and seems to load ridiculous amounts of data (by dialup standards x-p).
I have SP4 installed, is this a new version of Slammer or what?
PS: I can connect with Query Analyzer and run queries. My version
number is 8.00.2039 (SP 4).
any idea what to do, did I miss a new patch / virus?
Axelrealraven2000@.hotmail.com wrote:
> any idea what to do, did I miss a new patch / virus?
> Axel
>
Since you can connect with QA, you should be able to run sp_who2 or look
at the sysprocesses table. Attempt your EM connection again, and while
it's spinning, jump into QA and look at sysprocesses to see what's
running. Look for blocking, or some other intensive process that might
be running.

Diagrams not visible in EM in Terminal Server

Hi,
I cannot see the content of diagrams when opening the Enterprise Manager in
a RemoteDesktop session on a Terminal Server. The page is simply empty. I can
however create new diagrams which remain visible after closing an re-opening.
They are again not visible if modified in the Enterprise Manager on another
machine not logged on to the Terminal Server.
Any ideas are appreciated.
TIA,
Norbert Meiss
I just tried the same thing, and the diagrams opened fine for me.
Simon Worth
"Norbert Meiss" <NorbertMeiss@.discussions.microsoft.com> wrote in message
news:220AFBB0-43D5-44D7-A429-AD2D8B140E60@.microsoft.com...
> Hi,
> I cannot see the content of diagrams when opening the Enterprise Manager
in
> a RemoteDesktop session on a Terminal Server. The page is simply empty. I
can
> however create new diagrams which remain visible after closing an
re-opening.
> They are again not visible if modified in the Enterprise Manager on
another
> machine not logged on to the Terminal Server.
> Any ideas are appreciated.
> TIA,
> Norbert Meiss

Diagrams not visible in EM in Terminal Server

Hi,
I cannot see the content of diagrams when opening the Enterprise Manager in
a RemoteDesktop session on a Terminal Server. The page is simply empty. I can
however create new diagrams which remain visible after closing an re-opening.
They are again not visible if modified in the Enterprise Manager on another
machine not logged on to the Terminal Server.
Any ideas are appreciated.
TIA,
Norbert MeissI just tried the same thing, and the diagrams opened fine for me.
--
Simon Worth
"Norbert Meiss" <NorbertMeiss@.discussions.microsoft.com> wrote in message
news:220AFBB0-43D5-44D7-A429-AD2D8B140E60@.microsoft.com...
> Hi,
> I cannot see the content of diagrams when opening the Enterprise Manager
in
> a RemoteDesktop session on a Terminal Server. The page is simply empty. I
can
> however create new diagrams which remain visible after closing an
re-opening.
> They are again not visible if modified in the Enterprise Manager on
another
> machine not logged on to the Terminal Server.
> Any ideas are appreciated.
> TIA,
> Norbert Meiss