1

Topic: The prohibition of record in MS SQL

I have a remote access to basis in which each 10 minutes register more 2 signals. For the test of my program, I need to be forbidden record of these signals for a while. That I could add 1-2 signals manually and the program processed only them. How it to make?

2

Re: The prohibition of record in MS SQL

just_ficks;
To forbid  under which there is a right record write on basis, well or deny on the table for this
https://docs.microsoft.com/en-us/sql/t- … ansact-sql

3

Re: The prohibition of record in MS SQL

aleksrov, the trigger hang up on the table which will do Rollback in the conditions necessary to you.

4

Re: The prohibition of record in MS SQL

just_ficks;
Try to reformulate a question.
For example, -
"How to me to test  the program?
Whether it will be normal if I break operation  servers, I will get with changes of privileges bypassing the administrator;
And as a result on  1) there will be a garbage 2) will not be reflected a little (2k*N) signals for that time while I will be played?"

5

Re: The prohibition of record in MS SQL

just_ficks;
Try to reformulate a question.
For example, -
"How to me to test  the program?
Whether it will be normal if I break operation  servers, I will get with changes of privileges bypassing the administrator;
And as a result on  1) there will be a garbage 2) will not be reflected a little (2k*N) signals for that time while I will be played?"

6

Re: The prohibition of record in MS SQL

At me is;
What question at it such and the answer.
  at it for signals also that he generally wants. If he understands that does also to it it is necessary as it should be not for queue get with the loading but thus should not be lost planned, and to the client errors about rollback should not fall or that at you  not became the rights it is probably necessary to make the trigger, on its operating time  this trigger writes down the data in any left table, and then processes it or something like it.