Question

MSDN_12345 on Thu, 19 Jun 2014 11:56:17


hi ,

We are creating one domain level user [ex: abc\username], it’s successfully created but we are unable to give DB level permission. While I am trying to give the db level permission getting below error message.


Sponsored



Replies

Shanky_621 on Thu, 19 Jun 2014 12:34:48


hi ,

We are creating one domain level user [ex: abc\username], it’s successfully created but we are unable to give DB level permission. While I am trying to give the db level permission getting below error message.

What is compatibility level of Database. Please change compatibility level to match that of SQL server version like if you have SQL server 2008/ R2 it should be 100, 110 for SQL 2012.

MSDN_12345 on Thu, 19 Jun 2014 12:54:47


Database compatibility level is not an issue, why because we have sql server 2005 server and all db’s are having compatibility is 90.

Note: if in case we change any compatibility level from 80\90 to 100 if any problem in frontend side application. 

Shanky_621 on Thu, 19 Jun 2014 13:35:40


Database compatibility level is not an issue, why because we have sql server 2005 server and all db’s are having compatibility is 90.

Note: if in case we change any compatibility level from 80\90 to 100 if any problem in frontend side application. 

Ok can you show me the query please which is giving issue.

For second part of question yes it may have please see below link for more details

http://msdn.microsoft.com/en-gb/library/bb510680.aspx

Good thing is we can change compatibility level immediately if it is a issue

Santosh Chandel on Fri, 20 Jun 2014 10:44:28


Not able to see the error message on text window, please copy paste that here.

RAJU RG on Mon, 23 Jun 2014 03:10:54


First Issue may be due to ARITHABORT setting at SSMS session

SELECT SESSIONPROPERTY('ARITHABORT') AS ArithAbortSetting
select @@OPTIONS & 64

http://bytes.com/topic/sql-server/answers/83799-set-options-have-incorrect-settings-arithabort

Second  issue may be due to compatibility level

http://social.technet.microsoft.com/wiki/contents/articles/12621.troubleshooting-fim-error-25009-conditional-failed-set-options-incorrect-arithabort.aspx

Third any issues with code ?

http://stackoverflow.com/questions/9235527/incorrect-set-options-error-when-building-database-project

http://www.sqlservercentral.com/Forums/Topic1534925-146-1.aspx