well then - if doing a quick google isn't good for you or your company enough why should we here do it for you? I found a few hits when...

although removing (or not using) compression on tables is likely hindering space requirements and performance - table compression does help in majority of cases with performance.

Partitioning is also no longer...

try and install an older version of access runtime

https://www.microsoft.com/en-us/download/details.aspx?id=39358

and if on your own PC don't install neither standard or enterprise - install developer instead.

• This reply was modified 4 days, 11 hours ago by frederico_fonseca.

and which ones did you research so far and what are your own comments on them? or questions about them.

Naumon doesn't care about that - only trying to show "something" even if it is details already repeated or not suitable for the thread.

all documentation is pretty clear - upgrade is possible, downgrade isn't (going from standard to express, even if newer version of sql, is a downgrade).

Downgrade an edition

To downgrade the edition...

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...