Cannot view databases in view list for SQL 2005

I have created a couple of new logons/ users and they are dbo's of a few
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
Mark
Hi Mark
"Mark Broadbent" wrote:

> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databases
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQL
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John

Cannot view databases in view list for SQL 2005

I have created a couple of new logons/ users and they are dbo's of a few
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
MarkHi Mark
"Mark Broadbent" wrote:

> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databas
es
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQ
L
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John

Cannot view databases in view list for SQL 2005

I have created a couple of new logons/ users and they are dbo's of a few
databases. However it has become apparent that for some reason the databases
are not "browseable" through the SSMS dropdown. Even running sp_databases
does not return their names. The databases can be accessed through text
(e.g. USE dbname) and do look like full access is available.
What on earth is going on? The only difference between this and another
(working) box is that this non-working one is 64 bit windows with 64bit SQL
(x64) wheras the other is 32 bit on 32 bit. I know this because they both
use automated builds which I created.
Regards,
MarkHi Mark
"Mark Broadbent" wrote:
> I have created a couple of new logons/ users and they are dbo's of a few
> databases. However it has become apparent that for some reason the databases
> are not "browseable" through the SSMS dropdown. Even running sp_databases
> does not return their names. The databases can be accessed through text
> (e.g. USE dbname) and do look like full access is available.
> What on earth is going on? The only difference between this and another
> (working) box is that this non-working one is 64 bit windows with 64bit SQL
> (x64) wheras the other is 32 bit on 32 bit. I know this because they both
> use automated builds which I created.
> Regards,
> Mark
I assume by dropdown you mean the Object Browser (F8).
Have you changed the permissions for these users at all since they created
the databases?
From BOL:
sp_databases requires CREATE DATABASE, or ALTER ANY DATABASE, or VIEW ANY
DEFINITION permission, and must have access permission to the database.
Cannot be denied VIEW ANY DEFINITION permission.
John

Cannot ROLLBACK in a distributed transaction!

What to do about it? It happens while running a procedure we wrote. We've got a couple of tables with data in. It's possible to copy data from that table and duplicate it (except for his primary key offcourse, thats a new number we get from a sequence).
Any help is welcome ...By the very definition of the word "transaction" you should be able to either commit or rollback them, regardless of the fact that you are working in a heterogenous environment. What exactly is the problem, error message, platforms, etc...|||Hi,

This is because the operation may not have rolled back all effects of the operation. Since some sites may be inconsistent with others, the transaction must roll back to a savepoint or roll back entirely.|||HI,

You either Roll back to a savepoint or roll back the entire transaction and resubmit the rolled-back statements.|||ODBC Error Code = S1000 (General error)

[Oracle][ODBC][Ora]ORA-02074: cannot ROLLBACK in a distributed transaction ORA-06512: at "***.COPY_CURS_TOT_TO_NEW", line 460 ORA-00911: invalid character ORA-06512: at line 1

The error occurred while processing an element with a general identifier of (CFSTOREDPROC), occupying document position (287:2) to (287:76).

That's the error ... I just don't see it ... this is the error message of the coldfusion server I'm working with, the procedure doesn't give errors itself. I putted it in SQL*Plus and all I had was 'Procedure is aangemaakt' -> Dutch for 'Procedure created'

In Oracle DBA Studio the status of the procedure is 'VALID', so ... dunno.

Any help is welcome!|||Well, sounds no good

ORA-02074 cannot string in a distributed transaction
------------------
Cause: A commit or rollback was attempted from session other than the parent of a distributed transaction.

Action: Only commit or roll back from the parent session.

I will see if I can get my hands on some more info about the workings of Two-Phase commit. Maybe you can check the Oracle web-site for more details.

Cannot restore database

I have a couple of sql servers 2000 enterprise edition, that are giving me
trouble when I want to restore some databases. The server reports that the
database is in use but when I check using sp_who the specific databases are
not in use. The problem is solved when the server is stopped and restrated,
but I cannot imagine that this is the solution.
One server is an enterprise edition sp3
the other is a virtual server part of a win2000 cluster also sp3.
any ideas?
Thanks.
Ahmad El-Kays
Systems Developer
Maritz Canada Inc.
elkaysaz@.maritz.com
aelkays@.hotmail.comHow are you performing the restore? Via Query Analyzer or
Enterprise Manager?
In QA, make sure that you are not in the database your are
trying to restore. This is seen by the pull down menu. You
should choose to be in the master database.
In EM, do not select the database you are restoring. You
can right click on 'database' without expanding the tree
or expand the tree and right click on the master database
and choose to do the restore.
HTH
DeeJay
>--Original Message--
>I have a couple of sql servers 2000 enterprise edition,
that are giving me
>trouble when I want to restore some databases. The server
reports that the
>database is in use but when I check using sp_who the
specific databases are
>not in use. The problem is solved when the server is
stopped and restrated,
>but I cannot imagine that this is the solution.
>One server is an enterprise edition sp3
>the other is a virtual server part of a win2000 cluster
also sp3.
>any ideas?
>Thanks.
>
>Ahmad El-Kays
>Systems Developer
>Maritz Canada Inc.
>elkaysaz@.maritz.com
>aelkays@.hotmail.com
>
>.
>|||This is not the case. The database is not used at all. when sp_who is run
the database does not show up in the list at all. and YES the restore is
done in QA in the master db!
"DeeJay Puar" <deejaypuar@.yahoo.com> wrote in message
news:0dad01c368bc$d3b0b720$a301280a@.phx.gbl...
> How are you performing the restore? Via Query Analyzer or
> Enterprise Manager?
> In QA, make sure that you are not in the database your are
> trying to restore. This is seen by the pull down menu. You
> should choose to be in the master database.
> In EM, do not select the database you are restoring. You
> can right click on 'database' without expanding the tree
> or expand the tree and right click on the master database
> and choose to do the restore.
> HTH
> DeeJay
> >--Original Message--
> >I have a couple of sql servers 2000 enterprise edition,
> that are giving me
> >trouble when I want to restore some databases. The server
> reports that the
> >database is in use but when I check using sp_who the
> specific databases are
> >not in use. The problem is solved when the server is
> stopped and restrated,
> >but I cannot imagine that this is the solution.
> >
> >One server is an enterprise edition sp3
> >the other is a virtual server part of a win2000 cluster
> also sp3.
> >
> >any ideas?
> >
> >Thanks.
> >
> >
> >Ahmad El-Kays
> >Systems Developer
> >Maritz Canada Inc.
> >elkaysaz@.maritz.com
> >aelkays@.hotmail.com
> >
> >
> >.
> >