allright - then I will simply test it as good as possible - just started installing it and it's more confusind than I thought! I will share my experiences with...

hi guys,

do you have any update on testing SQL Up!?

i found this information by chance - i'm currently looking for any feedback about this product, as our company is considering...

Thank you for the link :

...

----------------------------------------

Method 1

Make the system administrator the owner of the job.

Method 2

Use mapped security context for the linked server and modify the job to run...

The linked server is also SQL Server SP3. I have tested the remote query call under same account as job-owner of the job which is executing the xp_sendmail with the...

the only jobs running are maintenance-plan jobs. when viewing the existing locks there are some exclusive ones - but they are released in quite reasonable times. the interesting thing is...

thank you for the suggestion of the job-table - that's brilliant 🙂

we will go for this solution at once.

happy greetings!

so - it's as i have already feared - thanks for the quick reply.

is there really no solution to this task - no workaround - nothing?

can we not 'pretend' to...

hello Rayven,

i don't know if this topic is still up-to-date for you - but i will answer nevertheless.

We have experienced similar problems - with the difference that our server did...

hi again - and thanks for the replies!

the connection is coming in via one of our two webservers. i cannot make out more than that unfortunately.

g.

thank you for your reply - i have folowed your advice and stopped/restarted the job and as there was no error - the icon is signalling 'ok'. i still think...

hi,

i have the same problem here - same syntax error! only difference: i haven't installed SP2 yet - i will try now and see if it makes a difference.

tried nocount...