Re: Enterprise Manager Databases

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: TheMuffinMan (richard_at_.diespamdie.theferraras.net)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 15:17:07 -0800

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
>

Quantcast