Enterprise Manager Databases

When I try to look at my databases in Enterprise Manager it says (no items)
under the databases heading. I have tried re-registering the server and I
have tried it on several systems including from the server. I am connecting
with administrative access to the server.
The databases seem fine, I can see them all through query analyser and
through a web interface.
Anyone out there know how to get my database list back?
Thanksdo you see any kind of error in the errorlog such as exceptions? If so,
did you remove guest account, there might be a problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
Yih-Yoon Lee
My blog http://www.mssql-tools.com/blog
E-mail: yihyoon.online@.gmail.com
/* remove .online to send me e-mail */
Dirk Marshall wrote:
> When I try to look at my databases in Enterprise Manager it says (no items)
> under the databases heading. I have tried re-registering the server and I
> have tried it on several systems including from the server. I am connecting
> with administrative access to the server.
> The databases seem fine, I can see them all through query analyser and
> through a web interface.
> Anyone out there know how to get my database list back?
> Thanks|||I have a similar issue. I'm not getting any errors...the databases, jobs
are not showing up either on my Enterpise Manager on my laptop or on the
server itself. However, I can see them in Query Analyizer, BUT when I try to
edit a stored proc, I get some wierd error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
data type smallint, value = 32867.
[Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
data type smallint, value = 32867.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
terminated.
Bummer...
"Yih-Yoon Lee" wrote:
> do you see any kind of error in the errorlog such as exceptions? If so,
> did you remove guest account, there might be a problem.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
> Yih-Yoon Lee
> My blog http://www.mssql-tools.com/blog
> E-mail: yihyoon.online@.gmail.com
> /* remove .online to send me e-mail */
> Dirk Marshall wrote:
> > When I try to look at my databases in Enterprise Manager it says (no items)
> > under the databases heading. I have tried re-registering the server and I
> > have tried it on several systems including from the server. I am connecting
> > with administrative access to the server.
> >
> > The databases seem fine, I can see them all through query analyser and
> > through a web interface.
> >
> > Anyone out there know how to get my database list back?
> >
> > Thanks
>|||I get the same thing as well. Only change I made recently was the install
some recent MS security patches, but none that related to SQL server. Have
you found out anything new on this?
"TheMuffinMan" wrote:
> I have a similar issue. I'm not getting any errors...the databases, jobs
> are not showing up either on my Enterpise Manager on my laptop or on the
> server itself. However, I can see them in Query Analyizer, BUT when I try to
> edit a stored proc, I get some wierd error:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> data type smallint, value = 32867.
> [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> data type smallint, value = 32867.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> terminated.
> Bummer...
> "Yih-Yoon Lee" wrote:
> > do you see any kind of error in the errorlog such as exceptions? If so,
> > did you remove guest account, there might be a problem.
> >
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
> >
> > Yih-Yoon Lee
> > My blog http://www.mssql-tools.com/blog
> > E-mail: yihyoon.online@.gmail.com
> > /* remove .online to send me e-mail */
> >
> > Dirk Marshall wrote:
> > > When I try to look at my databases in Enterprise Manager it says (no items)
> > > under the databases heading. I have tried re-registering the server and I
> > > have tried it on several systems including from the server. I am connecting
> > > with administrative access to the server.
> > >
> > > The databases seem fine, I can see them all through query analyser and
> > > through a web interface.
> > >
> > > Anyone out there know how to get my database list back?
> > >
> > > Thanks
> >|||I am also getting this same exact thing. Please tell me if you have found
any resolution to this. I looked at the KB article mentioned about and it
does not look like the GUEST or DBO accounts have been removed from any of
the databases. I am at a loss. thanks for any help...
"Daniel@.tamc" wrote:
> I get the same thing as well. Only change I made recently was the install
> some recent MS security patches, but none that related to SQL server. Have
> you found out anything new on this?
> "TheMuffinMan" wrote:
> > I have a similar issue. I'm not getting any errors...the databases, jobs
> > are not showing up either on my Enterpise Manager on my laptop or on the
> > server itself. However, I can see them in Query Analyizer, BUT when I try to
> > edit a stored proc, I get some wierd error:
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > data type smallint, value = 32867.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > data type smallint, value = 32867.
> > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> > terminated.
> >
> > Bummer...
> >
> > "Yih-Yoon Lee" wrote:
> >
> > > do you see any kind of error in the errorlog such as exceptions? If so,
> > > did you remove guest account, there might be a problem.
> > >
> > > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
> > >
> > > Yih-Yoon Lee
> > > My blog http://www.mssql-tools.com/blog
> > > E-mail: yihyoon.online@.gmail.com
> > > /* remove .online to send me e-mail */
> > >
> > > Dirk Marshall wrote:
> > > > When I try to look at my databases in Enterprise Manager it says (no items)
> > > > under the databases heading. I have tried re-registering the server and I
> > > > have tried it on several systems including from the server. I am connecting
> > > > with administrative access to the server.
> > > >
> > > > The databases seem fine, I can see them all through query analyser and
> > > > through a web interface.
> > > >
> > > > Anyone out there know how to get my database list back?
> > > >
> > > > Thanks
> > >|||This the response I got from TheMuffinMan:
Yes, Daniel...what happens is you have an offline database and it somehow
got the ID changed on it. You can make it "Online", or remove it via
query...or run an update on the sysdatabases table. I forgot the exact
command, so let me try to find it. Until then, try to run with the above and
let me know.
I used Query Analyzer to delete the offline databases, then everything came
back.
Hope that helps,
-Daniel
"KZeeh" wrote:
> I am also getting this same exact thing. Please tell me if you have found
> any resolution to this. I looked at the KB article mentioned about and it
> does not look like the GUEST or DBO accounts have been removed from any of
> the databases. I am at a loss. thanks for any help...
> "Daniel@.tamc" wrote:
> > I get the same thing as well. Only change I made recently was the install
> > some recent MS security patches, but none that related to SQL server. Have
> > you found out anything new on this?
> >
> > "TheMuffinMan" wrote:
> >
> > > I have a similar issue. I'm not getting any errors...the databases, jobs
> > > are not showing up either on my Enterpise Manager on my laptop or on the
> > > server itself. However, I can see them in Query Analyizer, BUT when I try to
> > > edit a stored proc, I get some wierd error:
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > > data type smallint, value = 32867.
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > > data type smallint, value = 32867.
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> > > terminated.
> > >
> > > Bummer...
> > >
> > > "Yih-Yoon Lee" wrote:
> > >
> > > > do you see any kind of error in the errorlog such as exceptions? If so,
> > > > did you remove guest account, there might be a problem.
> > > >
> > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
> > > >
> > > > Yih-Yoon Lee
> > > > My blog http://www.mssql-tools.com/blog
> > > > E-mail: yihyoon.online@.gmail.com
> > > > /* remove .online to send me e-mail */
> > > >
> > > > Dirk Marshall wrote:
> > > > > When I try to look at my databases in Enterprise Manager it says (no items)
> > > > > under the databases heading. I have tried re-registering the server and I
> > > > > have tried it on several systems including from the server. I am connecting
> > > > > with administrative access to the server.
> > > > >
> > > > > The databases seem fine, I can see them all through query analyser and
> > > > > through a web interface.
> > > > >
> > > > > Anyone out there know how to get my database list back?
> > > > >
> > > > > Thanks
> > > >|||OK, but how do I determine if a database is offline? I don't know where to
see that. Thanks.
"Daniel@.tamc" wrote:
> This the response I got from TheMuffinMan:
> Yes, Daniel...what happens is you have an offline database and it somehow
> got the ID changed on it. You can make it "Online", or remove it via
> query...or run an update on the sysdatabases table. I forgot the exact
> command, so let me try to find it. Until then, try to run with the above and
> let me know.
> I used Query Analyzer to delete the offline databases, then everything came
> back.
> Hope that helps,
> -Daniel
> "KZeeh" wrote:
> > I am also getting this same exact thing. Please tell me if you have found
> > any resolution to this. I looked at the KB article mentioned about and it
> > does not look like the GUEST or DBO accounts have been removed from any of
> > the databases. I am at a loss. thanks for any help...
> >
> > "Daniel@.tamc" wrote:
> >
> > > I get the same thing as well. Only change I made recently was the install
> > > some recent MS security patches, but none that related to SQL server. Have
> > > you found out anything new on this?
> > >
> > > "TheMuffinMan" wrote:
> > >
> > > > I have a similar issue. I'm not getting any errors...the databases, jobs
> > > > are not showing up either on my Enterpise Manager on my laptop or on the
> > > > server itself. However, I can see them in Query Analyizer, BUT when I try to
> > > > edit a stored proc, I get some wierd error:
> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > > > data type smallint, value = 32867.
> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > > > data type smallint, value = 32867.
> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> > > > terminated.
> > > >
> > > > Bummer...
> > > >
> > > > "Yih-Yoon Lee" wrote:
> > > >
> > > > > do you see any kind of error in the errorlog such as exceptions? If so,
> > > > > did you remove guest account, there might be a problem.
> > > > >
> > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
> > > > >
> > > > > Yih-Yoon Lee
> > > > > My blog http://www.mssql-tools.com/blog
> > > > > E-mail: yihyoon.online@.gmail.com
> > > > > /* remove .online to send me e-mail */
> > > > >
> > > > > Dirk Marshall wrote:
> > > > > > When I try to look at my databases in Enterprise Manager it says (no items)
> > > > > > under the databases heading. I have tried re-registering the server and I
> > > > > > have tried it on several systems including from the server. I am connecting
> > > > > > with administrative access to the server.
> > > > > >
> > > > > > The databases seem fine, I can see them all through query analyser and
> > > > > > through a web interface.
> > > > > >
> > > > > > Anyone out there know how to get my database list back?
> > > > > >
> > > > > > Thanks
> > > > >|||I used query analyzer to query MASTER database, sysdatabases table.
See this for more info:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-d_5xrn.asp
Status field bits=512 indicates offline.
"KZeeh" wrote:
> OK, but how do I determine if a database is offline? I don't know where to
> see that. Thanks.
> "Daniel@.tamc" wrote:
> > This the response I got from TheMuffinMan:
> > Yes, Daniel...what happens is you have an offline database and it somehow
> > got the ID changed on it. You can make it "Online", or remove it via
> > query...or run an update on the sysdatabases table. I forgot the exact
> > command, so let me try to find it. Until then, try to run with the above and
> > let me know.
> >
> > I used Query Analyzer to delete the offline databases, then everything came
> > back.
> > Hope that helps,
> > -Daniel
> >
> > "KZeeh" wrote:
> >
> > > I am also getting this same exact thing. Please tell me if you have found
> > > any resolution to this. I looked at the KB article mentioned about and it
> > > does not look like the GUEST or DBO accounts have been removed from any of
> > > the databases. I am at a loss. thanks for any help...
> > >
> > > "Daniel@.tamc" wrote:
> > >
> > > > I get the same thing as well. Only change I made recently was the install
> > > > some recent MS security patches, but none that related to SQL server. Have
> > > > you found out anything new on this?
> > > >
> > > > "TheMuffinMan" wrote:
> > > >
> > > > > I have a similar issue. I'm not getting any errors...the databases, jobs
> > > > > are not showing up either on my Enterpise Manager on my laptop or on the
> > > > > server itself. However, I can see them in Query Analyizer, BUT when I try to
> > > > > edit a stored proc, I get some wierd error:
> > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > > > > data type smallint, value = 32867.
> > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > > > > data type smallint, value = 32867.
> > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> > > > > terminated.
> > > > >
> > > > > Bummer...
> > > > >
> > > > > "Yih-Yoon Lee" wrote:
> > > > >
> > > > > > do you see any kind of error in the errorlog such as exceptions? If so,
> > > > > > did you remove guest account, there might be a problem.
> > > > > >
> > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
> > > > > >
> > > > > > Yih-Yoon Lee
> > > > > > My blog http://www.mssql-tools.com/blog
> > > > > > E-mail: yihyoon.online@.gmail.com
> > > > > > /* remove .online to send me e-mail */
> > > > > >
> > > > > > Dirk Marshall wrote:
> > > > > > > When I try to look at my databases in Enterprise Manager it says (no items)
> > > > > > > under the databases heading. I have tried re-registering the server and I
> > > > > > > have tried it on several systems including from the server. I am connecting
> > > > > > > with administrative access to the server.
> > > > > > >
> > > > > > > The databases seem fine, I can see them all through query analyser and
> > > > > > > through a web interface.
> > > > > > >
> > > > > > > Anyone out there know how to get my database list back?
> > > > > > >
> > > > > > > Thanks
> > > > > >|||Of course, none of mine have a status of 512, it is a combination of bits.
I've got a lot of 1552's, which I think is 1024(readonly) + 512(offline) +
16(torn page detection). Then I also have a lot of 28s too. I am just not
sure what to "reset" these numbers to. Is there a more comprehensive list
anywhere about resetting the status? Thanks so much for helping me out with
this. I couldn't find any info anywhere on this...
"Daniel@.tamc" wrote:
> I used query analyzer to query MASTER database, sysdatabases table.
> See this for more info:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-d_5xrn.asp
> Status field bits=512 indicates offline.
> "KZeeh" wrote:
> > OK, but how do I determine if a database is offline? I don't know where to
> > see that. Thanks.
> >
> > "Daniel@.tamc" wrote:
> >
> > > This the response I got from TheMuffinMan:
> > > Yes, Daniel...what happens is you have an offline database and it somehow
> > > got the ID changed on it. You can make it "Online", or remove it via
> > > query...or run an update on the sysdatabases table. I forgot the exact
> > > command, so let me try to find it. Until then, try to run with the above and
> > > let me know.
> > >
> > > I used Query Analyzer to delete the offline databases, then everything came
> > > back.
> > > Hope that helps,
> > > -Daniel
> > >
> > > "KZeeh" wrote:
> > >
> > > > I am also getting this same exact thing. Please tell me if you have found
> > > > any resolution to this. I looked at the KB article mentioned about and it
> > > > does not look like the GUEST or DBO accounts have been removed from any of
> > > > the databases. I am at a loss. thanks for any help...
> > > >
> > > > "Daniel@.tamc" wrote:
> > > >
> > > > > I get the same thing as well. Only change I made recently was the install
> > > > > some recent MS security patches, but none that related to SQL server. Have
> > > > > you found out anything new on this?
> > > > >
> > > > > "TheMuffinMan" wrote:
> > > > >
> > > > > > I have a similar issue. I'm not getting any errors...the databases, jobs
> > > > > > are not showing up either on my Enterpise Manager on my laptop or on the
> > > > > > server itself. However, I can see them in Query Analyizer, BUT when I try to
> > > > > > edit a stored proc, I get some wierd error:
> > > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > > > > > data type smallint, value = 32867.
> > > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> > > > > > data type smallint, value = 32867.
> > > > > > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> > > > > > terminated.
> > > > > >
> > > > > > Bummer...
> > > > > >
> > > > > > "Yih-Yoon Lee" wrote:
> > > > > >
> > > > > > > do you see any kind of error in the errorlog such as exceptions? If so,
> > > > > > > did you remove guest account, there might be a problem.
> > > > > > >
> > > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
> > > > > > >
> > > > > > > Yih-Yoon Lee
> > > > > > > My blog http://www.mssql-tools.com/blog
> > > > > > > E-mail: yihyoon.online@.gmail.com
> > > > > > > /* remove .online to send me e-mail */
> > > > > > >
> > > > > > > Dirk Marshall wrote:
> > > > > > > > When I try to look at my databases in Enterprise Manager it says (no items)
> > > > > > > > under the databases heading. I have tried re-registering the server and I
> > > > > > > > have tried it on several systems including from the server. I am connecting
> > > > > > > > with administrative access to the server.
> > > > > > > >
> > > > > > > > The databases seem fine, I can see them all through query analyser and
> > > > > > > > through a web interface.
> > > > > > > >
> > > > > > > > Anyone out there know how to get my database list back?
> > > > > > > >
> > > > > > > > Thanks
> > > > > > >|||SELECT name, DATABASEPROPERTY(name, 'IsOffLine') AS OffLine
FROM sysdatabases
1 means offline.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"KZeeh" <KZeeh@.discussions.microsoft.com> wrote in message
news:727DEAE3-1F12-4A71-A12B-BA38908CA919@.microsoft.com...
> OK, but how do I determine if a database is offline? I don't know where to
> see that. Thanks.
> "Daniel@.tamc" wrote:
>> This the response I got from TheMuffinMan:
>> Yes, Daniel...what happens is you have an offline database and it somehow
>> got the ID changed on it. You can make it "Online", or remove it via
>> query...or run an update on the sysdatabases table. I forgot the exact
>> command, so let me try to find it. Until then, try to run with the above and
>> let me know.
>> I used Query Analyzer to delete the offline databases, then everything came
>> back.
>> Hope that helps,
>> -Daniel
>> "KZeeh" wrote:
>> > I am also getting this same exact thing. Please tell me if you have found
>> > any resolution to this. I looked at the KB article mentioned about and it
>> > does not look like the GUEST or DBO accounts have been removed from any of
>> > the databases. I am at a loss. thanks for any help...
>> >
>> > "Daniel@.tamc" wrote:
>> >
>> > > I get the same thing as well. Only change I made recently was the install
>> > > some recent MS security patches, but none that related to SQL server. Have
>> > > you found out anything new on this?
>> > >
>> > > "TheMuffinMan" wrote:
>> > >
>> > > > I have a similar issue. I'm not getting any errors...the databases, jobs
>> > > > are not showing up either on my Enterpise Manager on my laptop or on the
>> > > > server itself. However, I can see them in Query Analyizer, BUT when I try to
>> > > > edit a stored proc, I get some wierd error:
>> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
>> > > > data type smallint, value = 32867.
>> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
>> > > > data type smallint, value = 32867.
>> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
>> > > > terminated.
>> > > >
>> > > > Bummer...
>> > > >
>> > > > "Yih-Yoon Lee" wrote:
>> > > >
>> > > > > do you see any kind of error in the errorlog such as exceptions? If so,
>> > > > > did you remove guest account, there might be a problem.
>> > > > >
>> > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
>> > > > >
>> > > > > Yih-Yoon Lee
>> > > > > My blog http://www.mssql-tools.com/blog
>> > > > > E-mail: yihyoon.online@.gmail.com
>> > > > > /* remove .online to send me e-mail */
>> > > > >
>> > > > > Dirk Marshall wrote:
>> > > > > > When I try to look at my databases in Enterprise Manager it says (no items)
>> > > > > > under the databases heading. I have tried re-registering the server and I
>> > > > > > have tried it on several systems including from the server. I am connecting
>> > > > > > with administrative access to the server.
>> > > > > >
>> > > > > > The databases seem fine, I can see them all through query analyser and
>> > > > > > through a web interface.
>> > > > > >
>> > > > > > Anyone out there know how to get my database list back?
>> > > > > >
>> > > > > > Thanks
>> > > > >|||OK, great. I ran that query and see that some of them are status=1, which
means they are offline. Can I just update the table and put them back
online' I am not the DBA, but no one seemed to be troubleshooting the
problem, so I decided to look into it. What are the ramifications if I do
this? Thanks for any help. I just want to determine if this is truly the
problem.
"Tibor Karaszi" wrote:
> SELECT name, DATABASEPROPERTY(name, 'IsOffLine') AS OffLine
> FROM sysdatabases
> 1 means offline.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
> "KZeeh" <KZeeh@.discussions.microsoft.com> wrote in message
> news:727DEAE3-1F12-4A71-A12B-BA38908CA919@.microsoft.com...
> > OK, but how do I determine if a database is offline? I don't know where to
> > see that. Thanks.
> >
> > "Daniel@.tamc" wrote:
> >
> >> This the response I got from TheMuffinMan:
> >> Yes, Daniel...what happens is you have an offline database and it somehow
> >> got the ID changed on it. You can make it "Online", or remove it via
> >> query...or run an update on the sysdatabases table. I forgot the exact
> >> command, so let me try to find it. Until then, try to run with the above and
> >> let me know.
> >>
> >> I used Query Analyzer to delete the offline databases, then everything came
> >> back.
> >> Hope that helps,
> >> -Daniel
> >>
> >> "KZeeh" wrote:
> >>
> >> > I am also getting this same exact thing. Please tell me if you have found
> >> > any resolution to this. I looked at the KB article mentioned about and it
> >> > does not look like the GUEST or DBO accounts have been removed from any of
> >> > the databases. I am at a loss. thanks for any help...
> >> >
> >> > "Daniel@.tamc" wrote:
> >> >
> >> > > I get the same thing as well. Only change I made recently was the install
> >> > > some recent MS security patches, but none that related to SQL server. Have
> >> > > you found out anything new on this?
> >> > >
> >> > > "TheMuffinMan" wrote:
> >> > >
> >> > > > I have a similar issue. I'm not getting any errors...the databases, jobs
> >> > > > are not showing up either on my Enterpise Manager on my laptop or on the
> >> > > > server itself. However, I can see them in Query Analyizer, BUT when I try to
> >> > > > edit a stored proc, I get some wierd error:
> >> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> >> > > > data type smallint, value = 32867.
> >> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
> >> > > > data type smallint, value = 32867.
> >> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
> >> > > > terminated.
> >> > > >
> >> > > > Bummer...
> >> > > >
> >> > > > "Yih-Yoon Lee" wrote:
> >> > > >
> >> > > > > do you see any kind of error in the errorlog such as exceptions? If so,
> >> > > > > did you remove guest account, there might be a problem.
> >> > > > >
> >> > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
> >> > > > >
> >> > > > > Yih-Yoon Lee
> >> > > > > My blog http://www.mssql-tools.com/blog
> >> > > > > E-mail: yihyoon.online@.gmail.com
> >> > > > > /* remove .online to send me e-mail */
> >> > > > >
> >> > > > > Dirk Marshall wrote:
> >> > > > > > When I try to look at my databases in Enterprise Manager it says (no items)
> >> > > > > > under the databases heading. I have tried re-registering the server and I
> >> > > > > > have tried it on several systems including from the server. I am connecting
> >> > > > > > with administrative access to the server.
> >> > > > > >
> >> > > > > > The databases seem fine, I can see them all through query analyser and
> >> > > > > > through a web interface.
> >> > > > > >
> >> > > > > > Anyone out there know how to get my database list back?
> >> > > > > >
> >> > > > > > Thanks
> >> > > > >
>
>|||> OK, great. I ran that query and see that some of them are status=1, which
> means they are offline. Can I just update the table and put them back
> online'
No, for each database which is offline, you need to execute a statement to bring it online.
ALTER DATABASE dbname SET ONLINE
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KZeeh" <KZeeh@.discussions.microsoft.com> wrote in message
news:165F8B69-7E7D-4135-B265-77F5A4233E78@.microsoft.com...
> OK, great. I ran that query and see that some of them are status=1, which
> means they are offline. Can I just update the table and put them back
> online' I am not the DBA, but no one seemed to be troubleshooting the
> problem, so I decided to look into it. What are the ramifications if I do
> this? Thanks for any help. I just want to determine if this is truly the
> problem.
> "Tibor Karaszi" wrote:
>> SELECT name, DATABASEPROPERTY(name, 'IsOffLine') AS OffLine
>> FROM sysdatabases
>> 1 means offline.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> http://www.sqlug.se/
>>
>> "KZeeh" <KZeeh@.discussions.microsoft.com> wrote in message
>> news:727DEAE3-1F12-4A71-A12B-BA38908CA919@.microsoft.com...
>> > OK, but how do I determine if a database is offline? I don't know where to
>> > see that. Thanks.
>> >
>> > "Daniel@.tamc" wrote:
>> >
>> >> This the response I got from TheMuffinMan:
>> >> Yes, Daniel...what happens is you have an offline database and it somehow
>> >> got the ID changed on it. You can make it "Online", or remove it via
>> >> query...or run an update on the sysdatabases table. I forgot the exact
>> >> command, so let me try to find it. Until then, try to run with the above and
>> >> let me know.
>> >>
>> >> I used Query Analyzer to delete the offline databases, then everything came
>> >> back.
>> >> Hope that helps,
>> >> -Daniel
>> >>
>> >> "KZeeh" wrote:
>> >>
>> >> > I am also getting this same exact thing. Please tell me if you have found
>> >> > any resolution to this. I looked at the KB article mentioned about and it
>> >> > does not look like the GUEST or DBO accounts have been removed from any of
>> >> > the databases. I am at a loss. thanks for any help...
>> >> >
>> >> > "Daniel@.tamc" wrote:
>> >> >
>> >> > > I get the same thing as well. Only change I made recently was the install
>> >> > > some recent MS security patches, but none that related to SQL server. Have
>> >> > > you found out anything new on this?
>> >> > >
>> >> > > "TheMuffinMan" wrote:
>> >> > >
>> >> > > > I have a similar issue. I'm not getting any errors...the databases, jobs
>> >> > > > are not showing up either on my Enterpise Manager on my laptop or on the
>> >> > > > server itself. However, I can see them in Query Analyizer, BUT when I try to
>> >> > > > edit a stored proc, I get some wierd error:
>> >> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
>> >> > > > data type smallint, value = 32867.
>> >> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for
>> >> > > > data type smallint, value = 32867.
>> >> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been
>> >> > > > terminated.
>> >> > > >
>> >> > > > Bummer...
>> >> > > >
>> >> > > > "Yih-Yoon Lee" wrote:
>> >> > > >
>> >> > > > > do you see any kind of error in the errorlog such as exceptions? If so,
>> >> > > > > did you remove guest account, there might be a problem.
>> >> > > > >
>> >> > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;315523
>> >> > > > >
>> >> > > > > Yih-Yoon Lee
>> >> > > > > My blog http://www.mssql-tools.com/blog
>> >> > > > > E-mail: yihyoon.online@.gmail.com
>> >> > > > > /* remove .online to send me e-mail */
>> >> > > > >
>> >> > > > > Dirk Marshall wrote:
>> >> > > > > > When I try to look at my databases in Enterprise Manager it says (no items)
>> >> > > > > > under the databases heading. I have tried re-registering the server and I
>> >> > > > > > have tried it on several systems including from the server. I am connecting
>> >> > > > > > with administrative access to the server.
>> >> > > > > >
>> >> > > > > > The databases seem fine, I can see them all through query analyser and
>> >> > > > > > through a web interface.
>> >> > > > > >
>> >> > > > > > Anyone out there know how to get my database list back?
>> >> > > > > >
>> >> > > > > > Thanks
>> >> > > > >
>>|||Press CTRL + refresh (like in IE)
It works for me. Hope it helps. :)
Herman
"Dirk Marshall" wrote:
> When I try to look at my databases in Enterprise Manager it says (no items)
> under the databases heading. I have tried re-registering the server and I
> have tried it on several systems including from the server. I am connecting
> with administrative access to the server.
> The databases seem fine, I can see them all through query analyser and
> through a web interface.
> Anyone out there know how to get my database list back?
> Thanks