.... create a schedule task  ....

I'd prefer to use a sqlagent job, because it captures jobinformation.

Maybe you cannot do this because your system's...

...Could not allocate new page for database tempdb....

You may have been running into a file allocation timeout. Sqlserver only waits for a certain time to receive a "file extended" reply...

the growth of you tempdb must be due to usage of your sqlserver !

Someone running huge queries, grouping-sets or sorting. Keep in mind tempdb is not persistent. Whenever sqlserver is...

- it would look like bad code !

- keep in mind you have no control over the availability of the counterparty !

can you add tablealiasses ? That eases reading and interpreting the query ?

e.g select t1.Uname

      from mytable t1

       , myview x2

      where t1.idno = x2.colxyz

         and t1.Ubirthdate = '2007-01-01'

or

select t1.Uname

     ...

I totaly agree !

And sometimes "time" also plays a roll in a situation.

I'm sorry to mention it can be handy to learn some basics regarding Structured Query Language. Invest some time reading about the "select" statement in books online.

- Actualy the only way of creating dbo objects by default is making that user databaseowner !! sp_changedbowner @loginame = 'PRG' ,@map = 'true'

groupmembership is not enough ! (you'll have to...

Thanks for posting the workaround.

It also works with SQL2005 Std SP1 

be very carefull if you want to disable triggers and/ or constraints because that goes for _every_ user of the database for the time you've desabled them !!

basicaly meaning, if...

If you are still considering a cluster implementation, also consider to implement SQL2005 !!! because it has enhancements like mirrored databases which is  also a high availability solution with failover possibillities,...

just to add to Michael Earl's reply :

The guideline for any RDBMS is that by default one should provide exact foreign-key...

the downside of the proposed proc is that it will start the job, even if it has been disabled !!!

Maybe it's better to implement an alert to start the job,...

Do you have an index for DateInserted and/or ErrorID ?

otherwize i guess your deletequery performs a tablescan ! this way (dead)locking may occur more frequent !

- If you have no baseline or reference, how would you define "performant" ?

Start with defining your expectations (or references to the "old" server ) regarding the time your planned...