Remote View Question

I am connecting through EM to another SQL server for my web
site, is there a way to limit it so that I only see my database and
not all the 100's of others that are listed.

Also, sorry if this sounds dumb but I applied the sp3 sevice
pack and I dont know how to verify this, normallly one would go to
help>about and see it there, there was a sp3 and a sp3a, but a
friend told me to only apply the sp3, needless to say it seems slow
connecting and I would like to verify that everything is in working
order.

Thank You

Reply to newsgroup as email address is bogus due to spam

MichaelIn the query analyzer run the command: @.@.version. When your version
numbver shows 8.00.760 SP3 is installed. Have a look at this website:
http://www.krell-software.com/mssql-builds.htm for all version numbers
of sql-server.

There is no reason not to install SP3a !!!

Hiding database in the EM is just not possible:

"There is not a way to hide the databases in Enterprise Manager. It
does not
have that capability. The database listing comes from the sysdatabases
table and there is no way to filter the data to hide the databases the
user
does not have access to"

Greetings Sjaak|||MiKeY <Mikey@.yahoo.com> wrote in message news:<anhksvc3gnc041ib7snqh6chbgnpttlrhd@.4ax.com>...
> I am connecting through EM to another SQL server for my web
> site, is there a way to limit it so that I only see my database and
> not all the 100's of others that are listed.
> Also, sorry if this sounds dumb but I applied the sp3 sevice
> pack and I dont know how to verify this, normallly one would go to
> help>about and see it there, there was a sp3 and a sp3a, but a
> friend told me to only apply the sp3, needless to say it seems slow
> connecting and I would like to verify that everything is in working
> order.
>
> Thank You
> Reply to newsgroup as email address is bogus due to spam
>
> Michael

EM always displays all databases on the server; QA displays only the
ones you have access to. But connecting with QA probably won't be any
faster, because it has the check all databases to see if you can
access them. From the server side, if any databases are set to
autoclose, then populating the list in EM can be very slow, but if you
are not the DBA or if the server is with an ISP, then there's probably
not much you can do about that.

As for identifying the servicepack, on the client you can check the
version number in Help-About in QA; for the server you can check this
KB article:

http://support.microsoft.com/defaul...b;en-us;q321185

Simonsql