Yes, it is possible, but it's strange.

Thank you very much for your opinion.

Reporting system is our weakest point but we work on its improvement. It was much more worst several month ago and still there...

I live this forum but QoD makes me crazy too often...:crazy:

That's OK. As I said, I will use it only for warning user before potencially long waiting.

:Wow:

That is exactly what I need!

Thanks

I know estimated plan. But how can I retrieve its information from an application?! I see that I can do i t in SSMS...

Yes, I know that. But is not useful for me beacuse I don't want to execute query.

We already use NOLOCK for queries used in our reports.

Could you tell us, where the problem was?

It will be quite complicated to parse EVENTDATA, but it is possible. Thank you, Andras!

Nobody can help? 🙁

Why to do this? ORDER BY should not be inside view and I think it is good that it is not supported by SQL 2005!

Not only triggers cause this error, the same problem is with nesting views...

I have noticed this error in nesting views. If you have for example 5 views (each of 8 tables) and you create view with joins to all of them, you...

I would answer to both question - possible blocking problem, out of date statistics or indexes

Sorry for mistake, it should be:

WITH CTE_Code(Code) AS

(

SELECT 21

UNION ALL

SELECT 66

UNION ALL

SELECT 34

UNION ALL

SELECT 36

UNION ALL

SELECT 37

UNION ALL

SELECT 35

UNION ALL

SELECT 33

UNION ALL

SELECT 38

UNION ALL

SELECT 39

UNION ALL

SELECT 112

UNION ALL

SELECT 121

)

SELECT...