Are you sure you don't have something like this in production?

select stuff
from table
where condition is so and so
-- order by something


-----Original Message-----
From: Hakim Tadjer [mailto:[Email Address Removed] Tuesday, September 17, 2002 9:52 AM
To: LazyDBA.com Discussion
Subject: Stored Proc 2000



Hi,

I have a little problem, my stored procedure don't execute the
ORDER BY in my request in live database and he can do it in test database.

where i can check to verify where is the problem

sql 2000/ WIN 2000 environement in .Net tech

Thanl's




_________________________________________________________________
Discutez en ligne avec vos amis ! http://messenger.msn.fr


---------------------------------------------------------------------
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page