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.
No comments:
Post a Comment