Long running script?

[bowwow]

Does anyone know af a SQL query that I could use to run as a SQL Job that will mean it will run and run. Im looking to test some monitoring scripts to detect for long running SQL jobs. However Im new to scripts and am not sure how to generate a long running script in SQL?

Any help much appreciated.
Kind Regards
Bowwow

 

[PHV]

Simply do some cartesian product on two huge tables ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bowwow]

Being a 'newbie' to scripts... do you have any such examples of a 'certsian product'?

 

[PHV]

A cartesian product is made when you have 2 tables in the FROM clause and no join condition.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886