Thanks

In the meantime I solved it. However, thanks to those who read my topic 🙂

Thanks for the help!

Thank you for your response. I've solved in this mode:

EXEC ('ALTER QUEUE Test_Queue WITH STATUS=ON, ACTIVATION (STATUS=ON, PROCEDURE_NAME=usp_Test, MAX_QUEUE_READERS = '

+ @mqr

+ N', EXECUTE AS SELF);')

Resolved!

USE TestDB

select * from sys.service_queues

Thanks to everyone for the help.

I forgot to say that rows are periodically deleted according to the date of entry.

Thanks again

The only index is on the first column (Pr_key).

Only INSERT rows. Never UPDATE statement on rows.

Thanks

Someone can help me?

Thanks

I'll try to read it, thanks

Thanks to all.

But is there a chance to do an EVENT NOTIFICATION instead of a TRIGGER (without changing the permissions on views or other) ?

This is always in order...

Thanks for your response.

My goal is to keep track in a table of IP addresses of all those who are connected to a sql database.

It's works fine ! Thank you Greg

Very thank you

I will do other tests and research.

Anyway thanks to everyone for the answers.