Enterprise Manager not displaying Bigint's

I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.Hi Russell
Have you service packed this system?
John
"Russell" wrote:
> I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyzer
> it is displayed correctly.|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
> > I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> > Manager, whereby if you do a return all rows on a table that contains a
> > bigint column it show as blank. Yet if you do a select * from query analyzer
> > it is displayed correctly.|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:
> > Hi Russell
> >
> > Have you service packed this system?
> >
> > John
> >
> > "Russell" wrote:
> >
> > > I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> > > Manager, whereby if you do a return all rows on a table that contains a
> > > bigint column it show as blank. Yet if you do a select * from query analyzer
> > > it is displayed correctly.

Enterprise Manager not displaying Bigint's

I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.
Hi Russell
Have you service packed this system?
John
"Russell" wrote:

> I am currently having an issue on one of our pc's here in SQL 2000 Enterprise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyzer
> it is displayed correctly.
|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
[vbcol=seagreen]
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:

Enterprise Manager not displaying Bigint's

I am currently having an issue on one of our pc's here in SQL 2000 Enterpris
e
Manager, whereby if you do a return all rows on a table that contains a
bigint column it show as blank. Yet if you do a select * from query analyzer
it is displayed correctly.Hi Russell
Have you service packed this system?
John
"Russell" wrote:

> I am currently having an issue on one of our pc's here in SQL 2000 Enterpr
ise
> Manager, whereby if you do a return all rows on a table that contains a
> bigint column it show as blank. Yet if you do a select * from query analyz
er
> it is displayed correctly.|||It has SQL 2000 SP3a installed.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Russell
> Have you service packed this system?
> John
> "Russell" wrote:
>|||Hi Russel
Is that both server and client or are they both the same?
What if you look at the given server from a different client and vice versa?
Does this happen if you use the query open for open table?
Have you checked you have the latest graphics driver?
I have no issue on service pack 4!
John
"Russell" wrote:
[vbcol=seagreen]
> It has SQL 2000 SP3a installed.
> "John Bell" wrote:
>

Enterprise Manager is not displaying any database information.

We have SQL 2000 Active/Active 2 node cluster. Yesterdat
we did a memory switch to use more than 2GB RAM after that
Enterprise Manager on one node is not displaying any
database information. All the databases is up its just
Enterprise Manager piece is not working. If I do clink on
new database thru ENterprise Manage It display following
message. Any idea ..
Error 220: Airthmetic overflow error for datatype
smallint, value = 32891Hi Avnish,
Try this:
From Query Analzyer, run this query:
use master
go
select * from sysdatabases
go
Do you get the same error?
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Enterprise Manager field > 900 chars not displaying post SP4

I think this started happening post SP4.
I have an nvarchar(4000) field. If I query the table in Enterprise Manager,
the data for the field only displays in rows where the value is 900 chars or
less. Otherwise, the field looks empty, but when I click in it and type, I
get a popup that says "Cannot edit this field."
I can query the data, so I know it's there, but it's annoying not to see it
in the results.
Has anyone else noticed this?
<Cliff>
Enterprise Manager is not meant to be a data editor. May I suggest that you
use Query Analyzer (and Transact-SQL statements to edit the data)? The
other option is to create a GUI that you can use to edit the data within
your databases.
Keith
"Cliff Morrison" <CliffMorrison@.discussions.microsoft.com> wrote in message
news:3C026C09-A968-466A-B1D0-FAE7EC4EACE5@.microsoft.com...
>I think this started happening post SP4.
> I have an nvarchar(4000) field. If I query the table in Enterprise
> Manager,
> the data for the field only displays in rows where the value is 900 chars
> or
> less. Otherwise, the field looks empty, but when I click in it and type,
> I
> get a popup that says "Cannot edit this field."
> I can query the data, so I know it's there, but it's annoying not to see
> it
> in the results.
> Has anyone else noticed this?
> <Cliff>
|||I'm not really trying to edit. The only reason I did in my example was to
show that something strange was happening with the field.
I do think I should be able to visually verify in Enterprise Manager query
results that data is in a field, regardless of whether that data is less than
or equal to 900 characters in length.
<Cliff>
"Keith Kratochvil" wrote:

> Enterprise Manager is not meant to be a data editor. May I suggest that you
> use Query Analyzer (and Transact-SQL statements to edit the data)? The
> other option is to create a GUI that you can use to edit the data within
> your databases.
> --
> Keith
|||I am having the same problem, except it is happening with text fields and a
char(1024) field. Shorter fields and a varchar(4096) field seem to show up
just fine. EM used to display the data in these fields before I upgraded to
SP4. What is going on?
Rob
"Cliff Morrison" wrote:

> I'm not really trying to edit. The only reason I did in my example was to
> show that something strange was happening with the field.
> I do think I should be able to visually verify in Enterprise Manager query
> results that data is in a field, regardless of whether that data is less than
> or equal to 900 characters in length.
> <Cliff>
> "Keith Kratochvil" wrote:
>
|||Or check out AgileInfoSoftware DataStudio for editing data. You can directly
update table content, and there is no known limit for the length of
character.
John King
http://www.agileinfollc.com
"Rob Drollinger" <RobDrollinger@.discussions.microsoft.com> wrote in message
news:993820FF-C681-4E34-8344-BBC28C8CF008@.microsoft.com...[vbcol=seagreen]
>I am having the same problem, except it is happening with text fields and a
> char(1024) field. Shorter fields and a varchar(4096) field seem to show
> up
> just fine. EM used to display the data in these fields before I upgraded
> to
> SP4. What is going on?
> Rob
>
> "Cliff Morrison" wrote:

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items shown
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
--
Steven FergusonSteven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely to
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.com/sql_server_profiler_tips.asp
Hope this helps
John
"fergusons" wrote:
> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen under
> the Current Activity option in the Management folder there are no items shown
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items shown
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
Steven Ferguson
Steven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely to
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.co...filer_tips.asp
Hope this helps
John
"fergusons" wrote:

> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen under
> the Current Activity option in the Management folder there are no items shown
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items show
n
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
Steven FergusonSteven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely t
o
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.c...ofiler_tips.asp
Hope this helps
John
"fergusons" wrote:

> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen und
er
> the Current Activity option in the Management folder there are no items sh
own
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

Enterprise Manager - Want to display date in different format

Currently I am using Enterprise Manager to see the table content. It is
displaying date in American format but i want to view it as British date.
How can i change the settings so that i can view it differently ?
regards
Manisha"manisha_css" wrote:
> Currently I am using Enterprise Manager to see the table content. It is
> displaying date in American format but i want to view it as British date.
> How can i change the settings so that i can view it differently ?
> regards
> Manisha
Manisha -
Try following Steps :-
1. Go to EM
2. Go to Security --> Logins (Inside EM)
3. Double Click your Login Name.
4. Inside General Tab of Login Window, Change the Language to the desired one.
5. Exit EM & Start a New Instance of EM
6. Right Click Server Name & Edit SQL Server Registration Property
7. Connect with your Credentials.
8. Verify Date Time columns from existing tables.
Regards
Surajit