SQL Server Performance Forum – Threads Archive

Enterprise manager and Return All Rows

[?]I have two tables: DOC_MAST and DOCSMAST. When I use "RETURN ALL ROWS" on table DOC_MAST,I obtain data of table DOCSMAST. It seems that Enterprise Manager executes uan risen of "like" in order recovering the name of the table.
What can I do?

How about Query Analizer, works fine?
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

It is always better practice to use Query Analyser than EM to view the records Madhivanan Failing to plan is Planning to fail

Am I understanding you correctly, that EM is returning the data from the wrong table?
If so, have you renamed one table into the other prior to this behaviour? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Please post the thread in relevant forums only (moved from Analysis forum)./ In general Enterprise Manager returns all the rows like SELECT * from… and it is always advised to run such queries from Query analyzer as suggested above.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

hi,
if you have ambigious name or system names , always use [tablename](Square Bracets) AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS

Hi,
I have two tables:
DOC_MAST
DOCSMAST
When I try to use the voice of menu "Return All Rows" on table DOS_MAST, Enterprise Manager gives back the content of table DOCSMAST. What can I do?
Obviously using Query Analizer I do not have some problem.
I think that Enterprise uses rising of "like" in order recovering the name of the table.
In fact EM executes "select * from DOCSMAST" instead of "select * from DOC_MAST"
Table DOC_MAST has been created before table DOCSMAST.
How can I avoid this anomaly?
Thanks for your help.

Simply speaking, avoid using Enterprise Manager for viewing your data. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]Therefore it is a EM error. OK thanks

Yes, unfortunately EM is buggy and solves many problems in a nonefficient manner. Frankly, the sooner you get familiar with Query Analyzer, the better. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] – Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de</a> Ich unterstÃ¼tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

That is the another flaky feature of EM and it is replaced from SQL 2005 onwards, where most of admin tasks can be performed using QA. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>