thanks,

we decided to have just developer servers instead of having one sql instance on every developer PC.

i'm not talking about developer user access to data.... i'm talking about EF applications and permissions for those apps... but thanks for your time anyway.

well, it appears to be working better for us. We have no locks like before (it was a terrible), and the server is working better now. All we did was:

1)...

thanks! i did install it on a test-server and then on a production server that was not so important and everything was OK. Yesterday i installed it on the main...

hi, i'm new with sql server, i answered A and i got a "wrong answer". The thing is, you are using a "@i is null" not a "@i = NULL"....