Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
Julian
Julian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>
|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who
> is
>
sql

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
who[vbcol=seagreen]
> is
>

Enumerate Users in NT Groups

Hi,
How Can I list the users in an NT group, ie I have user Joe Bloggs who is
in NT Group Domain/Users.
I need to return to a client app what group they are in.
JulianJulian
Look at sp_helpusers and also
DECLARE @.cmd VARCHAR(100)
SET @.cmd = 'NET USER "' + yourloginname+ '"'
EXEC master.dbo.xp_cmdshell @.cmd
"Julian" <Jpotter730@.msn.com> wrote in message
news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> Hi,
> How Can I list the users in an NT group, ie I have user Joe Bloggs who
is
> in NT Group Domain/Users.
> I need to return to a client app what group they are in.
> Julian
>|||Hi,
Run the below command from command prompt to list the users inside a group.
net group groupname
and for local groups run the below command
net localgroup groupname
Note: From Query analyzer as Uri mentioned you can use xp_cmdshell to
execute the above commands.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ep7KNCdLEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Julian
> Look at sp_helpusers and also
> DECLARE @.cmd VARCHAR(100)
> SET @.cmd = 'NET USER "' + yourloginname+ '"'
> EXEC master.dbo.xp_cmdshell @.cmd
> "Julian" <Jpotter730@.msn.com> wrote in message
> news:#GH7q9cLEHA.1484@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > How Can I list the users in an NT group, ie I have user Joe Bloggs
who
> is
> > in NT Group Domain/Users.
> >
> > I need to return to a client app what group they are in.
> >
> > Julian
> >
> >
>

Enumerate backup files

How do you enumerate database backup files? I see Server has an EnumDirectories but no EnumFiles. I'd like to show the user a list of database backups and have them choose the one they want to restore.SELECT DISTINCT physical_device_name FROM msdb.dbo.backupmediafamily returns the list.

Enumerate backup files

How do you enumerate database backup files? I see Server has an EnumDirectories but no EnumFiles. I'd like to show the user a list of database backups and have them choose the one they want to restore.SELECT DISTINCT physical_device_name FROM msdb.dbo.backupmediafamily returns the list.

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 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 Manager User Log-in DB Visability

I have created new login in my Enterprise Manager. The login is not part of any roles and only allowed access to 1 database (of 200). However, they can see all the databases in Enterprise Manager.

They can't do anything with them, but I don't even want them to see them.

Have I set something up wrong?Hi ,

I posted earlier the same questune , i think that its not possible for users wont be bale to see the dbs , but i couldnt prevent also access to the master db objects that is realy bad thing .|||There must be something that can be done! How would an ISP that wants to host SQL Server for people deal with it?

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 with views

We have a user who is a db_owner on a database that he can't create a view using Enterprise Manager. When he tries to create a view it returns: "ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '240'." His NT Domain username is 240DBH.

We've tried it on my computer with him logging on and get the same result. He can create views just fine using query analyzer. Does anybody know what's wrong with doing this in Enterprise Manager? By the way, I can create views in the db using Enterprise Manager just fine.

Thanks for your help!Turn Profiler on and see what commands Enterprise is sending to the server to create this view. It may shed some light.|||Thanks for the suggestion! I hadn't used the profiler before. It is trying to execute the following:

CREATE VIEW 240dbh.VIEW1
AS
SELECT ID, [Start Date]
FROM T_DATA

Now, when I run this in query analyzer, I get the same error. It seems like that should work to me.:confused:|||Now I think I have it narrowed down. His username starts with numbers. If you can't have a username that starts with numbers, that is pretty lame.

Does anyone know if there is a better front-end than enterprise manager for creating tables/views/stored procedures?

Thanks!|||User names with numbers are not a problem. Does the user have ddladmin rights?

If you are using SS2K than use the Query Analyzer! Much better for users than the EM!|||I set up a user under sql server 7 with a username that has no numbers with the exact same permissions as that user who can't create a view.

That new user with no numbers can create views just fine.

So, the only difference between the two users is that one is a sql server logon and one uses NT domain authentication, and the fact that one has numbers in the username.

What I'm finding is that if enterprise manager would do something like:
CREATE VIEW [240dbh].VIEW1

instead of:
CREATE VIEW 240dbh.VIEW1

it would work.

Enterprise Manager Problem

Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJ
Try reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegr oups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>

Enterprise Manager Problem

Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJTry reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegroups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>

Enterprise Manager Problem

Suddenly one of my user started seeing one problem.. Whenever he tries
to connect to database and see tables through enterprise manager. Gets
error as shown below.
"An unexpected error happened during this operation.
[MS Design Tools] - You might not have permission to perform this
operation, or the object Administrator might no longer exist in
database."
Though previously there wasn't any problem.. I just droped and
recreated this login with same permission as previously. Even tried
assigning system administrator role to the login but no success.
Please help
Thanks
NJTry reinstall the client.
Quentin
"neeju" <njvds.o11@.gmail.com> wrote in message
news:1138897109.940035.202020@.z14g2000cwz.googlegroups.com...
> Suddenly one of my user started seeing one problem.. Whenever he tries
> to connect to database and see tables through enterprise manager. Gets
> error as shown below.
> "An unexpected error happened during this operation.
> [MS Design Tools] - You might not have permission to perform this
> operation, or the object Administrator might no longer exist in
> database."
>
> Though previously there wasn't any problem.. I just droped and
> recreated this login with same permission as previously. Even tried
> assigning system administrator role to the login but no success.
> Please help
> Thanks
> NJ
>

Enterprise Manager list databases

Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
BorkoSee my reply in .server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctal5t$cll$1@.ls219.htnet.hr...red">
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from
> listing other databases on SQL server?
> Every user can see the list of databases but can change only his database.
> Is there a way to set it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>|||Ho Borko, have you found a solution for this?!
Thank you
Felipe

quote:

---

Originally posted by borko
Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
Borko

---

Enterprise Manager list databases

Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
Borko
Not with the current version. SQL2005 will have more ways to handle things
like this.
Andrew J. Kelly SQL MVP
"borko" <borko@.borko.co.co> wrote in message
news:ctal4s$cg1$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from
> listing other databases on SQL server?
> Every user can see the list of databases but can change only his database.
> Is there a way to set it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>
>

Enterprise Manager list databases

Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
Borko
Not any supported way. The only way I know of would be to hack the stored procedure that EM uses to
retrieve the database list. This is not supported and done at your own risk. I don't recommend it.
Possibly, you find such hack if you search the newsgroup archives.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctakq8$c0n$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from listing other databases on
> SQL server?
> Every user can see the list of databases but can change only his database. Is there a way to set
> it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>
|||Even if you "hacked" the system sp, the next hotfix or service pack release
would overwrite any work you had done. Moreoer, the
INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
user.
This is the nature of a DBMS, to announce its existence and the catalogues
it make available. It is up to the DBA to secure those systems, not to hide
them.
Out of curiosity, why the need to conceal the names?
Sincerely,
Anthony Thomas

"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
Not any supported way. The only way I know of would be to hack the stored
procedure that EM uses to
retrieve the database list. This is not supported and done at your own risk.
I don't recommend it.
Possibly, you find such hack if you search the newsgroup archives.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message
news:ctakq8$c0n$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on
> SQL server?
> Every user can see the list of databases but can change only his database.
Is there a way to set
> it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>
|||In news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl,
Anthony Thomas <ALThomas@.kc.rr.com> said:
> Even if you "hacked" the system sp, the next hotfix or service pack
> release would overwrite any work you had done. Moreoer, the
> INFORMATION_SCHEMA.SCHEMATA would still be available to query for
> EVERY user.
> This is the nature of a DBMS, to announce its existence and the
> catalogues it make available. It is up to the DBA to secure those
> systems, not to hide them.
> Out of curiosity, why the need to conceal the names?
If you're running a shared database server (i.e. one which is used by
different companies), you may wish to hide the other database names or
indeed their quantity!
Steve
|||FYI, in next version of SQL Server you will only see objects etc on which you have permissions...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Steve" <steve@.somewhere.invalid.com> wrote in message
news:sx7Kd.207465$ju.35135@.news.easynews.com...
> In news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl,
> Anthony Thomas <ALThomas@.kc.rr.com> said:
> If you're running a shared database server (i.e. one which is used by
> different companies), you may wish to hide the other database names or
> indeed their quantity!
> --
> Steve
>
|||Hi,
Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of privacy/business secret ... they don't want me to be able to see
what users are on the server (database names)
Just out of curiosity, is it possible to get the database list from ASP?
Thanks,
Borko
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> Even if you "hacked" the system sp, the next hotfix or service pack
> release
> would overwrite any work you had done. Moreoer, the
> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
> user.
> This is the nature of a DBMS, to announce its existence and the catalogues
> it make available. It is up to the DBA to secure those systems, not to
> hide
> them.
> Out of curiosity, why the need to conceal the names?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
> Not any supported way. The only way I know of would be to hack the stored
> procedure that EM uses to
> retrieve the database list. This is not supported and done at your own
> risk.
> I don't recommend it.
> Possibly, you find such hack if you search the newsgroup archives.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "borko" <borko@.borko.co.co> wrote in message
> news:ctakq8$c0n$1@.ls219.htnet.hr...
> listing other databases on
> Is there a way to set
>
|||> Just out of curiosity, is it possible to get the database list from ASP?
You can get a list of databases from any programming language from which you can execute SQL
statements:
SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctd2p1$4j2$1@.ls219.htnet.hr...
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager because of
> privacy/business secret ... they don't want me to be able to see what users are on the server
> (database names)
> Just out of curiosity, is it possible to get the database list from ASP?
> Thanks,
> Borko
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
>
|||And the old standby, sp_helpdb.
This is kind of the point, a server ALWAYS announces its services. You have
to do quite a bit of homework to block that.
This is another good reason to ALWAYS choose a default database for EVERY
login, not just master. If users are used to automatically landing in
"their" databases, there is less need to query for others.
However, nothing is absolute; so, these are minor twiddles and not a real
solution. The real solution is what Tibor pointed out, that the upcoming
version has security in mind and that you will only view what you have
permission to.
Anthony Thomas

"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uLM0lmSBFHA.3820@.TK2MSFTNGP11.phx.gbl...
> Just out of curiosity, is it possible to get the database list from ASP?
You can get a list of databases from any programming language from which you
can execute SQL
statements:
SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message
news:ctd2p1$4j2$1@.ls219.htnet.hr...
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of
> privacy/business secret ... they don't want me to be able to see what
users are on the server[vbcol=seagreen]
> (database names)
> Just out of curiosity, is it possible to get the database list from ASP?
> Thanks,
> Borko
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
release[vbcol=seagreen]
catalogues[vbcol=seagreen]
hide[vbcol=seagreen]
in[vbcol=seagreen]
risk.[vbcol=seagreen]
database.
>

Enterprise Manager list databases

Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
BorkoNot any supported way. The only way I know of would be to hack the stored pr
ocedure that EM uses to
retrieve the database list. This is not supported and done at your own risk.
I don't recommend it.
Possibly, you find such hack if you search the newsgroup archives.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctakq8$c0n$1@.ls219.htnet.hr...een">
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from lis
ting other databases on
> SQL server?
> Every user can see the list of databases but can change only his database.
Is there a way to set
> it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>|||Even if you "hacked" the system sp, the next hotfix or service pack release
would overwrite any work you had done. Moreoer, the
INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
user.
This is the nature of a DBMS, to announce its existence and the catalogues
it make available. It is up to the DBA to secure those systems, not to hide
them.
Out of curiosity, why the need to conceal the names?
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
Not any supported way. The only way I know of would be to hack the stored
procedure that EM uses to
retrieve the database list. This is not supported and done at your own risk.
I don't recommend it.
Possibly, you find such hack if you search the newsgroup archives.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message
news:ctakq8$c0n$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on
> SQL server?
> Every user can see the list of databases but can change only his database.
Is there a way to set
> it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>|||In news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl,
Anthony Thomas <ALThomas@.kc.rr.com> said:
> Even if you "hacked" the system sp, the next hotfix or service pack
> release would overwrite any work you had done. Moreoer, the
> INFORMATION_SCHEMA.SCHEMATA would still be available to query for
> EVERY user.
> This is the nature of a DBMS, to announce its existence and the
> catalogues it make available. It is up to the DBA to secure those
> systems, not to hide them.
> Out of curiosity, why the need to conceal the names?
If you're running a shared database server (i.e. one which is used by
different companies), you may wish to hide the other database names or
indeed their quantity!
Steve|||FYI, in next version of SQL Server you will only see objects etc on which yo
u have permissions...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Steve" <steve@.somewhere.invalid.com> wrote in message
news:sx7Kd.207465$ju.35135@.news.easynews.com...
> In news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl,
> Anthony Thomas <ALThomas@.kc.rr.com> said:
> If you're running a shared database server (i.e. one which is used by
> different companies), you may wish to hide the other database names or
> indeed their quantity!
> --
> Steve
>|||Hi,
Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of privacy/business secret ... they don't want me to be able to see
what users are on the server (database names)
Just out of curiosity, is it possible to get the database list from ASP?
Thanks,
Borko
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> Even if you "hacked" the system sp, the next hotfix or service pack
> release
> would overwrite any work you had done. Moreoer, the
> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
> user.
> This is the nature of a DBMS, to announce its existence and the catalogues
> it make available. It is up to the DBA to secure those systems, not to
> hide
> them.
> Out of curiosity, why the need to conceal the names?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
> Not any supported way. The only way I know of would be to hack the stored
> procedure that EM uses to
> retrieve the database list. This is not supported and done at your own
> risk.
> I don't recommend it.
> Possibly, you find such hack if you search the newsgroup archives.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "borko" <borko@.borko.co.co> wrote in message
> news:ctakq8$c0n$1@.ls219.htnet.hr...
> listing other databases on
> Is there a way to set
>|||> Just out of curiosity, is it possible to get the database list from ASP?
You can get a list of databases from any programming language from which you
can execute SQL
statements:
SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctd2p1$4j2$1@.ls219.htnet.hr...een">
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of
> privacy/business secret ... they don't want me to be able to see what user
s are on the server
> (database names)
> Just out of curiosity, is it possible to get the database list from ASP?
> Thanks,
> Borko
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
>|||And the old standby, sp_helpdb.
This is kind of the point, a server ALWAYS announces its services. You have
to do quite a bit of homework to block that.
This is another good reason to ALWAYS choose a default database for EVERY
login, not just master. If users are used to automatically landing in
"their" databases, there is less need to query for others.
However, nothing is absolute; so, these are minor twiddles and not a real
solution. The real solution is what Tibor pointed out, that the upcoming
version has security in mind and that you will only view what you have
permission to.
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uLM0lmSBFHA.3820@.TK2MSFTNGP11.phx.gbl...
> Just out of curiosity, is it possible to get the database list from ASP?
You can get a list of databases from any programming language from which you
can execute SQL
statements:
SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message
news:ctd2p1$4j2$1@.ls219.htnet.hr...
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of
> privacy/business secret ... they don't want me to be able to see what
users are on the server
> (database names)
> Just out of curiosity, is it possible to get the database list from ASP?
> Thanks,
> Borko
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
release[vbcol=seagreen]
catalogues[vbcol=seagreen]
hide[vbcol=seagreen]
in[vbcol=seagreen]
risk.[vbcol=seagreen]
database.[vbcol=seagreen]
>

Enterprise Manager list databases

Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
BorkoNot any supported way. The only way I know of would be to hack the stored procedure that EM uses to
retrieve the database list. This is not supported and done at your own risk. I don't recommend it.
Possibly, you find such hack if you search the newsgroup archives.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctakq8$c0n$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from listing other databases on
> SQL server?
> Every user can see the list of databases but can change only his database. Is there a way to set
> it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>|||Even if you "hacked" the system sp, the next hotfix or service pack release
would overwrite any work you had done. Moreoer, the
INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
user.
This is the nature of a DBMS, to announce its existence and the catalogues
it make available. It is up to the DBA to secure those systems, not to hide
them.
Out of curiosity, why the need to conceal the names?
Sincerely,
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
Not any supported way. The only way I know of would be to hack the stored
procedure that EM uses to
retrieve the database list. This is not supported and done at your own risk.
I don't recommend it.
Possibly, you find such hack if you search the newsgroup archives.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message
news:ctakq8$c0n$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on
> SQL server?
> Every user can see the list of databases but can change only his database.
Is there a way to set
> it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>|||In news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl,
Anthony Thomas <ALThomas@.kc.rr.com> said:
> Even if you "hacked" the system sp, the next hotfix or service pack
> release would overwrite any work you had done. Moreoer, the
> INFORMATION_SCHEMA.SCHEMATA would still be available to query for
> EVERY user.
> This is the nature of a DBMS, to announce its existence and the
> catalogues it make available. It is up to the DBA to secure those
> systems, not to hide them.
> Out of curiosity, why the need to conceal the names?
If you're running a shared database server (i.e. one which is used by
different companies), you may wish to hide the other database names or
indeed their quantity!
--
Steve|||FYI, in next version of SQL Server you will only see objects etc on which you have permissions...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Steve" <steve@.somewhere.invalid.com> wrote in message
news:sx7Kd.207465$ju.35135@.news.easynews.com...
> In news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl,
> Anthony Thomas <ALThomas@.kc.rr.com> said:
>> Even if you "hacked" the system sp, the next hotfix or service pack
>> release would overwrite any work you had done. Moreoer, the
>> INFORMATION_SCHEMA.SCHEMATA would still be available to query for
>> EVERY user.
>> This is the nature of a DBMS, to announce its existence and the
>> catalogues it make available. It is up to the DBA to secure those
>> systems, not to hide them.
>> Out of curiosity, why the need to conceal the names?
> If you're running a shared database server (i.e. one which is used by
> different companies), you may wish to hide the other database names or
> indeed their quantity!
> --
> Steve
>|||Hi,
Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of privacy/business secret ... they don't want me to be able to see
what users are on the server (database names)
Just out of curiosity, is it possible to get the database list from ASP?
Thanks,
Borko
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> Even if you "hacked" the system sp, the next hotfix or service pack
> release
> would overwrite any work you had done. Moreoer, the
> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
> user.
> This is the nature of a DBMS, to announce its existence and the catalogues
> it make available. It is up to the DBA to secure those systems, not to
> hide
> them.
> Out of curiosity, why the need to conceal the names?
> Sincerely,
>
> Anthony Thomas
>
> --
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in
> message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
> Not any supported way. The only way I know of would be to hack the stored
> procedure that EM uses to
> retrieve the database list. This is not supported and done at your own
> risk.
> I don't recommend it.
> Possibly, you find such hack if you search the newsgroup archives.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "borko" <borko@.borko.co.co> wrote in message
> news:ctakq8$c0n$1@.ls219.htnet.hr...
>> Hi everyone,
>> Is there a possibility to block SQL user using Enterprise Manager from
> listing other databases on
>> SQL server?
>> Every user can see the list of databases but can change only his
>> database.
> Is there a way to set
>> it up just his own and nothing else.
>> Suggestions, links, ... appreciated
>> Thanks,
>> Borko
>|||> Just out of curiosity, is it possible to get the database list from ASP?
You can get a list of databases from any programming language from which you can execute SQL
statements:
SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message news:ctd2p1$4j2$1@.ls219.htnet.hr...
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager because of
> privacy/business secret ... they don't want me to be able to see what users are on the server
> (database names)
> Just out of curiosity, is it possible to get the database list from ASP?
> Thanks,
> Borko
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
>> Even if you "hacked" the system sp, the next hotfix or service pack release
>> would overwrite any work you had done. Moreoer, the
>> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
>> user.
>> This is the nature of a DBMS, to announce its existence and the catalogues
>> it make available. It is up to the DBA to secure those systems, not to hide
>> them.
>> Out of curiosity, why the need to conceal the names?
>> Sincerely,
>>
>> Anthony Thomas
>>
>> --
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>> message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
>> Not any supported way. The only way I know of would be to hack the stored
>> procedure that EM uses to
>> retrieve the database list. This is not supported and done at your own risk.
>> I don't recommend it.
>> Possibly, you find such hack if you search the newsgroup archives.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "borko" <borko@.borko.co.co> wrote in message
>> news:ctakq8$c0n$1@.ls219.htnet.hr...
>> Hi everyone,
>> Is there a possibility to block SQL user using Enterprise Manager from
>> listing other databases on
>> SQL server?
>> Every user can see the list of databases but can change only his database.
>> Is there a way to set
>> it up just his own and nothing else.
>> Suggestions, links, ... appreciated
>> Thanks,
>> Borko
>>
>|||And the old standby, sp_helpdb.
This is kind of the point, a server ALWAYS announces its services. You have
to do quite a bit of homework to block that.
This is another good reason to ALWAYS choose a default database for EVERY
login, not just master. If users are used to automatically landing in
"their" databases, there is less need to query for others.
However, nothing is absolute; so, these are minor twiddles and not a real
solution. The real solution is what Tibor pointed out, that the upcoming
version has security in mind and that you will only view what you have
permission to.
Anthony Thomas
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uLM0lmSBFHA.3820@.TK2MSFTNGP11.phx.gbl...
> Just out of curiosity, is it possible to get the database list from ASP?
You can get a list of databases from any programming language from which you
can execute SQL
statements:
SELECT CATALOG_NAME FROM INFORMATION_SCHEMA.SCHEMATA
or
SELECT name FROM sysdatabases
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"borko" <borko@.borko.co.co> wrote in message
news:ctd2p1$4j2$1@.ls219.htnet.hr...
> Hi,
> Provider (that I am stuck with) doesn't allow me to use Enterprise Manager
because of
> privacy/business secret ... they don't want me to be able to see what
users are on the server
> (database names)
> Just out of curiosity, is it possible to get the database list from ASP?
> Thanks,
> Borko
>
> "Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
> news:O9VSm6GBFHA.2428@.TK2MSFTNGP14.phx.gbl...
>> Even if you "hacked" the system sp, the next hotfix or service pack
release
>> would overwrite any work you had done. Moreoer, the
>> INFORMATION_SCHEMA.SCHEMATA would still be available to query for EVERY
>> user.
>> This is the nature of a DBMS, to announce its existence and the
catalogues
>> it make available. It is up to the DBA to secure those systems, not to
hide
>> them.
>> Out of curiosity, why the need to conceal the names?
>> Sincerely,
>>
>> Anthony Thomas
>>
>> --
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
>> message news:eTK$umGBFHA.3472@.TK2MSFTNGP14.phx.gbl...
>> Not any supported way. The only way I know of would be to hack the stored
>> procedure that EM uses to
>> retrieve the database list. This is not supported and done at your own
risk.
>> I don't recommend it.
>> Possibly, you find such hack if you search the newsgroup archives.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "borko" <borko@.borko.co.co> wrote in message
>> news:ctakq8$c0n$1@.ls219.htnet.hr...
>> Hi everyone,
>> Is there a possibility to block SQL user using Enterprise Manager from
>> listing other databases on
>> SQL server?
>> Every user can see the list of databases but can change only his
database.
>> Is there a way to set
>> it up just his own and nothing else.
>> Suggestions, links, ... appreciated
>> Thanks,
>> Borko
>>
>

Enterprise Manager list databases

Hi everyone,
Is there a possibility to block SQL user using Enterprise Manager from
listing other databases on SQL server?
Every user can see the list of databases but can change only his database.
Is there a way to set it up just his own and nothing else.
Suggestions, links, ... appreciated
Thanks,
BorkoNot with the current version. SQL2005 will have more ways to handle things
like this.
Andrew J. Kelly SQL MVP
"borko" <borko@.borko.co.co> wrote in message
news:ctal4s$cg1$1@.ls219.htnet.hr...
> Hi everyone,
> Is there a possibility to block SQL user using Enterprise Manager from
> listing other databases on SQL server?
> Every user can see the list of databases but can change only his database.
> Is there a way to set it up just his own and nothing else.
> Suggestions, links, ... appreciated
> Thanks,
> Borko
>
>

Enterprise Manager hangs

Hi,
I have a production server which has about six user databases. Recently,
when I try to do a restore ( I wanted to see the available backup sets) on
any of the databases using Enterprise Manager (All Tasks -> Restore) it
hangs. However, it promptly brings a pop up window when I do the All Tasks ->
Backup. What might be causing it to behave this way?
Thanks in advance.
Hi
Perhaps you need to delete a backup history
http://weblogs.sqlteam.com/geoffh/archive/2008/01/21/MSDB-Performance-Tuning.aspx
"ronnie" <ronnie@.discussions.microsoft.com> wrote in message
news:B67B18F5-2ACD-49E5-A7EA-AA5A65487B68@.microsoft.com...
> Hi,
> I have a production server which has about six user databases. Recently,
> when I try to do a restore ( I wanted to see the available backup sets) on
> any of the databases using Enterprise Manager (All Tasks -> Restore) it
> hangs. However, it promptly brings a pop up window when I do the All
> Tasks ->
> Backup. What might be causing it to behave this way?
> Thanks in advance.
|||We are seeing this too. The only change we have done recently is applying
SLQ Server Cum 6 for SP2. Management Studio hangs when we attempt to restore
from a device. Specifically, it hangs when we click "Add" on the Specify
Backup dialog. We have no problems using the "From Database" option, so I do
not believe it has anything to do with MSDB indexes.
"ronnie" wrote:

> Hi,
> I have a production server which has about six user databases. Recently,
> when I try to do a restore ( I wanted to see the available backup sets) on
> any of the databases using Enterprise Manager (All Tasks -> Restore) it
> hangs. However, it promptly brings a pop up window when I do the All Tasks ->
> Backup. What might be causing it to behave this way?
> Thanks in advance.
|||I have narrowed this down to the command "insert #avmed exec
master.dbo.xp_availablemedia", which is what is hanging. I ran "exec
master.dbo.xp_availablemedia" stand alone, and it hangs. This is calling DLL
xpStar90.dll. Has anyone ever seen what might cause this?
"Brent" wrote:
[vbcol=seagreen]
> We are seeing this too. The only change we have done recently is applying
> SLQ Server Cum 6 for SP2. Management Studio hangs when we attempt to restore
> from a device. Specifically, it hangs when we click "Add" on the Specify
> Backup dialog. We have no problems using the "From Database" option, so I do
> not believe it has anything to do with MSDB indexes.
> "ronnie" wrote:
|||Restarting the server resolved this.
"Brent" wrote:
[vbcol=seagreen]
> I have narrowed this down to the command "insert #avmed exec
> master.dbo.xp_availablemedia", which is what is hanging. I ran "exec
> master.dbo.xp_availablemedia" stand alone, and it hangs. This is calling DLL
> xpStar90.dll. Has anyone ever seen what might cause this?
> "Brent" wrote:
|||I tried deleting the backuphistory but it didn't work. Maybe I need to
restart the server.
"Brent" wrote:
[vbcol=seagreen]
> Restarting the server resolved this.
> "Brent" wrote:
|||Our SQL Instance is clustered, so we failed over to the other node and
everything is fine. As soon as we restarted the node where things were
hanging, we started getting alerts on that the C drive is going bad. I think
this is why it was having trouble calling the dll. You may have a similar
issue. Are you using any monitoring tools like Sitescope to monitor the
hardware? You may have a drive that is going bad.
"ronnie" wrote:
[vbcol=seagreen]
> I tried deleting the backuphistory but it didn't work. Maybe I need to
> restart the server.
> "Brent" wrote: