Bugs in Enterprise Manager for Numeric?

Question

Post reply

Bugs in Enterprise Manager for Numeric?

kokyan

SSCommitted

Points: 1694
More actions
November 27, 2003 at 6:14 pm

#81567

I have a table in SQL Server 2000 Enteprise Edition.
CREATE TABLE dbo.TESTTBL
(
MYID NUMERIC(38),
MSG VARCHAR(100)
)
When I perform insert record using INSERT statement in Query Analyzer, it has no problem.
But, when I try to insert record into it using Enterprise Manager (GUI), I hit error "CANNOT EDIT THIS CELL" (when insert a number in the MYID column)!
I try to minimize the size of the MYID (one by one) until NUMERIC(29), I successfully insert into it without error.
My conclusion is for Enterprise Manager, numeric field larger than 29 will create error. Do I miss anything that cause the error? Or it really bugs in SQL Server 2000.
Edited by - kokyan on 11/27/2003 6:27:38 PM

Regards,
kokyan

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 1

I insert this

INSERT INTO TESTTBL(MYID, MSG)

VALUES (1, 110)

it works fine!!!

My Blog: http://dineshasanka.spaces.live.com/

kokyan SSCommitted Points: 1694 More actions · Answer 2

Try to use Enterprise Manager GUI to insert the record. I also successful insert records using Query Analyzer.

Regards,
kokyan

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 3

Yes I tried in Enter prise manager

My Blog: http://dineshasanka.spaces.live.com/

kokyan SSCommitted Points: 1694 More actions · Answer 4

Then, any settings need to configure? For your information, my SQL Server version is:

SELECT @@VERSION

Output:

I don't hit any errors when I change the precision to 29.

Regards,

kokyan

Regards,
kokyan

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 5

My Blog: http://dineshasanka.spaces.live.com/

mccork SSC-Insane Points: 22288 More actions · Answer 6

Dinesh,

I'm not sure you tried inserting data directly into the cell of the "Open Table" panel as Kokyan has done.

Yes, if you run the INSERT (as you have posted) in the SQL panel of Enterprise Manager it works ok.

But typing directly into the cell, I get the "Cannot edit this cell" error too.

Cheers,

- Mark

Cheers,
- Mark

Antares686 SSC Guru Points: 125444 More actions · Answer 7

Does seem to be a bug within Enterprise Manager. I find no info on it based on my searches and might be worth sending to MS.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 8

Doesn't work here either, but do you really need to edit your data via EM?

There are better ways for this

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

kokyan SSCommitted Points: 1694 More actions · Answer 9

Thanks for all the reponses. I just want to highlight the bugs in Enterprise Manager of SQL Server 2000. Actually, I seldom use the features of EM GUI.

Regards,

kokyan

Regards,
kokyan