Enterprise manager running a BAT file

I wish to use Enterprise manager to run a batch file that the program
displays a window, but there is no user input for it. If I run the command
job it runs fine, If I use E.M to run it the job starts and looks like it
hangs and does nothing. Any ideas?
Jay
The GUI that is called runs in the context of a service. It will not be
visible on the screen. Re-write the application so that it is without a GUI
and things should work better.
Keith
"Jay" <Jay@.discussions.microsoft.com> wrote in message
news:47313383-F298-4B62-9597-CADE32CDCBE3@.microsoft.com...
>I wish to use Enterprise manager to run a batch file that the program
> displays a window, but there is no user input for it. If I run the
> command
> job it runs fine, If I use E.M to run it the job starts and looks like it
> hangs and does nothing. Any ideas?
> Jay

Enterprise Manager Problem

Hi,

I have the following problem:

When I start Enterprise Manager and open a window (editing a table, or showing data in a table) it works correctly. But, when I open other windows after that (editing a table, or showing data in a table), the window opens but I get always a white page. The data and the grid are not shown. Only the data of the selected cell is shown.

I uninstalled it and installed SQL Server again, the problem still remains.

What can I do?

I use:
Windows XP Proffessional
SQL Server 2000 Developer Edition + SP3a

KaaNDid you check the event viewer on your system to see if it recorded any errors?

Which version of SQL Server are you running? Do you have all service packs installed?

You might also try unregistering the SQL Server and re-registering.

(Sorry, grasping at straws)

Terri

Enterprise Manager for DTS doesn't work

When I try to open a package in Server/Data transformation
Services/Local packages MMC opens a new window and displays
a warning with the following text: "The specified module
could not be found" The caption of the box says: "DTS
Designer error"
Anybody a solution?
Server: W2K, sp 4
Client: XPPro, sp1
SQL server 2000
Thanks in advance,
Tjalling
Can you re-apply the latest SP please, seems like one of the files is not
registered/config'd correctly.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tjalling" <t.ament@.go-tan.nl> wrote in message
news:347c01c47ebe$644f9680$a401280a@.phx.gbl...
> When I try to open a package in Server/Data transformation
> Services/Local packages MMC opens a new window and displays
> a warning with the following text: "The specified module
> could not be found" The caption of the box says: "DTS
> Designer error"
> Anybody a solution?
> Server: W2K, sp 4
> Client: XPPro, sp1
> SQL server 2000
> Thanks in advance,
> Tjalling
|||

Quote:

Originally posted by Euan Garden[MS]
Can you re-apply the latest SP please, seems like one of the files is not
registered/config'd correctly.
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tjalling" <t.ament@.go-tan.nl> wrote in message
news:347c01c47ebe$644f9680$a401280a@.phx.gbl...
> When I try to open a package in Server/Data transformation
> Services/Local packages MMC opens a new window and displays
> a warning with the following text: "The specified module
> could not be found" The caption of the box says: "DTS
> Designer error"
> Anybody a solution?
> Server: W2K, sp 4
> Client: XPPro, sp1
> SQL server 2000
> Thanks in advance,
> Tjalling

I had the same error message.
I looked at the the sqlsp installation log "C:\WINDOWS\sqlsp.log" and found what seemed to be a warning about Microsoft Data Access Components (MDAC) and installed MDAC 2.8.
Log entry:
C:\Download\mdac26Sp2\sql2ksp3\x86\Other\sqlredis. exe /q:a /C:"setupre.exe MDACQFE=0 WARN=1 -s -SMS" ExitCode: 0
After installing it worked.
SQL Server 2000
XPPro, sp1
Nicole

Enterprise Manager 'Change Query Type' Window

I'm running a SQL Server Enterprise Manager. When I click on 'Change Query
Type', a window pops up on the bottom right hand corner of my screen with the
options: 'Select, Insert from, Insert into, Update, etc.'. The window used
to appear right under the bottom, but now every time I click it, the window
shows up on the bottom right of the screen. Does anyone know how to change
this? I want it to appear closer to the button.
Thanks,
On Fri, 17 Mar 2006 05:16:31 -0800, PML wrote:

>I'm running a SQL Server Enterprise Manager. When I click on 'Change Query
>Type', a window pops up on the bottom right hand corner of my screen with the
>options: 'Select, Insert from, Insert into, Update, etc.'. The window used
>to appear right under the bottom, but now every time I click it, the window
>shows up on the bottom right of the screen. Does anyone know how to change
>this? I want it to appear closer to the button.
Hi PML,
Don't use Enterprise Manager to design your queries. This part of EM has
lots of bugs and other "funny" issues.
http://www.aspfaq.com/show.asp?id=2455
Hugo Kornelis, SQL Server MVP

Enterprise Manager "New Window from Here" Hack or Whatever

Sorry if this is a FAQ. Googling way joyless. ;-)
I have an MS SQL 2000 database on a web host. Since there are about 600 dbs
on the host's server it takes about 20 minutes to expand the databases on
the server in SQL Server Enterprise Manager. After the 20 minutes, I scroll
down to my db (it's near the bottom <g>) and select "New Window from Here".
I'm absolutely disinterested in the 599 dbs I can't open. I know the server
name and the db name that I can open. Is there any way to hack MMC to do a
"New Window from Here" to my database? I'd love to skip the 20 minute
useless population of all dbs on the server!
Thanks.
-- Mark
Do you have the latest Service Pack on the client where Enterprise Manager
is running? There is a bug in EM where it does way too much work for every
database while it is opening it. I'll admit, 600 dbs is a lot, but it
shouldn't take 20 minutes. Also make sure none of the databases are set to
AUTOCLOSE, because then they must be opened before they can be displayed.
Also, could you consider changing the db's name to something closer to the
start of the alphabet?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
> Sorry if this is a FAQ. Googling way joyless. ;-)
> I have an MS SQL 2000 database on a web host. Since there are about 600
dbs
> on the host's server it takes about 20 minutes to expand the databases on
> the server in SQL Server Enterprise Manager. After the 20 minutes, I
scroll
> down to my db (it's near the bottom <g>) and select "New Window from
Here".
> I'm absolutely disinterested in the 599 dbs I can't open. I know the
server
> name and the db name that I can open. Is there any way to hack MMC to do
a
> "New Window from Here" to my database? I'd love to skip the 20 minute
> useless population of all dbs on the server!
> Thanks.
> -- Mark
>
|||Mark Jerde wrote:
> Sorry if this is a FAQ. Googling way joyless. ;-)
Grrrr... Should have been, "Googling was joyless" ;-) That is, I
searched for a solution but didn't find it. It could be operator error...
<g>
-- Mark
|||Kalen Delaney wrote:
> Do you have the latest Service Pack on the client where Enterprise
> Manager is running? There is a bug in EM where it does way too much
> work for every database while it is opening it. I'll admit, 600 dbs
> is a lot, but it shouldn't take 20 minutes.
Yes, I keep all my machines up to date.

> Also make sure none of
> the databases are set to AUTOCLOSE, because then they must be opened
> before they can be displayed.
Is this something I can do, or is it a responsibility of the web host? (I'm
in Maryland, USA, and the host is in California.)

> Also, could you consider changing the db's name to something closer
> to the start of the alphabet?
Not an option. When I signed up for the $10 per month db they assigned me
the db name. I don't see as it matters, though, as the whole tree has to
populate before I can click on anything.
[vbcol=seagreen]
> news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
|||Mark
Please verify the actual version of EM that you are using and the version of
SQL Server itself.
AUTOCLOSE is a property of the database in SQL Server.
SELECT databasepropertyex('<dbname>', 'Isautoclose')
if this returns 1, the database is set to autoclose. So are not all the
other databases under your control? If they all have autoclose on, you're
pretty much SOL until the next version of SQL Server comes out.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:OreERHAKEHA.3120@.TK2MSFTNGP11.phx.gbl...
> Kalen Delaney wrote:
> Yes, I keep all my machines up to date.
>
> Is this something I can do, or is it a responsibility of the web host?
(I'm
> in Maryland, USA, and the host is in California.)
>
> Not an option. When I signed up for the $10 per month db they assigned me
> the db name. I don't see as it matters, though, as the whole tree has to
> populate before I can click on anything.
>
>
|||Hi Mark,
From your descriptions, I know you want to start your database from SQL
Server Enterprise Manager and make it starts up with your database instead
of it's original view. Have I understood you?
However, I am sorry to say that you could not make it. SQL Server
Enterprise Manager is an Microsoft Management Colsole Application, which
use mmec.exe to host administrative tools. "New Window from Here" just give
a new view instead of an application. There is no shortcut for it
Moreover, I think Kalen's suggestion is great and you'd better check
AUTOCLOSE option for all databases in your server.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||To add to the other responses, you might consider using Query Analyzer
instead of Enterprise Manager to manage your database. You can do
everything you need to manage your hosted database using this tool, although
you'll need to use SQL scripts.
Although I haven't used this myself, there's a .Net web-based management
tool, SQL Server Web Data Administrator, to facilitate remote db admin. See
<http://www.microsoft.com/downloads/d...a798-c57a-419e
-acbc-2a332cb7f959&DisplayLang=en> for more information. I understand that
there are also some third-party web-based tools that provider EM-like
functionality.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
> Sorry if this is a FAQ. Googling way joyless. ;-)
> I have an MS SQL 2000 database on a web host. Since there are about 600
dbs
> on the host's server it takes about 20 minutes to expand the databases on
> the server in SQL Server Enterprise Manager. After the 20 minutes, I
scroll
> down to my db (it's near the bottom <g>) and select "New Window from
Here".
> I'm absolutely disinterested in the 599 dbs I can't open. I know the
server
> name and the db name that I can open. Is there any way to hack MMC to do
a
> "New Window from Here" to my database? I'd love to skip the 20 minute
> useless population of all dbs on the server!
> Thanks.
> -- Mark
>
|||Thanks, everyone. It is just something I'll have to live with for now. I'm
"renting" the DB for $10 / mo (IIRC) and I have no control over the
alphabetic order or any server settings.
I'm aware there are other tools but I'm still working my way through books
enroute to mastery. ;-) When they say, "Open EM" I need to open EM to
follow along.
Fortunately Win2000 is a *lot* better for development than Win9x. Win2000
can stay up for days, but I was constantly rebooting Win9x.
-- Mark
"Michael, Cheng [MSFT]" wrote:
> Hi Mark,
> From your descriptions, I know you want to start your database from
> SQL Server Enterprise Manager and make it starts up with your
> database instead of it's original view. Have I understood you?
> However, I am sorry to say that you could not make it. SQL Server
> Enterprise Manager is an Microsoft Management Colsole Application,
> which use mmec.exe to host administrative tools. "New Window from
> Here" just give a new view instead of an application. There is no
> shortcut for it
> Moreover, I think Kalen's suggestion is great and you'd better check
> AUTOCLOSE option for all databases in your server.
> Thank you for your patience and cooperation. If you have any
> questions or concerns, don't hesitate to let me know. We are here to
> be of assistance!
> Sincerely yours,
> Michael Cheng
> Microsoft Online Support
> ************************************************** *********
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no
> rights. Please reply to newsgroups only, many thanks.

Enterprise Manager "New Window from Here" Hack or Whatever

Sorry if this is a FAQ. Googling way joyless. ;-)
I have an MS SQL 2000 database on a web host. Since there are about 600 dbs
on the host's server it takes about 20 minutes to expand the databases on
the server in SQL Server Enterprise Manager. After the 20 minutes, I scroll
down to my db (it's near the bottom <g> ) and select "New Window from Here".
I'm absolutely disinterested in the 599 dbs I can't open. I know the server
name and the db name that I can open. Is there any way to hack MMC to do a
"New Window from Here" to my database? I'd love to skip the 20 minute
useless population of all dbs on the server!
Thanks.
-- MarkDo you have the latest Service Pack on the client where Enterprise Manager
is running? There is a bug in EM where it does way too much work for every
database while it is opening it. I'll admit, 600 dbs is a lot, but it
shouldn't take 20 minutes. Also make sure none of the databases are set to
AUTOCLOSE, because then they must be opened before they can be displayed.
Also, could you consider changing the db's name to something closer to the
start of the alphabet?
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
> Sorry if this is a FAQ. Googling way joyless. ;-)
> I have an MS SQL 2000 database on a web host. Since there are about 600
dbs
> on the host's server it takes about 20 minutes to expand the databases on
> the server in SQL Server Enterprise Manager. After the 20 minutes, I
scroll
> down to my db (it's near the bottom <g> ) and select "New Window from
Here".
> I'm absolutely disinterested in the 599 dbs I can't open. I know the
server
> name and the db name that I can open. Is there any way to hack MMC to do
a
> "New Window from Here" to my database? I'd love to skip the 20 minute
> useless population of all dbs on the server!
> Thanks.
> -- Mark
>|||Mark Jerde wrote:
> Sorry if this is a FAQ. Googling way joyless. ;-)
Grrrr... Should have been, "Googling was joyless" ;-) That is, I
searched for a solution but didn't find it. It could be operator error...
<g>
-- Mark|||Kalen Delaney wrote:
> Do you have the latest Service Pack on the client where Enterprise
> Manager is running? There is a bug in EM where it does way too much
> work for every database while it is opening it. I'll admit, 600 dbs
> is a lot, but it shouldn't take 20 minutes.
Yes, I keep all my machines up to date.

> Also make sure none of
> the databases are set to AUTOCLOSE, because then they must be opened
> before they can be displayed.
Is this something I can do, or is it a responsibility of the web host? (I'm
in Maryland, USA, and the host is in California.)

> Also, could you consider changing the db's name to something closer
> to the start of the alphabet?
Not an option. When I signed up for the $10 per month db they assigned me
the db name. I don't see as it matters, though, as the whole tree has to
populate before I can click on anything.
[vbcol=seagreen]
> news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...|||Mark
Please verify the actual version of EM that you are using and the version of
SQL Server itself.
AUTOCLOSE is a property of the database in SQL Server.
SELECT databasepropertyex('<dbname>', 'Isautoclose')
if this returns 1, the database is set to autoclose. So are not all the
other databases under your control? If they all have autoclose on, you're
pretty much SOL until the next version of SQL Server comes out.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:OreERHAKEHA.3120@.TK2MSFTNGP11.phx.gbl...
> Kalen Delaney wrote:
> Yes, I keep all my machines up to date.
>
> Is this something I can do, or is it a responsibility of the web host?
(I'm
> in Maryland, USA, and the host is in California.)
>
> Not an option. When I signed up for the $10 per month db they assigned me
> the db name. I don't see as it matters, though, as the whole tree has to
> populate before I can click on anything.
>
>|||Hi Mark,
From your descriptions, I know you want to start your database from SQL
Server Enterprise Manager and make it starts up with your database instead
of it's original view. Have I understood you?
However, I am sorry to say that you could not make it. SQL Server
Enterprise Manager is an Microsoft Management Colsole Application, which
use mmec.exe to host administrative tools. "New Window from Here" just give
a new view instead of an application. There is no shortcut for it
Moreover, I think Kalen's suggestion is great and you'd better check
AUTOCLOSE option for all databases in your server.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
****************************************
*******************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.|||To add to the other responses, you might consider using Query Analyzer
instead of Enterprise Manager to manage your database. You can do
everything you need to manage your hosted database using this tool, although
you'll need to use SQL scripts.
Although I haven't used this myself, there's a .Net web-based management
tool, SQL Server Web Data Administrator, to facilitate remote db admin. See
<http://www.microsoft.com/downloads/...9a798-c57a-419e
-acbc-2a332cb7f959&DisplayLang=en> for more information. I understand that
there are also some third-party web-based tools that provider EM-like
functionality.
Hope this helps.
Dan Guzman
SQL Server MVP
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
> Sorry if this is a FAQ. Googling way joyless. ;-)
> I have an MS SQL 2000 database on a web host. Since there are about 600
dbs
> on the host's server it takes about 20 minutes to expand the databases on
> the server in SQL Server Enterprise Manager. After the 20 minutes, I
scroll
> down to my db (it's near the bottom <g> ) and select "New Window from
Here".
> I'm absolutely disinterested in the 599 dbs I can't open. I know the
server
> name and the db name that I can open. Is there any way to hack MMC to do
a
> "New Window from Here" to my database? I'd love to skip the 20 minute
> useless population of all dbs on the server!
> Thanks.
> -- Mark
>|||Thanks, everyone. It is just something I'll have to live with for now. I'm
"renting" the DB for $10 / mo (IIRC) and I have no control over the
alphabetic order or any server settings.
I'm aware there are other tools but I'm still working my way through books
enroute to mastery. ;-) When they say, "Open EM" I need to open EM to
follow along.
Fortunately Win2000 is a *lot* better for development than Win9x. Win2000
can stay up for days, but I was constantly rebooting Win9x.
-- Mark
"Michael, Cheng [MSFT]" wrote:
> Hi Mark,
> From your descriptions, I know you want to start your database from
> SQL Server Enterprise Manager and make it starts up with your
> database instead of it's original view. Have I understood you?
> However, I am sorry to say that you could not make it. SQL Server
> Enterprise Manager is an Microsoft Management Colsole Application,
> which use mmec.exe to host administrative tools. "New Window from
> Here" just give a new view instead of an application. There is no
> shortcut for it
> Moreover, I think Kalen's suggestion is great and you'd better check
> AUTOCLOSE option for all databases in your server.
> Thank you for your patience and cooperation. If you have any
> questions or concerns, don't hesitate to let me know. We are here to
> be of assistance!
> Sincerely yours,
> Michael Cheng
> Microsoft Online Support
> ****************************************
*******************
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no
> rights. Please reply to newsgroups only, many thanks.

Enterprise Manager "New Window from Here" Hack or Whatever

Sorry if this is a FAQ. Googling way joyless. ;-)
I have an MS SQL 2000 database on a web host. Since there are about 600 dbs
on the host's server it takes about 20 minutes to expand the databases on
the server in SQL Server Enterprise Manager. After the 20 minutes, I scroll
down to my db (it's near the bottom <g>) and select "New Window from Here".
I'm absolutely disinterested in the 599 dbs I can't open. I know the server
name and the db name that I can open. Is there any way to hack MMC to do a
"New Window from Here" to my database? I'd love to skip the 20 minute
useless population of all dbs on the server!
Thanks.
-- MarkDo you have the latest Service Pack on the client where Enterprise Manager
is running? There is a bug in EM where it does way too much work for every
database while it is opening it. I'll admit, 600 dbs is a lot, but it
shouldn't take 20 minutes. Also make sure none of the databases are set to
AUTOCLOSE, because then they must be opened before they can be displayed.
Also, could you consider changing the db's name to something closer to the
start of the alphabet?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
> Sorry if this is a FAQ. Googling way joyless. ;-)
> I have an MS SQL 2000 database on a web host. Since there are about 600
dbs
> on the host's server it takes about 20 minutes to expand the databases on
> the server in SQL Server Enterprise Manager. After the 20 minutes, I
scroll
> down to my db (it's near the bottom <g>) and select "New Window from
Here".
> I'm absolutely disinterested in the 599 dbs I can't open. I know the
server
> name and the db name that I can open. Is there any way to hack MMC to do
a
> "New Window from Here" to my database? I'd love to skip the 20 minute
> useless population of all dbs on the server!
> Thanks.
> -- Mark
>|||Mark Jerde wrote:
> Sorry if this is a FAQ. Googling way joyless. ;-)
Grrrr... Should have been, "Googling was joyless" ;-) That is, I
searched for a solution but didn't find it. It could be operator error...
<g>
-- Mark|||Kalen Delaney wrote:
> Do you have the latest Service Pack on the client where Enterprise
> Manager is running? There is a bug in EM where it does way too much
> work for every database while it is opening it. I'll admit, 600 dbs
> is a lot, but it shouldn't take 20 minutes.
Yes, I keep all my machines up to date.
> Also make sure none of
> the databases are set to AUTOCLOSE, because then they must be opened
> before they can be displayed.
Is this something I can do, or is it a responsibility of the web host? (I'm
in Maryland, USA, and the host is in California.)
> Also, could you consider changing the db's name to something closer
> to the start of the alphabet?
Not an option. When I signed up for the $10 per month db they assigned me
the db name. I don't see as it matters, though, as the whole tree has to
populate before I can click on anything.
> > "Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
> news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
>> Sorry if this is a FAQ. Googling way joyless. ;-)
>> I have an MS SQL 2000 database on a web host. Since there are about
>> 600 dbs on the host's server it takes about 20 minutes to expand the
>> databases on the server in SQL Server Enterprise Manager. After the
>> 20 minutes, I scroll down to my db (it's near the bottom <g>) and
>> select "New Window from Here".
>> I'm absolutely disinterested in the 599 dbs I can't open. I know
>> the server name and the db name that I can open. Is there any way
>> to hack MMC to do a "New Window from Here" to my database? I'd love
>> to skip the 20 minute useless population of all dbs on the server!
>> Thanks.
>> -- Mark|||Mark
Please verify the actual version of EM that you are using and the version of
SQL Server itself.
AUTOCLOSE is a property of the database in SQL Server.
SELECT databasepropertyex('<dbname>', 'Isautoclose')
if this returns 1, the database is set to autoclose. So are not all the
other databases under your control? If they all have autoclose on, you're
pretty much SOL until the next version of SQL Server comes out.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:OreERHAKEHA.3120@.TK2MSFTNGP11.phx.gbl...
> Kalen Delaney wrote:
> > Do you have the latest Service Pack on the client where Enterprise
> > Manager is running? There is a bug in EM where it does way too much
> > work for every database while it is opening it. I'll admit, 600 dbs
> > is a lot, but it shouldn't take 20 minutes.
> Yes, I keep all my machines up to date.
> > Also make sure none of
> > the databases are set to AUTOCLOSE, because then they must be opened
> > before they can be displayed.
> Is this something I can do, or is it a responsibility of the web host?
(I'm
> in Maryland, USA, and the host is in California.)
> > Also, could you consider changing the db's name to something closer
> > to the start of the alphabet?
> Not an option. When I signed up for the $10 per month db they assigned me
> the db name. I don't see as it matters, though, as the whole tree has to
> populate before I can click on anything.
> > > "Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
> > news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
> >> Sorry if this is a FAQ. Googling way joyless. ;-)
> >>
> >> I have an MS SQL 2000 database on a web host. Since there are about
> >> 600 dbs on the host's server it takes about 20 minutes to expand the
> >> databases on the server in SQL Server Enterprise Manager. After the
> >> 20 minutes, I scroll down to my db (it's near the bottom <g>) and
> >> select "New Window from Here".
> >>
> >> I'm absolutely disinterested in the 599 dbs I can't open. I know
> >> the server name and the db name that I can open. Is there any way
> >> to hack MMC to do a "New Window from Here" to my database? I'd love
> >> to skip the 20 minute useless population of all dbs on the server!
> >>
> >> Thanks.
> >>
> >> -- Mark
>|||Hi Mark,
From your descriptions, I know you want to start your database from SQL
Server Enterprise Manager and make it starts up with your database instead
of it's original view. Have I understood you?
However, I am sorry to say that you could not make it. SQL Server
Enterprise Manager is an Microsoft Management Colsole Application, which
use mmec.exe to host administrative tools. "New Window from Here" just give
a new view instead of an application. There is no shortcut for it :(
Moreover, I think Kalen's suggestion is great and you'd better check
AUTOCLOSE option for all databases in your server.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.|||To add to the other responses, you might consider using Query Analyzer
instead of Enterprise Manager to manage your database. You can do
everything you need to manage your hosted database using this tool, although
you'll need to use SQL scripts.
Although I haven't used this myself, there's a .Net web-based management
tool, SQL Server Web Data Administrator, to facilitate remote db admin. See
<http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e
-acbc-2a332cb7f959&DisplayLang=en> for more information. I understand that
there are also some third-party web-based tools that provider EM-like
functionality.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Mark Jerde" <mark.jerde@.verizon.no.spam.net> wrote in message
news:ukL0hx$JEHA.2012@.TK2MSFTNGP11.phx.gbl...
> Sorry if this is a FAQ. Googling way joyless. ;-)
> I have an MS SQL 2000 database on a web host. Since there are about 600
dbs
> on the host's server it takes about 20 minutes to expand the databases on
> the server in SQL Server Enterprise Manager. After the 20 minutes, I
scroll
> down to my db (it's near the bottom <g>) and select "New Window from
Here".
> I'm absolutely disinterested in the 599 dbs I can't open. I know the
server
> name and the db name that I can open. Is there any way to hack MMC to do
a
> "New Window from Here" to my database? I'd love to skip the 20 minute
> useless population of all dbs on the server!
> Thanks.
> -- Mark
>|||Thanks, everyone. It is just something I'll have to live with for now. I'm
"renting" the DB for $10 / mo (IIRC) and I have no control over the
alphabetic order or any server settings.
I'm aware there are other tools but I'm still working my way through books
enroute to mastery. ;-) When they say, "Open EM" I need to open EM to
follow along.
Fortunately Win2000 is a *lot* better for development than Win9x. Win2000
can stay up for days, but I was constantly rebooting Win9x.
-- Mark
"Michael, Cheng [MSFT]" wrote:
> Hi Mark,
> From your descriptions, I know you want to start your database from
> SQL Server Enterprise Manager and make it starts up with your
> database instead of it's original view. Have I understood you?
> However, I am sorry to say that you could not make it. SQL Server
> Enterprise Manager is an Microsoft Management Colsole Application,
> which use mmec.exe to host administrative tools. "New Window from
> Here" just give a new view instead of an application. There is no
> shortcut for it :(
> Moreover, I think Kalen's suggestion is great and you'd better check
> AUTOCLOSE option for all databases in your server.
> Thank you for your patience and cooperation. If you have any
> questions or concerns, don't hesitate to let me know. We are here to
> be of assistance!
> Sincerely yours,
> Michael Cheng
> Microsoft Online Support
> ***********************************************************
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no
> rights. Please reply to newsgroups only, many thanks.