I typed up a large reply but then I hit submit and it was gone. So I'll be brief. I created 4 large projects this year. No, my skills...

and its possible that someone did a insert with a high value and used identity insert - that would set the identity value to that of the insert

without knowing the code of Function2 we can't help there. it may or not be possible/easy - but if function2 returns more than 1 row (first 1 returns a single...

the correct answer was hidden from us!!!

not sure if it is global, but spammers posts are having a delay of around 7 minutes.

I would expect IT to review how to implement this and potentially allow this...

you should be able to post 1 link per reply

better not even suggest that exists - what is being done is plainly wrong, and giving them an option to make the insert work is just opening it up...

use a extended event trace to see who/when/how its being done - and if the other server account has sysadmin access to this one, remove it and grant only required...

review all permissions on server and remove any that can be used to change those settings - including possibility of changing SQL Agent jobs (or the SP's they execute) to...

they...

they are using...

435 pages atm

323 pages of spam as of 3pm (gmt) saturday

today although I did some cleaning it was just to block them.

Got in this morning and had 150+ pages of spam. some of them with 250 posts

today was a busy day for spammers.

I've reported likely over 400 posts today.  92 of them from a single user, and a few others with 55  posts each.

really would like...