hi,
i have a query which i run in query analyzer.
if i copy it to the enterprise manager it rearranges
my query. this is not a problem for me, but the result is
different, there are different numbers of rows given back.
is that a known bug, or are there some things  i can do
to change that behaviour? with this i do still not know
which result is right....

greetings,
mike

Do you have a query to post which might help us a bit more?

Show quoteHide quote

(peppi***@hotmail.com) writes:
I assume that you mean the View/Query Designer in Enterprise Mangager?
Yes, this is known to rearrange queries, and sometimes in a fashion
that alters the result. The tool can be nice for demos, and simple
queries, but you outgrow it pretty quick, as it is not very capable
with complex queries.

And, no, it has not been improved in SQL 2005. It still can mangle
your queries. But to make matters worse, it is now more exposed.

Generally, I would recommend you to stay away from that tool. Run
your queries from Query Analyzer, or the Query Editor in Mgmt Studio.

modifying stored procedure with SSMSE
Server Memory usage\Performance problem
DBCC CHECKIDENT call never returns
Problem with Maintenance Plan to delete files older than 2 days
Activity Monitor: SQL 2005