Equal disk space needed to delete .bak file?

Kind of an obscure question, but here goes.
SQL2000 SP4
I have a E: drive on my SQL server that is ~400gb. On it you'll find
a ~100gb live DB file and last night's 100gb .bak file (maintenance
plan is set for one day retention). The vendor is telling me that I
am going to run out of space doing the SQL backups because 100gb is
used by the live DB, 100gb is used by last nights .bak file, 100gb
will be used to write today's .bak file, and the last 100gb will be
used in the deletion process of removing the old .bak file.
I can't say I know how SQL handles the removal of the old .bak file
but is this a true statement that SQL will need equal free space to
delete the old .bak file?SQL deletes old backups AFTER creating new ones, so you will need space for
at least two backups.
Look at it this way, what happens if your database blows up during a backup.
If you have an older backup, you are fine. If you are overwriting your only
backup, it is time to polish up the resume.
Personally, I would go out and buy a couple of USB drives and back up to
there. Last week my mother purchased a 500GB model for $99. If that is not
an option, you could look into one of the commercially available backup
compression tools. The three major ones are SQLSafe (www.idera.com),
LiteSpeed for SQL (www.quest.com), and SQL Backup (www.red-gate.com).
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
<rockemhard@.gmail.com> wrote in message
news:04b97215-0ec7-4545-a43b-f072fb3c47a2@.e6g2000prf.googlegroups.com...
> Kind of an obscure question, but here goes.
> SQL2000 SP4
> I have a E: drive on my SQL server that is ~400gb. On it you'll find
> a ~100gb live DB file and last night's 100gb .bak file (maintenance
> plan is set for one day retention). The vendor is telling me that I
> am going to run out of space doing the SQL backups because 100gb is
> used by the live DB, 100gb is used by last nights .bak file, 100gb
> will be used to write today's .bak file, and the last 100gb will be
> used in the deletion process of removing the old .bak file.
> I can't say I know how SQL handles the removal of the old .bak file
> but is this a true statement that SQL will need equal free space to
> delete the old .bak file?|||Right, I aggree. In your scenario I need 300gb, not 400gb as the
vendor claims.
100gb - live DB
100gb - last nights backup
100gb - to create tonights backup
--
300gb Total to perform the whole operation
Vendor is saying:
100gb - live DB
100gb - last nights backup
100gb - to create tonights backup
100gb - extra needed to delete last nights backup after a successful
backup
--
400gb Total to perform the whole operation
I just don't understand why that extra 100gb is needed.
On Nov 28, 10:46 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> SQL deletes old backups AFTER creating new ones, so you will need space fo
r
> at least two backups.
> Look at it this way, what happens if your database blows up during a backu
p.
> If you have an older backup, you are fine. If you are overwriting your on
ly
> backup, it is time to polish up the resume.|||Also, a backup on the same disk as the primary is pretty useless when you
think about it.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
<rockemhard@.gmail.com> wrote in message
news:b1987afa-2fde-4bcc-9e25-4d2632f7c009@.j44g2000hsj.googlegroups.com...[vbcol=seagreen]
> Right, I aggree. In your scenario I need 300gb, not 400gb as the
> vendor claims.
> 100gb - live DB
> 100gb - last nights backup
> 100gb - to create tonights backup
> --
> 300gb Total to perform the whole operation
>
> Vendor is saying:
> 100gb - live DB
> 100gb - last nights backup
> 100gb - to create tonights backup
> 100gb - extra needed to delete last nights backup after a successful
> backup
> --
> 400gb Total to perform the whole operation
> I just don't understand why that extra 100gb is needed.
> On Nov 28, 10:46 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:|||Only if it's not getting written to tape ;)
On Nov 28, 11:28 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> Also, a backup on the same disk as the primary is pretty useless when you
> think about it.|||I've never seen Windows needing temp storage in order to delete a file. Perh
aps your vendor somehow
confuses the windows Recycle Bin functionality somehow...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<rockemhard@.gmail.com> wrote in message
news:b1987afa-2fde-4bcc-9e25-4d2632f7c009@.j44g2000hsj.googlegroups.com...[vbcol=seagreen]
> Right, I aggree. In your scenario I need 300gb, not 400gb as the
> vendor claims.
> 100gb - live DB
> 100gb - last nights backup
> 100gb - to create tonights backup
> --
> 300gb Total to perform the whole operation
>
> Vendor is saying:
> 100gb - live DB
> 100gb - last nights backup
> 100gb - to create tonights backup
> 100gb - extra needed to delete last nights backup after a successful
> backup
> --
> 400gb Total to perform the whole operation
> I just don't understand why that extra 100gb is needed.
> On Nov 28, 10:46 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:

Equal disk space needed to delete .bak file?

Kind of an obscure question, but here goes.
SQL2000 SP4
I have a E: drive on my SQL server that is ~400gb. On it you'll find
a ~100gb live DB file and last night's 100gb .bak file (maintenance
plan is set for one day retention). The vendor is telling me that I
am going to run out of space doing the SQL backups because 100gb is
used by the live DB, 100gb is used by last nights .bak file, 100gb
will be used to write today's .bak file, and the last 100gb will be
used in the deletion process of removing the old .bak file.
I can't say I know how SQL handles the removal of the old .bak file
but is this a true statement that SQL will need equal free space to
delete the old .bak file?SQL deletes old backups AFTER creating new ones, so you will need space for
at least two backups.
Look at it this way, what happens if your database blows up during a backup.
If you have an older backup, you are fine. If you are overwriting your only
backup, it is time to polish up the resume.
Personally, I would go out and buy a couple of USB drives and back up to
there. Last week my mother purchased a 500GB model for $99. If that is not
an option, you could look into one of the commercially available backup
compression tools. The three major ones are SQLSafe (www.idera.com),
LiteSpeed for SQL (www.quest.com), and SQL Backup (www.red-gate.com).
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
<rockemhard@.gmail.com> wrote in message
news:04b97215-0ec7-4545-a43b-f072fb3c47a2@.e6g2000prf.googlegroups.com...
> Kind of an obscure question, but here goes.
> SQL2000 SP4
> I have a E: drive on my SQL server that is ~400gb. On it you'll find
> a ~100gb live DB file and last night's 100gb .bak file (maintenance
> plan is set for one day retention). The vendor is telling me that I
> am going to run out of space doing the SQL backups because 100gb is
> used by the live DB, 100gb is used by last nights .bak file, 100gb
> will be used to write today's .bak file, and the last 100gb will be
> used in the deletion process of removing the old .bak file.
> I can't say I know how SQL handles the removal of the old .bak file
> but is this a true statement that SQL will need equal free space to
> delete the old .bak file?|||Right, I aggree. In your scenario I need 300gb, not 400gb as the
vendor claims.
100gb - live DB
100gb - last nights backup
100gb - to create tonights backup
--
300gb Total to perform the whole operation
Vendor is saying:
100gb - live DB
100gb - last nights backup
100gb - to create tonights backup
100gb - extra needed to delete last nights backup after a successful
backup
--
400gb Total to perform the whole operation
I just don't understand why that extra 100gb is needed.
On Nov 28, 10:46 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> SQL deletes old backups AFTER creating new ones, so you will need space for
> at least two backups.
> Look at it this way, what happens if your database blows up during a backup.
> If you have an older backup, you are fine. If you are overwriting your only
> backup, it is time to polish up the resume.|||Also, a backup on the same disk as the primary is pretty useless when you
think about it.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
<rockemhard@.gmail.com> wrote in message
news:b1987afa-2fde-4bcc-9e25-4d2632f7c009@.j44g2000hsj.googlegroups.com...
> Right, I aggree. In your scenario I need 300gb, not 400gb as the
> vendor claims.
> 100gb - live DB
> 100gb - last nights backup
> 100gb - to create tonights backup
> --
> 300gb Total to perform the whole operation
>
> Vendor is saying:
> 100gb - live DB
> 100gb - last nights backup
> 100gb - to create tonights backup
> 100gb - extra needed to delete last nights backup after a successful
> backup
> --
> 400gb Total to perform the whole operation
> I just don't understand why that extra 100gb is needed.
> On Nov 28, 10:46 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
>> SQL deletes old backups AFTER creating new ones, so you will need space
>> for
>> at least two backups.
>> Look at it this way, what happens if your database blows up during a
>> backup.
>> If you have an older backup, you are fine. If you are overwriting your
>> only
>> backup, it is time to polish up the resume.|||Only if it's not getting written to tape ;)
On Nov 28, 11:28 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
> Also, a backup on the same disk as the primary is pretty useless when you
> think about it.|||I've never seen Windows needing temp storage in order to delete a file. Perhaps your vendor somehow
confuses the windows Recycle Bin functionality somehow...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<rockemhard@.gmail.com> wrote in message
news:b1987afa-2fde-4bcc-9e25-4d2632f7c009@.j44g2000hsj.googlegroups.com...
> Right, I aggree. In your scenario I need 300gb, not 400gb as the
> vendor claims.
> 100gb - live DB
> 100gb - last nights backup
> 100gb - to create tonights backup
> --
> 300gb Total to perform the whole operation
>
> Vendor is saying:
> 100gb - live DB
> 100gb - last nights backup
> 100gb - to create tonights backup
> 100gb - extra needed to delete last nights backup after a successful
> backup
> --
> 400gb Total to perform the whole operation
> I just don't understand why that extra 100gb is needed.
> On Nov 28, 10:46 am, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
>> SQL deletes old backups AFTER creating new ones, so you will need space for
>> at least two backups.
>> Look at it this way, what happens if your database blows up during a backup.
>> If you have an older backup, you are fine. If you are overwriting your only
>> backup, it is time to polish up the resume.sql

Enterprise Mgr to remote database

Hi Guys,
I have a web app hosted on an external box with my dev box here. both use identical SQL2000 backends. What I would like is to have my Enterprise Manager have both servers registered so that I can work from one interface. No probs getting the local one registered, but how do I register the external DB server? It's not in my domain, but I do have an IP address and Administrator rights on the remote box. This is probably simple, but I must be missing something.
Thanks
MikeJust add your external server as linked...|||Umm . . OK.

1. So New Sql Server Registration gives me the Register Wizard.
2. I enter the IP address manually in the Available Servers field and click add. Click Next.
3. So far, so good. Can't use my current Windows Account info (different domain), so I select SQL Server login info and put in SA account details.
4. I get a Connecting dialog then "SQL Server does not exist or access denied - ConnectionOpen - (Connect()"

Sorry if I sound dense, but . . . . .|||Try using the subdomain.domain address construct rather than IP address.

Example:

somesqlservermachinename.domain.com

I've had problems connecting to one of our remote SQL Servers via IP address (odd, since the same server is in the same subnet as two other SQL Servers that I can connect fine using their IP Addresses). But the subdomain construct works just fine.

Enterprise Mgr quits after SQL2005 registering

I have both SQL2000 (default) and SQL2005 (second instance) on my laptop. Just to see if it could be done, I registered my (Local) SQL2000 default instance in the Registered Servers part of SQL2005 Mgmt Studio. It worked fine. I can see all the SQL2000 databases, etc in the Mgmt Studio.

But now the SQL2000 default instance will not connect in Enterprise Mgr nor can any of the programs that used to connect to the SQL2000 databases now connect to them. The (local) instance shows in Ent Mgr with the green arrow like it is there but Ent Mgr cannot connect when icon is clicked.

Is there anything I can do to bring the default SQL2000 instance back to be able to connect with anything other than the SQL2005 Mgmt Studio?

Do you get an error ? Which one ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

The local node shows in the tree with a white circle with a green arrowhead inside the circle. Which indicates to me that the SQL instance is running and the Ent Mgr sees it. But when I click on the plus beside the node, I get the error:

A connection could not be established to (LOCAL)

Reason: SQL Server does not exist or access denied
ConnectionOpen(Connect())....

Please verify SQL Server is running and check your SQLServer registration properties (by right-clicking on the (LOCAL) node) and try again.

But I can go to the SQL2005 Mgmt Studio and click on (LOCAL) and see all the stuff in it. In Mgmt Studio, the properties for (LOCAL) show version 8.x of SQLServer.

Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!
Did you uninstall and reinstall the client tools? Did you apply SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!
|||
> I have two workstations with fresh reloaded sql2000(sp3a) client
> software and fresh reloaded MDAC(current version 2.8)
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Yes and Yes.
> I have two workstations(WIN2K SP4) with fresh re-loaded, re-installed,
re-booted sql2000(sp3a) client
> software and fresh re-loaded, re-installed, re-booted MDAC 2.8(current
version).
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
sql

Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!Did you uninstall and reinstall the client tools? Did you apply SP3a?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!|||
> I have two workstations with fresh reloaded sql2000(sp3a) client
> software and fresh reloaded MDAC(current version 2.8)
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Yes and Yes.
> I have two workstations(WIN2K SP4) with fresh re-loaded, re-installed,
re-booted sql2000(sp3a) client
> software and fresh re-loaded, re-installed, re-booted MDAC 2.8(current
version).
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Enterprise mangler

Hi all,
I have two workstations with fresh reloaded sql2000 client
software and fresh reloaded MDAC(current version).
When I go thru SQLEM to the database and drill down to
query the individual tables, I get a the table trying to
open and the the "Provider not found. It may not be
installed correctl" error. The provider is installed
correctly.
The only way I have found to fix this issue is to reload
Window Operating system on the workstation and then there
is no more problem. Needless to say, this is unacceptable.
Does anyone know of a fix for this? MS Support has sofar
been unable to address. Any info could help.
TIA!Did you uninstall and reinstall the client tools? Did you apply SP3a?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Chip" <cjsmith@.teampdc.com> wrote in message
news:10c401c4384e$421a9760$3501280a@.phx.gbl...
> Hi all,
> I have two workstations with fresh reloaded sql2000 client
> software and fresh reloaded MDAC(current version).
> When I go thru SQLEM to the database and drill down to
> query the individual tables, I get a the table trying to
> open and the the "Provider not found. It may not be
> installed correctl" error. The provider is installed
> correctly.
> The only way I have found to fix this issue is to reload
> Window Operating system on the workstation and then there
> is no more problem. Needless to say, this is unacceptable.
> Does anyone know of a fix for this? MS Support has sofar
> been unable to address. Any info could help.
> TIA!

Enterprise Manager Unknown Error

I am running SQL2000 sp3 with 819 hotfix on a 2003
Cluster. When I am on one of the database servers in the
cluster I can select from a table and get data returned.
When I am on the webserver and use EnterPrise I can see
the tables but when I try to select I get 'Unknown Error'.
The same select works from ISQL/W GUI and isql at the
command line while on the webserver.
Any ideas on what to look for would be helpful, nothing is
being logged in the eventlog or the sql log.
Thanks
Check the following;
- The MDAC version on the good and the bad machine. If possible upgrade to
the latest version of MDAC
- Capture the T-SQL command from profiler while you are try to retrieve the
data and see if you can identify the issue.
- Permissions
- The client configuration options by comparing them to the good machine.
HTH
SQL Server Support
Agnes Panosian

Enterprise Manager Tools SQL2000

I have a new laptop with xp pro. Where are the client tools for SQL2000?
I need Query Anzlyser and Enterprise Mgr.

Thanks,
MikeHi Mike,

The SQL Server client tools are part of the SQL Server installation and come with the SQL Server CD.

See the following KB article: (see section: To Install Client Tools Only for SQL Server 2000)
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q303747

This is not included as part of Windows XP Professional.

Regards,
Vikram

Enterprise Manager problem

Using SQL2000 with Enterprise Manager - sometimes, when we try to expand any
tab, such as databases or management, it comes back as empty!! Only
rebooting the server will make it come back but then at some point it stops
working again!
Any ideas much appreciated...
Best regards
Mark
Hello Mark,
Have you tried to reinstall the Enterprise Manager?
Have you applied the latest services pack of the SQL Server?
Did this issue only occur on the local server or remote server?
Please try to reinstall the Enterprise Manager and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hi Wei Lu,
The problem happens on every client on which Enterprise Manager is
installed. It also happens if I make a remote connection. If we reboot the
server then the problem goes away on all clients but then just comes back
after a few days.
Interestingly, while the server is in this "broken" state, using SQL 2005
Management Studio seems to work with no problems.
Best regards
Mark
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NdFWZcMSHHA.2268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Mark,
> Have you tried to reinstall the Enterprise Manager?
> Have you applied the latest services pack of the SQL Server?
> Did this issue only occur on the local server or remote server?
> Please try to reinstall the Enterprise Manager and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
|||On Feb 6, 6:54 am, "Mark Baldwin" <sWoz...@.community.nospam> wrote:
> Hi Wei Lu,
> The problem happens on every client on which Enterprise Manager is
> installed. It also happens if I make a remote connection. If we reboot the
> server then the problem goes away on all clients but then just comes back
> after a few days.
> Interestingly, while the server is in this "broken" state, using SQL 2005
> Management Studio seems to work with no problems.
>
Wei Lu asked about service packs, you didn't answer. Are the CLIENTS
at the same service pack level as the SERVER? If not, you can see
strange things like this occur.
|||Hello Mark,
Have you applied the same service pack on all the clients?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Enterprise Manager problem

Using SQL2000 with Enterprise Manager - sometimes, when we try to expand any
tab, such as databases or management, it comes back as empty!! Only
rebooting the server will make it come back but then at some point it stops
working again!
Any ideas much appreciated...
Best regards
MarkHello Mark,
Have you tried to reinstall the Enterprise Manager?
Have you applied the latest services pack of the SQL Server?
Did this issue only occur on the local server or remote server?
Please try to reinstall the Enterprise Manager and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei Lu,
The problem happens on every client on which Enterprise Manager is
installed. It also happens if I make a remote connection. If we reboot the
server then the problem goes away on all clients but then just comes back
after a few days.
Interestingly, while the server is in this "broken" state, using SQL 2005
Management Studio seems to work with no problems.
Best regards
Mark
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NdFWZcMSHHA.2268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Mark,
> Have you tried to reinstall the Enterprise Manager?
> Have you applied the latest services pack of the SQL Server?
> Did this issue only occur on the local server or remote server?
> Please try to reinstall the Enterprise Manager and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> Get notification to my posts through email? Please refer to
> l]
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> [url]http://msdn.microsoft.com/subscriptions/support/default.aspx." target="_blank">http://msdn.microsoft.com/subscript...t/default.aspx.
> ========================================
==========
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||On Feb 6, 6:54 am, "Mark Baldwin" <sWoz...@.community.nospam> wrote:
> Hi Wei Lu,
> The problem happens on every client on which Enterprise Manager is
> installed. It also happens if I make a remote connection. If we reboot the
> server then the problem goes away on all clients but then just comes back
> after a few days.
> Interestingly, while the server is in this "broken" state, using SQL 2005
> Management Studio seems to work with no problems.
>
Wei Lu asked about service packs, you didn't answer. Are the CLIENTS
at the same service pack level as the SERVER? If not, you can see
strange things like this occur.|||Hello Mark,
Have you applied the same service pack on all the clients?
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

Enterprise Manager problem

Using SQL2000 with Enterprise Manager - sometimes, when we try to expand any
tab, such as databases or management, it comes back as empty!! Only
rebooting the server will make it come back but then at some point it stops
working again!
Any ideas much appreciated...
--
Best regards
MarkHello Mark,
Have you tried to reinstall the Enterprise Manager?
Have you applied the latest services pack of the SQL Server?
Did this issue only occur on the local server or remote server?
Please try to reinstall the Enterprise Manager and let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Wei Lu,
The problem happens on every client on which Enterprise Manager is
installed. It also happens if I make a remote connection. If we reboot the
server then the problem goes away on all clients but then just comes back
after a few days.
Interestingly, while the server is in this "broken" state, using SQL 2005
Management Studio seems to work with no problems.
--
Best regards
Mark
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NdFWZcMSHHA.2268@.TK2MSFTNGHUB02.phx.gbl...
> Hello Mark,
> Have you tried to reinstall the Enterprise Manager?
> Have you applied the latest services pack of the SQL Server?
> Did this issue only occur on the local server or remote server?
> Please try to reinstall the Enterprise Manager and let me know the result.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||On Feb 6, 6:54 am, "Mark Baldwin" <sWoz...@.community.nospam> wrote:
> Hi Wei Lu,
> The problem happens on every client on which Enterprise Manager is
> installed. It also happens if I make a remote connection. If we reboot the
> server then the problem goes away on all clients but then just comes back
> after a few days.
> Interestingly, while the server is in this "broken" state, using SQL 2005
> Management Studio seems to work with no problems.
>
Wei Lu asked about service packs, you didn't answer. Are the CLIENTS
at the same service pack level as the SERVER? If not, you can see
strange things like this occur.|||Hello Mark,
Have you applied the same service pack on all the clients?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

enterprise manager on Windows XP x64

I have just installed Windows XP Pro x64 on new computer and having hard
time installing enterprise manager (SQL Server 2000) to connect to my SQL
2000 Server running on remote machine.
Is there any version of SQL Client Tools for x64 or I have to purchase SQL
Server 2005.
Thanks,
Vlado
"Vlado Jasovic \(www.excelleinc.com\)" <vjasovicATexcelleincDOTcom>
wrote in news:LIydnU5LKY-WLuLenZ2dnUVZ_tidnZ2d@.giganews.com:

> I have just installed Windows XP Pro x64 on new computer and having
> hard time installing enterprise manager (SQL Server 2000) to connect
> to my SQL 2000 Server running on remote machine.
You can install and run the 32-bit version of Enterprise Manager. As far as
I know there is no 64-bit version of it.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging

enterprise manager on Windows XP x64

I have just installed Windows XP Pro x64 on new computer and having hard
time installing enterprise manager (SQL Server 2000) to connect to my SQL
2000 Server running on remote machine.
Is there any version of SQL Client Tools for x64 or I have to purchase SQL
Server 2005.
Thanks,
Vlado"Vlado Jasovic \(www.excelleinc.com\)" <vjasovicATexcelleincDOTcom>
wrote in news:LIydnU5LKY-WLuLenZ2dnUVZ_tidnZ2d@.giganews.com:

> I have just installed Windows XP Pro x64 on new computer and having
> hard time installing enterprise manager (SQL Server 2000) to connect
> to my SQL 2000 Server running on remote machine.
You can install and run the 32-bit version of Enterprise Manager. As far as
I know there is no 64-bit version of it.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
Tom
Hi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>
|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>
|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,

> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>
|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
TomHi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
--
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
>> manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
--
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> Hi Tom,
>> 1. Yes. EM is a client tool which does not need to be licensed, because
>> SQL Server is licensed.
>> 2. Yes. See above.
>> 3. I'm not sure, but I think it is possible.
>> --
>> Danijel Novak
>>
>> "Tom" <mcseman@.hotmail.com> wrote in message
>> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager
>> to manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>>
>|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>> Sorry Danijel & Tom, but:
>> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL
>> Server license being involved. EM is licensed via a client access license
>> from a "real" SQL Server license.
>> 2. Yes, if those systems have SQL Server CALs themselves.
>> 3. Yes
>> HTH,
>> Greg
>> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
>> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> Hi Tom,
>> 1. Yes. EM is a client tool which does not need to be licensed, because
>> SQL Server is licensed.
>> 2. Yes. See above.
>> 3. I'm not sure, but I think it is possible.
>> --
>> Danijel Novak
>>
>> "Tom" <mcseman@.hotmail.com> wrote in message
>> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager
>> to manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>>
>>
>

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
TomHi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQ
L
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,

> 1. Yes. EM is a client tool which does not need to be licensed, because SQ
L
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>

Enterprise manager install...

How can I install Enterprise Manager on a work station? Where in the SQL
2000 serve CD is the setup for the Enterprise Manager?
TIA
Carlos San Miguel
Hi,
Start the setup program (SETUP.EXE), there you can select the Custom install
option and select the client tools only. In the list you can select
Enterprise manager and click ok and continue installation.
Thanks
Hari
MCDBA
"Carlos San Miguel" <yatuchabe@.hotmil.com> wrote in message
news:u1e2ZCDNEHA.3668@.TK2MSFTNGP11.phx.gbl...
> How can I install Enterprise Manager on a work station? Where in the SQL
> 2000 serve CD is the setup for the Enterprise Manager?
> TIA
> Carlos San Miguel
>

Enterprise manager install...

How can I install Enterprise Manager on a work station? Where in the SQL
2000 serve CD is the setup for the Enterprise Manager?
TIA
Carlos San MiguelHi,
Start the setup program (SETUP.EXE), there you can select the Custom install
option and select the client tools only. In the list you can select
Enterprise manager and click ok and continue installation.
Thanks
Hari
MCDBA
"Carlos San Miguel" <yatuchabe@.hotmil.com> wrote in message
news:u1e2ZCDNEHA.3668@.TK2MSFTNGP11.phx.gbl...
> How can I install Enterprise Manager on a work station? Where in the SQL
> 2000 serve CD is the setup for the Enterprise Manager?
> TIA
> Carlos San Miguel
>

Enterprise Manager for SQL2000

Hi everyone:)
would someone know where I can download "enterprise Manager"
( I have to create DB for SQL 2000)
do not know what else to use (do not want Ms access :)
unless is there a way ro convert access in sql?
Thanks in advance
quinyIt should be on the installation CD as part of the client tools if you have bought it.