Entreprise Manager behaviour

Dear all,
I've got the following scenario:
-Got two EM instances running at the same time. The same view on the right
for both, this is, Tables.
From EM1 I create a table called T. After that I'm going to EM2 and refresh.
Fine because I am seeing the same object.
-Come back to EM1 and drop T object and create again another T object but
different, with more fields. When this time I'm going to EM2 and I do drop
action I've dropped the most new object not the old one when I was waiting a
messagebox or something like that warning me that I am deleting an object
which is different than I though.
Jezz, how can I do for to change this behaviour?
Any help or comment woud be very appreciated.
Current location: Alicante (ES)The behaviour you describe is exactly os should be expected.
When you drop a table in EM, EM actually executes a T-SQL drop table
statement.
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:633618A6-5345-4F82-B27F-4C362546AA93@.microsoft.com...
> Dear all,
> I've got the following scenario:
> -Got two EM instances running at the same time. The same view on the right
> for both, this is, Tables.
> From EM1 I create a table called T. After that I'm going to EM2 and
> refresh.
> Fine because I am seeing the same object.
> -Come back to EM1 and drop T object and create again another T object but
> different, with more fields. When this time I'm going to EM2 and I do drop
> action I've dropped the most new object not the old one when I was waiting
> a
> messagebox or something like that warning me that I am deleting an object
> which is different than I though.
> Jezz, how can I do for to change this behaviour?
> Any help or comment woud be very appreciated.
> --
> Current location: Alicante (ES)|||Hi Stephany,
Yes, I perfectly know it, but I was wondering myself how to change
thanks anyway
--
Current location: Alicante (ES)
"Stephany Young" wrote:

> The behaviour you describe is exactly os should be expected.
> When you drop a table in EM, EM actually executes a T-SQL drop table
> statement.
>
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:633618A6-5345-4F82-B27F-4C362546AA93@.microsoft.com...
>
>|||> Jezz, how can I do for to change this behaviour?
Stop using EM at all :-))
"Enric" <vtam13@.terra.es.(donotspam)> wrote in message
news:633618A6-5345-4F82-B27F-4C362546AA93@.microsoft.com...
> Dear all,
> I've got the following scenario:
> -Got two EM instances running at the same time. The same view on the right
> for both, this is, Tables.
> From EM1 I create a table called T. After that I'm going to EM2 and
> refresh.
> Fine because I am seeing the same object.
> -Come back to EM1 and drop T object and create again another T object but
> different, with more fields. When this time I'm going to EM2 and I do drop
> action I've dropped the most new object not the old one when I was waiting
> a
> messagebox or something like that warning me that I am deleting an object
> which is different than I though.
> Jezz, how can I do for to change this behaviour?
> Any help or comment woud be very appreciated.
> --
> Current location: Alicante (ES)|||What would you like to change? Do you want to drop objects without actually
dropping them?
What are you trying to achieve?
ML
http://milambda.blogspot.com/|||In fact, I hope that in early period of time EM will be living and sharing
time with Sql Management Studio
--
Current location: Alicante (ES)
"Uri Dimant" wrote:

> Stop using EM at all :-))
> "Enric" <vtam13@.terra.es.(donotspam)> wrote in message
> news:633618A6-5345-4F82-B27F-4C362546AA93@.microsoft.com...
>
>|||No, I hope that EM works fine. Did it make sense such scenario? I think so.
--
Current location: Alicante (ES)
"ML" wrote:

> What would you like to change? Do you want to drop objects without actuall
y
> dropping them?
> What are you trying to achieve?
> ML
> --
> http://milambda.blogspot.com/|||Great, trade in your Yugo for a Kia. Management Studio is certainly a
better tool than Enterprise Manager in general, but it still shares a lot of
its flaws and limitations.
Hopefully, at least, you'll learn commands like DROP TABLE and BEGIN TRAN /
COMMIT TRAN, instead of pointing and clicking yourself to inevitable
disaster.

> In fact, I hope that in early period of time EM will be living and sharing
> time with Sql Management Studio|||drop and commit? I unfortunately know them
--
Current location: Alicante (ES)
"Aaron Bertrand [SQL Server MVP]" wrote:

> Great, trade in your Yugo for a Kia. Management Studio is certainly a
> better tool than Enterprise Manager in general, but it still shares a lot
of
> its flaws and limitations.
> Hopefully, at least, you'll learn commands like DROP TABLE and BEGIN TRAN
/
> COMMIT TRAN, instead of pointing and clicking yourself to inevitable
> disaster.
>
>
>
>
>
>|||> drop and commit? I unfortunately know them
Well, I should have said, learn to use them. I would much rather write DROP
TABLE and/or wrap my commands in transactions than blindly trust what some
GUI is going to do. Especially when I'm doing some backhanded thing like
just trying to see what will happen when I bounce quickly between two open
apps on the same machine...
A

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Query
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.
Does the registration in Enterprise manager use the same login as the one you
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
Russel Loski, MCSD.Net
"doug" wrote:

> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
[vbcol=seagreen]
> Does the registration in Enterprise manager use the same login as the one you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:

> doug wrote:
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and the
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:

> doug wrote:
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Query
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.Does the registration in Enterprise manager use the same login as the one you
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
--
Russel Loski, MCSD.Net
"doug" wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
> Does the registration in Enterprise manager use the same login as the one you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
> > I have something strange with my Enterprise Manager (SQL 2000). When in my
> > local server i cannot see my databases. The list is empty. If I go to Query
> > Analyzer on the same box, I can see all of them. Also in EM, under the
> > Management folder there is nothing to view. Any ideas what has happened?
> >
> > Thanks in advance.|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in my
> local server i cannot see my databases. The list is empty. If I go to Query
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:
> doug wrote:
> > I have something strange with my Enterprise Manager (SQL 2000). When in my
> > local server i cannot see my databases. The list is empty. If I go to Query
> > Analyzer on the same box, I can see all of them. Also in EM, under the
> > Management folder there is nothing to view. Any ideas what has happened?
> >
> > Thanks in advance.
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and the
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:
> doug wrote:
> > Yes, I do have 2 databases 'offline'.
> >
> > I do not get the arithmetic overflow error if I just select the dbid and the
> > name.
> >
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr SQL 2000 doesn't list databases

I have something strange with my Enterprise Manager (SQL 2000). When in my
local server i cannot see my databases. The list is empty. If I go to Quer
y
Analyzer on the same box, I can see all of them. Also in EM, under the
Management folder there is nothing to view. Any ideas what has happened?
Thanks in advance.Does the registration in Enterprise manager use the same login as the one yo
u
use in Query Analyzer? Does the user you login with to create your
registration have access to all of the tables and the management folder?
--
Russel Loski, MCSD.Net
"doug" wrote:

> I have something strange with my Enterprise Manager (SQL 2000). When in m
y
> local server i cannot see my databases. The list is empty. If I go to Qu
ery
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.|||Yes.
When I try to create a new database through EM I get an arithmetic overflow
error. Do I have something corrupt in the master database? If I try a
'select * from sysdatabases' in the master database I get a row count and an
arithmetic overflow errror. See below.
"(21 row(s) affected)
Server: Msg 220, Level 16, State 1, Line 1
Arithmetic overflow error for data type smallint, value = 32789."
This is on a test SQL box, and I am not sure when the problem started. If I
cannot restore the master db from backup is there any way to repair it?
Thanks.
"RLoski" wrote:
[vbcol=seagreen]
> Does the registration in Enterprise manager use the same login as the one
you
> use in Query Analyzer? Does the user you login with to create your
> registration have access to all of the tables and the management folder?
> --
> Russel Loski, MCSD.Net
>
> "doug" wrote:
>|||doug wrote:
> I have something strange with my Enterprise Manager (SQL 2000). When in m
y
> local server i cannot see my databases. The list is empty. If I go to Qu
ery
> Analyzer on the same box, I can see all of them. Also in EM, under the
> Management folder there is nothing to view. Any ideas what has happened?
> Thanks in advance.
Do you have any databases currently "offline"? Do you also get the
error if you run:
SELECT * FROM master.dbo.sysdatabases
but not if you do:
SELECT dbid, name FROM master.dbo.sysdatabases
?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Yes, I do have 2 databases 'offline'.
I do not get the arithmetic overflow error if I just select the dbid and the
name.
"Tracy McKibben" wrote:

> doug wrote:
> Do you have any databases currently "offline"? Do you also get the
> error if you run:
> SELECT * FROM master.dbo.sysdatabases
> but not if you do:
> SELECT dbid, name FROM master.dbo.sysdatabases
> ?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>|||doug wrote:
> Yes, I do have 2 databases 'offline'.
> I do not get the arithmetic overflow error if I just select the dbid and t
he
> name.
>
Bring those databases online, then see if your problem goes away. Take
them offline again, and see if it continues to work after that. I
recall some obscure issue where the "version" column in the master
database gets corrupted when a database is taken offline. I don't
recall if this was fixed in a service pack or not.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Bringing the 2 'online' and then taking 'offline' has solved my problem.
Thank you for your help.
"Tracy McKibben" wrote:

> doug wrote:
> Bring those databases online, then see if your problem goes away. Take
> them offline again, and see if it continues to work after that. I
> recall some obscure issue where the "version" column in the master
> database gets corrupted when a database is taken offline. I don't
> recall if this was fixed in a service pack or not.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Enterprise Mgr Error

Good Day
SQL 2000 - just started recieving the following when loading Enterprise
Manager directly on the server console (from a workstation is fine)
'Connection to application failed. Ensure that no program modules have
been deleted'
I tried re-installing both OS & SQL service packs to see if a DLL or
something was missing - but am still receiving the error - any ideas ?
Thanks!Hi
Can you open MMC and other add-ins without getting this error?
Can you open SQL Server Enterprise Manager.msc from within MMC?
John
"ERoss" wrote:
> Good Day
> SQL 2000 - just started recieving the following when loading Enterprise
> Manager directly on the server console (from a workstation is fine)
> 'Connection to application failed. Ensure that no program modules have
> been deleted'
> I tried re-installing both OS & SQL service packs to see if a DLL or
> something was missing - but am still receiving the error - any ideas ?
> Thanks!
>|||In article <818FA874-C913-4C1C-93FB-3B62B00E0770@.microsoft.com>,
jbellnewsposts@.hotmail.com says...
> Hi
> Can you open MMC and other add-ins without getting this error?
> Can you open SQL Server Enterprise Manager.msc from within MMC?
> John
> "ERoss" wrote:
> > Good Day
> >
> > SQL 2000 - just started recieving the following when loading Enterprise
> > Manager directly on the server console (from a workstation is fine)
> >
> > 'Connection to application failed. Ensure that no program modules have
> > been deleted'
> >
> > I tried re-installing both OS & SQL service packs to see if a DLL or
> > something was missing - but am still receiving the error - any ideas ?
> >
> > Thanks!
> >
Good Point & thanks -
MMC.exe runs OK - I added various snapins - all worked successfully -
tried to add enterprise manager.msc - it blows withthe same error
Thanks|||Hi
You don't say what service pack you are on!
But you could try renaming the MMC and loading the renamed file (which seems
to sometimes work!), renaming the MMC file and installing a service pack, or
copy the MMC from another machine that is on the same fix level.
John
"ERoss" wrote:
> In article <818FA874-C913-4C1C-93FB-3B62B00E0770@.microsoft.com>,
> jbellnewsposts@.hotmail.com says...
> > Hi
> >
> > Can you open MMC and other add-ins without getting this error?
> >
> > Can you open SQL Server Enterprise Manager.msc from within MMC?
> >
> > John
> >
> > "ERoss" wrote:
> >
> > > Good Day
> > >
> > > SQL 2000 - just started recieving the following when loading Enterprise
> > > Manager directly on the server console (from a workstation is fine)
> > >
> > > 'Connection to application failed. Ensure that no program modules have
> > > been deleted'
> > >
> > > I tried re-installing both OS & SQL service packs to see if a DLL or
> > > something was missing - but am still receiving the error - any ideas ?
> > >
> > > Thanks!
> > >
> Good Point & thanks -
> MMC.exe runs OK - I added various snapins - all worked successfully -
> tried to add enterprise manager.msc - it blows withthe same error
> Thanks
>|||In article <CD313813-AB93-40D6-90A4-8BF3DB4682F5@.microsoft.com>,
jbellnewsposts@.hotmail.com says...
SQL is SP4 -
I had re-applied that service pack -
But I will retry after renaming the enterprise manager.msc file
Thanks!
> Hi
> You don't say what service pack you are on!
> But you could try renaming the MMC and loading the renamed file (which seems
> to sometimes work!), renaming the MMC file and installing a service pack, or
> copy the MMC from another machine that is on the same fix level.
> John
>

Enterprise Mgr as an end-user data manipulation tool

As DBAs we typically restrict the use of Enterprise Manager and other DBA
Admin type utilities from end-users. Even with a user's SQL server
permissions being appropriately defined and restricted, to limit their
abilities within Enterprise Manager, I typically do not allow end users to
use Enterprise Manager, for the same reason that an Exchange administrator
doesn't allow end-users to run Exchange Administrator to manage their
mailbox. It's an administration utility and is not intended as a data
manipulation interface.
I am faced with a unique situation where a 'power user' insists on wanting
to use SQL Enterprise Manager to access a particular database to which he has
read/write permissions to the production data, as he wants to browse and
modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on a
table and selecting the 'Open, Return All Rows', etc. Due to political
reasons beyond my control, it appears that I will be 'told' to let him use
Enterprise Manager by upper management, so that the user can manage the data
via SQL EM.
Outside of the technical reasons why an end-user should not be using SQL
Enterprise Manager as the GUI to manage data within a database, even with
proper security, does anyone know of official audit guidelines that would
raise a 'red flag' if an audit determined that an end-user(s) were managing
data via SQL Enterprise Manager?
Thanks
D
Apart from read/write to certain tables in the DB, what other rights does
this user have within the server and database? The fact that an end-user
can (knowingly or not), if their rights aren't severely restricted, drop a
table, access and modify security/login info, modify/overwrite/delete
backups, add/remove indexes, etc. would make me wary.
Maybe you can suggest to them that this guy use Access as the front end, and
Link the tables he needs into Access so he can edit to his heart's content
without getting anywhere near EM?
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:D8E94FA5-3F83-4B63-9EFA-1A65F14C1857@.microsoft.com...
> As DBAs we typically restrict the use of Enterprise Manager and other DBA
> Admin type utilities from end-users. Even with a user's SQL server
> permissions being appropriately defined and restricted, to limit their
> abilities within Enterprise Manager, I typically do not allow end users to
> use Enterprise Manager, for the same reason that an Exchange administrator
> doesn't allow end-users to run Exchange Administrator to manage their
> mailbox. It's an administration utility and is not intended as a data
> manipulation interface.
> I am faced with a unique situation where a 'power user' insists on wanting
> to use SQL Enterprise Manager to access a particular database to which he
> has
> read/write permissions to the production data, as he wants to browse and
> modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on
> a
> table and selecting the 'Open, Return All Rows', etc. Due to political
> reasons beyond my control, it appears that I will be 'told' to let him use
> Enterprise Manager by upper management, so that the user can manage the
> data
> via SQL EM.
> Outside of the technical reasons why an end-user should not be using SQL
> Enterprise Manager as the GUI to manage data within a database, even with
> proper security, does anyone know of official audit guidelines that would
> raise a 'red flag' if an audit determined that an end-user(s) were
> managing
> data via SQL Enterprise Manager?
> Thanks
> D

Enterprise Mgr as an end-user data manipulation tool

As DBAs we typically restrict the use of Enterprise Manager and other DBA
Admin type utilities from end-users. Even with a user's SQL server
permissions being appropriately defined and restricted, to limit their
abilities within Enterprise Manager, I typically do not allow end users to
use Enterprise Manager, for the same reason that an Exchange administrator
doesn't allow end-users to run Exchange Administrator to manage their
mailbox. It's an administration utility and is not intended as a data
manipulation interface.
I am faced with a unique situation where a 'power user' insists on wanting
to use SQL Enterprise Manager to access a particular database to which he ha
s
read/write permissions to the production data, as he wants to browse and
modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on a
table and selecting the 'Open, Return All Rows', etc. Due to political
reasons beyond my control, it appears that I will be 'told' to let him use
Enterprise Manager by upper management, so that the user can manage the data
via SQL EM.
Outside of the technical reasons why an end-user should not be using SQL
Enterprise Manager as the GUI to manage data within a database, even with
proper security, does anyone know of official audit guidelines that would
raise a 'red flag' if an audit determined that an end-user(s) were managing
data via SQL Enterprise Manager?
Thanks
DApart from read/write to certain tables in the DB, what other rights does
this user have within the server and database? The fact that an end-user
can (knowingly or not), if their rights aren't severely restricted, drop a
table, access and modify security/login info, modify/overwrite/delete
backups, add/remove indexes, etc. would make me wary.
Maybe you can suggest to them that this guy use Access as the front end, and
Link the tables he needs into Access so he can edit to his heart's content
without getting anywhere near EM?
"DBADave" <DBADave@.discussions.microsoft.com> wrote in message
news:D8E94FA5-3F83-4B63-9EFA-1A65F14C1857@.microsoft.com...
> As DBAs we typically restrict the use of Enterprise Manager and other DBA
> Admin type utilities from end-users. Even with a user's SQL server
> permissions being appropriately defined and restricted, to limit their
> abilities within Enterprise Manager, I typically do not allow end users to
> use Enterprise Manager, for the same reason that an Exchange administrator
> doesn't allow end-users to run Exchange Administrator to manage their
> mailbox. It's an administration utility and is not intended as a data
> manipulation interface.
> I am faced with a unique situation where a 'power user' insists on wanting
> to use SQL Enterprise Manager to access a particular database to which he
> has
> read/write permissions to the production data, as he wants to browse and
> modify data ad-hoc within the Enterprise Manager GUI (by right-clicking on
> a
> table and selecting the 'Open, Return All Rows', etc. Due to political
> reasons beyond my control, it appears that I will be 'told' to let him use
> Enterprise Manager by upper management, so that the user can manage the
> data
> via SQL EM.
> Outside of the technical reasons why an end-user should not be using SQL
> Enterprise Manager as the GUI to manage data within a database, even with
> proper security, does anyone know of official audit guidelines that would
> raise a 'red flag' if an audit determined that an end-user(s) were
> managing
> data via SQL Enterprise Manager?
> Thanks
> D

Enterprise Mgr - Register server with multiple logins?

How can I register the same SQL Server more than once in
Enterprise Manager, using multiple logins?
"A server with this name already exists."
I'd expect this to be a FAQ, but twenty minutes of
googling it has turned up precious little by way of
remedies. This should be a pretty garden-variety
situation: I need to access multiple databases on a single
SQL Server, some of which require a different login from
others. I've added a new server group for the additional
instance/connection/registration, but every attempt to
register the server returns "A server with this name
already exists."
This is a simple thing to accomplish in Query Analyzer,
but I need some of Enterprise Manager's functionality.
Obviously, I could keep deleting and re-registering every
time I need to change context, but that's a pretty tedious
kludge, or I wouldn't be writing this post, you know?
Anyways, is there a hack?
Thanks much.
Create an alias to the SQL Server within the Client Network Utility (within
the SQL Server program group) and then register that alias within Enterprise
Manager.
Keith
"Paul Smith" <paul.smith@.zurichna.com> wrote in message
news:18f301c4a648$0f3dc8e0$a601280a@.phx.gbl...
> How can I register the same SQL Server more than once in
> Enterprise Manager, using multiple logins?
> "A server with this name already exists."
> I'd expect this to be a FAQ, but twenty minutes of
> googling it has turned up precious little by way of
> remedies. This should be a pretty garden-variety
> situation: I need to access multiple databases on a single
> SQL Server, some of which require a different login from
> others. I've added a new server group for the additional
> instance/connection/registration, but every attempt to
> register the server returns "A server with this name
> already exists."
> This is a simple thing to accomplish in Query Analyzer,
> but I need some of Enterprise Manager's functionality.
> Obviously, I could keep deleting and re-registering every
> time I need to change context, but that's a pretty tedious
> kludge, or I wouldn't be writing this post, you know?
> Anyways, is there a hack?
> Thanks much.
>
|||That hit the spot - forgot all about the Client Utility, but what a simple,
quick and straightforward solution (...which is probably why I didn't arrive
at it on my own! heh.)
Thanks.
"Keith Kratochvil" wrote:

> Create an alias to the SQL Server within the Client Network Utility (within
> the SQL Server program group) and then register that alias within Enterprise
> Manager.
> --
> Keith
>
> "Paul Smith" <paul.smith@.zurichna.com> wrote in message
> news:18f301c4a648$0f3dc8e0$a601280a@.phx.gbl...
>

Enterprise Manger Error

I am getting an error:
MMC cannot open the file C:\program files\Miscorosft SQL
Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
This may be because the file does not exist, is not an MMC console, or was
creted by a later version of MMC. This may also by because you do not have
sufficient access rights to the file.
I've tried uninstalling/reinstalling reapplying SP3a etc. with no luck.
I did find that renaming the file to anything else will allow it to work.
Which makes for an easy enough work around but was wondering if anybody knew
what is going on?
TIA
Hi
Have you tried running MMC and opening the file from there?
Check the file permissions.
If you have EM on another machine you may want to try copying the file.
Alternatively may want to extract the MSC file from the original CD.
John
"Ken Rinaman" <go@.away.net> wrote in message
news:%23sPCyhiUEHA.2972@.TK2MSFTNGP12.phx.gbl...
> I am getting an error:
> MMC cannot open the file C:\program files\Miscorosft SQL
> Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC.
> This may be because the file does not exist, is not an MMC console, or was
> creted by a later version of MMC. This may also by because you do not have
> sufficient access rights to the file.
> I've tried uninstalling/reinstalling reapplying SP3a etc. with no luck.
> I did find that renaming the file to anything else will allow it to work.
> Which makes for an easy enough work around but was wondering if anybody
knew
> what is going on?
> TIA
>
|||
> Have you tried running MMC and opening the file from there?
Yes, same error.

> Check the file permissions.
I have the ability to rename, delete, etc.

> If you have EM on another machine you may want to try copying the file.
> Alternatively may want to extract the MSC file from the original CD.
I did pull the file from the CD which is how I discovered changing the name
fixes the problem. On the CD the file is called SQLEM.msc if I copy that
file to my computer it runs fine. However if I rename it to SQL Server
Enterprise Manger.msc it no longer runs.
sql

Enterprise Manger Crash Creating user

Please can you help with this?
I created a new users for the first time in SQL Server 2000. While doing
that, Enterprise Manager crashed...and:
1. If I try to add the user again, I get an error because the User already
exists...yet I cannot see it on the console.
2. The user name does not show under Users (or Roles)
Any idea what I need to do to fix it - or what I might be doing wrong?
Is there a problem with Enterprise manager, how can it be fixed? (Looks to
me like it fails while waiting for a response from NT...)Patrik
Open Query Analyzer and use
sp_adduser ,sp_dropuser system stored procedures
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:899B491A-819F-4435-9CF5-6E5EB47BB13C@.microsoft.com...
> Please can you help with this?
> I created a new users for the first time in SQL Server 2000. While
> doing
> that, Enterprise Manager crashed...and:
> 1. If I try to add the user again, I get an error because the User already
> exists...yet I cannot see it on the console.
> 2. The user name does not show under Users (or Roles)
> Any idea what I need to do to fix it - or what I might be doing wrong?
> Is there a problem with Enterprise manager, how can it be fixed? (Looks
> to
> me like it fails while waiting for a response from NT...)
>|||Thx.
Q. Does a SQL Server User Id have be created on the NT Server on which SQL
Server resides? Or can the NT user id be on another server?
"Uri Dimant" wrote:

> Patrik
> Open Query Analyzer and use
> sp_adduser ,sp_dropuser system stored procedures
>
>
>
> "Patrick" <Patrick@.discussions.microsoft.com> wrote in message
> news:899B491A-819F-4435-9CF5-6E5EB47BB13C@.microsoft.com...
>
>|||Patrick
Users and Logins are two different things
1)Logins are created to allow the person access to SQL Server .
2) Users are created to grant/allow access to the database/s located on the
server
http://vyaskn.tripod.com/sql_server...t_practices.htm --sec
urity
best practices
"Patrick" <Patrick@.discussions.microsoft.com> wrote in message
news:21715426-1674-48EE-A782-0709C183E456@.microsoft.com...[vbcol=seagreen]
> Thx.
> Q. Does a SQL Server User Id have be created on the NT Server on which
> SQL
> Server resides? Or can the NT user id be on another server?
> "Uri Dimant" wrote:
>

Enterprise Manger CLOSES!

Hello everyone,
I have SQL server 2000 installed on Windows 2003 std
edition. The first time I opened E manager I was able to
right click on any database and go to properties to set
the location of transaction logs and so forth! The second
time I went into it I tried the same thing and now E
manager shuts down. It does the same thing to all the
databases. Does anyone know why this is happening. I have
sp3 installed...
GiacomoI don't know what happening but my be able to supply
information for you to find out.
The 2003 should contain logs of programs / services that
have started an stopped including SQL Server, so have a
chat to your 2003 Administrator to see if you can have a
look at them.
SQL Server also keeps a log, under the server - Managment -
SQL Server Logs have a look at that and see if it helps.
Run a trace and see what the server was doing before the
shut down.
J
>--Original Message--
>Hello everyone,
>I have SQL server 2000 installed on Windows 2003 std
>edition. The first time I opened E manager I was able to
>right click on any database and go to properties to set
>the location of transaction logs and so forth! The second
>time I went into it I tried the same thing and now E
>manager shuts down. It does the same thing to all the
>databases. Does anyone know why this is happening. I have
>sp3 installed...
>Giacomo
>.
>

Enterprise Mananger Info not sticking

My PC is running Windows XP.
When I registered SQL Server in the Enterprise Manager,
the information of the registered server is gone (No
items) after I log off.
I have found some registry entries under
HKCU\Software\Microsoft\Microsoft SQL Server\80
\Tools\SQLEW\Registered Servers X\SQL Server Group
that seem to deal with Enterprise Manager.
Any ideas ?
Johnny
Hi,
It seems you do not have previlages in writing into the registry. Try
registering with a Admin OS user. If it is able to do then , ask your
system administrater to give prev (Write) to the below registry key .
HKLM\Software\microsoft\MSSQLSERVER (Root key itself)
Thanks
Hari
MCDBA
"Johnny" <jtao@.ssc.nsw.gov.au> wrote in message
news:f81601c43e31$9ca40110$a101280a@.phx.gbl...
> My PC is running Windows XP.
> When I registered SQL Server in the Enterprise Manager,
> the information of the registered server is gone (No
> items) after I log off.
> I have found some registry entries under
> HKCU\Software\Microsoft\Microsoft SQL Server\80
> \Tools\SQLEW\Registered Servers X\SQL Server Group
> that seem to deal with Enterprise Manager.
> Any ideas ?
> Johnny

Enterprise Mananger Info not sticking

My PC is running Windows XP.
When I registered SQL Server in the Enterprise Manager,
the information of the registered server is gone (No
items) after I log off.
I have found some registry entries under
HKCU\Software\Microsoft\Microsoft SQL Server\80
\Tools\SQLEW\Registered Servers X\SQL Server Group
that seem to deal with Enterprise Manager.
Any ideas ?
JohnnyHi,
It seems you do not have previlages in writing into the registry. Try
registering with a Admin OS user. If it is able to do then , ask your
system administrater to give prev (Write) to the below registry key .
HKLM\Software\microsoft\MSSQLSERVER (Root key itself)
Thanks
Hari
MCDBA
"Johnny" <jtao@.ssc.nsw.gov.au> wrote in message
news:f81601c43e31$9ca40110$a101280a@.phx.gbl...
> My PC is running Windows XP.
> When I registered SQL Server in the Enterprise Manager,
> the information of the registered server is gone (No
> items) after I log off.
> I have found some registry entries under
> HKCU\Software\Microsoft\Microsoft SQL Server\80
> \Tools\SQLEW\Registered Servers X\SQL Server Group
> that seem to deal with Enterprise Manager.
> Any ideas ?
> Johnnysql

Enterprise Mananger Info not sticking

My PC is running Windows XP.
When I registered SQL Server in the Enterprise Manager,
the information of the registered server is gone (No
items) after I log off.
I have found some registry entries under
HKCU\Software\Microsoft\Microsoft SQL Server\80
\Tools\SQLEW\Registered Servers X\SQL Server Group
that seem to deal with Enterprise Manager.
Any ideas ?
JohnnyHi,
It seems you do not have previlages in writing into the registry. Try
registering with a Admin OS user. If it is able to do then , ask your
system administrater to give prev (Write) to the below registry key .
HKLM\Software\microsoft\MSSQLSERVER (Root key itself)
Thanks
Hari
MCDBA
"Johnny" <jtao@.ssc.nsw.gov.au> wrote in message
news:f81601c43e31$9ca40110$a101280a@.phx.gbl...
> My PC is running Windows XP.
> When I registered SQL Server in the Enterprise Manager,
> the information of the registered server is gone (No
> items) after I log off.
> I have found some registry entries under
> HKCU\Software\Microsoft\Microsoft SQL Server\80
> \Tools\SQLEW\Registered Servers X\SQL Server Group
> that seem to deal with Enterprise Manager.
> Any ideas ?
> Johnny

Enterprise Manager's Bug?

Hello, I'm in trouble to solve my network problem.
My network is full of NetBIOS packets, and bad traffic.
I checked packets and found that this problem appears when Enterprise
Manager is in use.
=== detail ===
* 192.168.***.*** is local machine (with Enterprise Manager)
* 192.168.+++.+++ is SQL Server 2000 service pack 3a
192.168.***.*** -> 192.168.+++.+++ [SMB] NT Create AndX Request, Path:
\svcctl
192.168.+++.+++ -> 192.168.***.*** [SMB] NT Create AndX Response, FID:
0x804b
192.168.***.*** -> 192.168.+++.+++ [DCERPC] Bind: call_id: 1 UUID: SVCC
TL
192.168.+++.+++ -> 192.168.***.*** [DCERPC] Bind_ack: call_id: 1 accept
max_xmit: 4280 max_recv: 4280
192.168.***.*** -> 192.168.+++.+++ [SVCCTL] OpenSCManager request,
\\192.172.+++.+++, ServiceActive
192.168.+++.+++ -> 192.168.***.*** [SVCCTL] OpenSCManager reply
192.168.***.*** -> 192.168.+++.+++ [SVCCTL] Open service A request
192.168.+++.+++ -> 192.168.***.*** [SVCCTL] Open service A reply
192.168.***.*** -> 192.168.+++.+++ [SVCCTL] unknown?! request
192.168.+++.+++ -> 192.168.***.*** [SVCCTL] unknown?! reply
... close connection packets ...
*** This occurs 1 - 2 times in 1 second! ***
=== detail end ===
OpenSCManager'
I think it is Win32 API to control windows service.
Why Enterprise Manager requests "start unknown service"?
Please tell me how to solve this problem, thank you.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Pyob from Japan.
Thank you for reading my long long sentence. :-)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Try turning off the polling of the service. In Enterprise
Manager, go to the menu to Tools, select Options. On the
General Tab, remove the check for Server State Polling.
-Sue
On Wed, 16 Jun 2004 18:57:49 +0900, "Pyob" <pyob@.mac.com>
wrote:

>Hello, I'm in trouble to solve my network problem.
>My network is full of NetBIOS packets, and bad traffic.
>I checked packets and found that this problem appears when Enterprise
>Manager is in use.
>=== detail ===
>* 192.168.***.*** is local machine (with Enterprise Manager)
>* 192.168.+++.+++ is SQL Server 2000 service pack 3a
>192.168.***.*** -> 192.168.+++.+++ [SMB] NT Create AndX Request, Path:
>\svcctl
>192.168.+++.+++ -> 192.168.***.*** [SMB] NT Create AndX Response, FID:
>0x804b
>192.168.***.*** -> 192.168.+++.+++ [DCERPC] Bind: call_id: 1 UUID: SVC
CTL
>192.168.+++.+++ -> 192.168.***.*** [DCERPC] Bind_ack: call_id: 1 accep
t
>max_xmit: 4280 max_recv: 4280
>192.168.***.*** -> 192.168.+++.+++ [SVCCTL] OpenSCManager request,
>\\192.172.+++.+++, ServiceActive
>192.168.+++.+++ -> 192.168.***.*** [SVCCTL] OpenSCManager reply
>192.168.***.*** -> 192.168.+++.+++ [SVCCTL] Open service A request
>192.168.+++.+++ -> 192.168.***.*** [SVCCTL] Open service A reply
>192.168.***.*** -> 192.168.+++.+++ [SVCCTL] unknown?! request
>192.168.+++.+++ -> 192.168.***.*** [SVCCTL] unknown?! reply
>... close connection packets ...
>*** This occurs 1 - 2 times in 1 second! ***
>=== detail end ===
>OpenSCManager'
>I think it is Win32 API to control windows service.
>Why Enterprise Manager requests "start unknown service"?
>Please tell me how to solve this problem, thank you.
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>Pyob from Japan.
>Thank you for reading my long long sentence. :-)
>-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-|||Thanks for your help, my network is going well!
But shortage of network resource is the main problem, I think.
Thank you very much!
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Pyob from Japan.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:gif0d0h376sm7260q9ch74ahin18v2s7sp@.
4ax.com...
> Try turning off the polling of the service. In Enterprise
> Manager, go to the menu to Tools, select Options. On the
> General Tab, remove the check for Server State Polling.
> -Sue
> On Wed, 16 Jun 2004 18:57:49 +0900, "Pyob" <pyob@.mac.com>
> wrote:
>
SVCCTL[vbcol=seagreen]
>

Enterprise Managers "current activity":How in SQL?

Manfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "curre
nt
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlter Persson
Database Administrator / System AdministratorAlso, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator|||Hi All !
Can someone show, how to obtain that, what Enterprise manager calls "current
activity", in SQL? I really would like to see the same output, not that,
what sp_who, sp_lock etc give.
I just have currently not the right knowledge to make all the neccessary
relationships from sp_who/sp_lock/sysprocesses etc
Any help would be great.
Thanks so far and
best regards,
Manfred Braun|||Manfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "curre
nt
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Also, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator

Enterprise Managers "current activity":How in SQL?

Hi All !
Can someone show, how to obtain that, what Enterprise manager calls "current
activity", in SQL? I really would like to see the same output, not that,
what sp_who, sp_lock etc give.
I just have currently not the right knowledge to make all the neccessary
relationships from sp_who/sp_lock/sysprocesses etc
Any help would be great.
Thanks so far and
best regards,
Manfred BraunManfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "current
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlüter Persson
Database Administrator / System Administrator|||Also, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
>> Hi All !
>> Can someone show, how to obtain that, what Enterprise manager calls
>> "current activity", in SQL? I really would like to see the same output,
>> not that, what sp_who, sp_lock etc give.
>> I just have currently not the right knowledge to make all the neccessary
>> relationships from sp_who/sp_lock/sysprocesses etc
>> Any help would be great.
>> Thanks so far and
>> best regards,
>> Manfred Braun
>>
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlüter Persson
> Database Administrator / System Administrator

Enterprise Manager-like application

I wanted to build my own custom version of Enterprise Manager using vb.net.
Where can I get the icons/pictures that enterprise manager uses (eg the
icons used in the treeviews for database, table, user, stored procedure,
user-defined function etc)I wouldn't think that would be legal.
But you can always make your own.
<arch> wrote in message news:42f7ef77@.funnel.arach.net.au...
>I wanted to build my own custom version of Enterprise Manager using vb.net.
>Where can I get the icons/pictures that enterprise manager uses (eg the
>icons used in the treeviews for database, table, user, stored procedure,
>user-defined function etc)
>|||Shane,

>I wouldn't think that would be legal.
AFAIK is it in most countries illegal.
(Before somebody ask it, I don't know any country where it is legal).
Just my 2 eurocents
Cor|||Unless arch is planning on redistributing his custom app, I think that using
the icons on his own machine (very easy to create GIFs using a screen shot)
would come under fair use...
"Shane Story" <nospam@.nothanks.com> wrote in message
news:ehewDsHnFHA.1948@.TK2MSFTNGP12.phx.gbl...
>I wouldn't think that would be legal.
> But you can always make your own.
>
> <arch> wrote in message news:42f7ef77@.funnel.arach.net.au...
>|||You can go to download.com and find several shareware / freeware
applications for extracting icons from .exe and .dll files. Also worth
mentioning is that the sample applications that come with SQL Server include
a VB 6.0 project that uses DMO to create a simplistic Enterprise Manager
style application.
<arch> wrote in message news:42f7ef77@.funnel.arach.net.au...
>I wanted to build my own custom version of Enterprise Manager using vb.net.
>Where can I get the icons/pictures that enterprise manager uses (eg the
>icons used in the treeviews for database, table, user, stored procedure,
>user-defined function etc)
>|||Have you looked at the available alternatives?
http://www.aspfaq.com/show.asp?id=2442
At least one (myLittleAdmin) provides an API for further
customisations.
David Portas
SQL Server MVP
--sql

Enterprise Manager?

If I understand correctly, Enterprise manager has been replaced with SQL Ser
ver 2005
Express?
Can I use SQL Server 2005 Express from my desktop to connect to an SQL 2000
database on
the internet?
Thanks,
VicAm Fri, 21 Jul 2006 23:14:27 -0400 schrieb Victor:

> If I understand correctly, Enterprise manager has been replaced with SQL S
erver 2005
> Express?
> Can I use SQL Server 2005 Express from my desktop to connect to an SQL 200
0 database on
> the internet?
> Thanks,
> Vic
You can use the new Server Management Studio Express to manage SQL2005 and
SQL2000, no problem. You can even use the old QueryAnalizer from SQL2000 to
work with SQL2005. Only EM is not compatible.
And if you connect over internet, then the only problems may be when
routers or firewalls are not right configured. I support all my clients, no
matter if MSDE, SQLExpress or any other server edition, over internet.
bye, Helmut|||"Helmut Woess" wrote...
> Am Fri, 21 Jul 2006 23:14:27 -0400 schrieb Victor:
>
on[vbcol=seagreen]
> You can use the new Server Management Studio Express to manage SQL2005 and
> SQL2000, no problem. You can even use the old QueryAnalizer from SQL2000 t
o
> work with SQL2005. Only EM is not compatible.
> And if you connect over internet, then the only problems may be when
> routers or firewalls are not right configured. I support all my clients, n
o
> matter if MSDE, SQLExpress or any other server edition, over internet.
> bye, Helmut
Thanks, Helmut!
From here:
http://msdn.microsoft.com/vstudio/express/sql/download/
I downloaded "SQL Server 2005 Express Edition with Advanced Services SP1" be
cause it
supports full-text search (which my SQL 2000 db uses). Is that all I need?
How does my firewall need to be configured? I assume that if I access my db
over the
Internet, Server Management Studio Express will require a particular port to
access my
db over the Internet.
Also, can Server Management Studio Express be used to access a remote mysql
database?
Thanks so much!!!
Vic

Enterprise Manager?

I have a new windows 2003 SBS server installation and an
application that requires SQL server. How do I get to the
Enterprise Manager to configure SQL?Is SQL Server installed? It should be in Programs > Micorsoft SQL Server >
Enterprise Manager
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Vince" <anonymous@.discussions.microsoft.com> wrote in message
news:03aa01c3b849$9258ea90$a101280a@.phx.gbl...
> I have a new windows 2003 SBS server installation and an
> application that requires SQL server. How do I get to the
> Enterprise Manager to configure SQL?|||NO SQL server is not installed. How is it installed?
>--Original Message--
>Is SQL Server installed? It should be in Programs >
Micorsoft SQL Server >
>Enterprise Manager
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>"Vince" <anonymous@.discussions.microsoft.com> wrote in
message
>news:03aa01c3b849$9258ea90$a101280a@.phx.gbl...
>> I have a new windows 2003 SBS server installation and an
>> application that requires SQL server. How do I get to
the
>> Enterprise Manager to configure SQL?
>
>.
>|||> NO SQL server is not installed. How is it installed?
setup.exe, from the installation CD?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/