The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
Showing posts with label showing. Show all posts
Showing posts with label showing. Show all posts
Monday, March 26, 2012
Entire 2005 Database deleted
The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.
Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.
Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
Entire 2005 Database deleted
The Database Name is showing up but there are 0 items contained in it. ldf
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
and mdf files deleted. Not deleted by Users. Event log shows a problem
reading a backup tape.Hi
Refresh SSMS anf the database will probably gone. Do you have a backup of
the database?
"CF" <CF@.discussions.microsoft.com> wrote in message
news:DDE9AD7E-FA19-403E-BE39-21AAD41726E7@.microsoft.com...
> The Database Name is showing up but there are 0 items contained in it.
> ldf
> and mdf files deleted. Not deleted by Users. Event log shows a problem
> reading a backup tape.
Thursday, March 22, 2012
Enterprise Mgr Not showing Table permissions Correctly
After moving DB's to a new server, the public role was
removed on some, but not all of the tables. We tried
setting the permissions to public in EM but although it
correctly sets it, it does not appear to be set. So now
by using EM I can't tell which tables have the correct
permissions. Has anybody seen this problem where EM does
not correctly show the permissions? Does anyone know how
to resolve this? Also, can anyone show me a way to set
public permissions on all tables through QA?
ThanksYes, I've seen it before. It seems to be some disconnect between
syspermissions and sysprotects. I thought that a way to resolve it might be
to create a new database and copy the user tables into it and grant
permissions in the new database. However, I never got around to doing this.
Public is a role, what permissions would you want to grant to public? Select
to all tables?
GRANT SELECT
ON authors -- you could use a cursor here
TO public
Or, if you have your users already in a group, you could just add that group
to the db_datareader role (if you want everyone to have select).
<paul.j@.aptalaska.com> wrote in message
news:3bcc01c47f14$7f5002c0$a401280a@.phx.gbl...
> After moving DB's to a new server, the public role was
> removed on some, but not all of the tables. We tried
> setting the permissions to public in EM but although it
> correctly sets it, it does not appear to be set. So now
> by using EM I can't tell which tables have the correct
> permissions. Has anybody seen this problem where EM does
> not correctly show the permissions? Does anyone know how
> to resolve this? Also, can anyone show me a way to set
> public permissions on all tables through QA?
> Thankssql
removed on some, but not all of the tables. We tried
setting the permissions to public in EM but although it
correctly sets it, it does not appear to be set. So now
by using EM I can't tell which tables have the correct
permissions. Has anybody seen this problem where EM does
not correctly show the permissions? Does anyone know how
to resolve this? Also, can anyone show me a way to set
public permissions on all tables through QA?
ThanksYes, I've seen it before. It seems to be some disconnect between
syspermissions and sysprotects. I thought that a way to resolve it might be
to create a new database and copy the user tables into it and grant
permissions in the new database. However, I never got around to doing this.
Public is a role, what permissions would you want to grant to public? Select
to all tables?
GRANT SELECT
ON authors -- you could use a cursor here
TO public
Or, if you have your users already in a group, you could just add that group
to the db_datareader role (if you want everyone to have select).
<paul.j@.aptalaska.com> wrote in message
news:3bcc01c47f14$7f5002c0$a401280a@.phx.gbl...
> After moving DB's to a new server, the public role was
> removed on some, but not all of the tables. We tried
> setting the permissions to public in EM but although it
> correctly sets it, it does not appear to be set. So now
> by using EM I can't tell which tables have the correct
> permissions. Has anybody seen this problem where EM does
> not correctly show the permissions? Does anyone know how
> to resolve this? Also, can anyone show me a way to set
> public permissions on all tables through QA?
> Thankssql
Monday, March 19, 2012
Enterprise Manager Showing Wrong Authentication Mechanism
This is strange,
SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
into the server or I look on the console locally, it shows it as only being
Windows Authentication...
Anyone know of this bug? And how to fix?How do you know it's set to mixed mode? Did you try logging
in with a SQL login?
If you are just looking at a registry setting, it's possible
the service was not restarted to allow the server to be set
to mixed mode.
-Sue
On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
<Chuck@.discussions.microsoft.com> wrote:
>This is strange,
>SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
>into the server or I look on the console locally, it shows it as only being
>Windows Authentication...
>Anyone know of this bug? And how to fix?|||Yes, I am currently logging in as an SQL login account. This client of mine
does not use Windows authentication...
"Sue Hoegemeier" wrote:
> How do you know it's set to mixed mode? Did you try logging
> in with a SQL login?
> If you are just looking at a registry setting, it's possible
> the service was not restarted to allow the server to be set
> to mixed mode.
> -Sue
> On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
> <Chuck@.discussions.microsoft.com> wrote:
>
>|||_-=?/today_-=?/354
"Chuck" wrote:
> This is strange,
> SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
> into the server or I look on the console locally, it shows it as only bein
g
> Windows Authentication...
> Anyone know of this bug? And how to fix?|||_-=?/today_-=?/354
"Chuck" wrote:
[vbcol=seagreen]
> Yes, I am currently logging in as an SQL login account. This client of mi
ne
> does not use Windows authentication...
> "Sue Hoegemeier" wrote:
>
SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
into the server or I look on the console locally, it shows it as only being
Windows Authentication...
Anyone know of this bug? And how to fix?How do you know it's set to mixed mode? Did you try logging
in with a SQL login?
If you are just looking at a registry setting, it's possible
the service was not restarted to allow the server to be set
to mixed mode.
-Sue
On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
<Chuck@.discussions.microsoft.com> wrote:
>This is strange,
>SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
>into the server or I look on the console locally, it shows it as only being
>Windows Authentication...
>Anyone know of this bug? And how to fix?|||Yes, I am currently logging in as an SQL login account. This client of mine
does not use Windows authentication...
"Sue Hoegemeier" wrote:
> How do you know it's set to mixed mode? Did you try logging
> in with a SQL login?
> If you are just looking at a registry setting, it's possible
> the service was not restarted to allow the server to be set
> to mixed mode.
> -Sue
> On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
> <Chuck@.discussions.microsoft.com> wrote:
>
>|||_-=?/today_-=?/354
"Chuck" wrote:
> This is strange,
> SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
> into the server or I look on the console locally, it shows it as only bein
g
> Windows Authentication...
> Anyone know of this bug? And how to fix?|||_-=?/today_-=?/354
"Chuck" wrote:
[vbcol=seagreen]
> Yes, I am currently logging in as an SQL login account. This client of mi
ne
> does not use Windows authentication...
> "Sue Hoegemeier" wrote:
>
Sunday, March 11, 2012
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
Sunday, February 19, 2012
enterprise manager - showing all databases
hi,
I was wondering about a way so that only those databases are shown to a user who has access to them and NOT all databases when s/he expands "Databases" node in enterprise manager.
Since it is by design of enterprise manager therefore it is not possible to hide other databases in EM. Is there anyother tool/ wrapper available for the same functionality?
The need for this arises when one wants to access a database on a shared ISP server containing hundreds of databases and due to slowness of link, connection times out.
regards,
Faisal HaroonIF the pertaining user doesn't have any access to those database then they cannot open them.
But its not possible to restrict the user to view the database names using EM.
I feel there are third party tools available, but you need to test before use.|||I haven't tested this recently, but I thought that the default behavior of SQL-EM (Enterprise Mangler) was to show only the databases that the current login can access. More than once I've had users express surprise because my EM shows lots of things that theirs does not.
I'll have to check this!
-PatP|||Never trust GUI tools...:eek:|||Originally posted by Satya
Never trust GUI tools...:eek: Oh heavens, GUI tools are lovely things for end users. I don't generally trust GUI tools as far as I can throw the building that the run in for my own use, but the users do like them!
-PatP
I was wondering about a way so that only those databases are shown to a user who has access to them and NOT all databases when s/he expands "Databases" node in enterprise manager.
Since it is by design of enterprise manager therefore it is not possible to hide other databases in EM. Is there anyother tool/ wrapper available for the same functionality?
The need for this arises when one wants to access a database on a shared ISP server containing hundreds of databases and due to slowness of link, connection times out.
regards,
Faisal HaroonIF the pertaining user doesn't have any access to those database then they cannot open them.
But its not possible to restrict the user to view the database names using EM.
I feel there are third party tools available, but you need to test before use.|||I haven't tested this recently, but I thought that the default behavior of SQL-EM (Enterprise Mangler) was to show only the databases that the current login can access. More than once I've had users express surprise because my EM shows lots of things that theirs does not.
I'll have to check this!
-PatP|||Never trust GUI tools...:eek:|||Originally posted by Satya
Never trust GUI tools...:eek: Oh heavens, GUI tools are lovely things for end users. I don't generally trust GUI tools as far as I can throw the building that the run in for my own use, but the users do like them!
-PatP
Subscribe to:
Posts (Atom)