September 5, 2017 at 11:41 pm
Hello Everyone,
I am facing Issue when creating the new database in SQLSERVER 2012 with SQL SERVER 2005 compatible bulk scripts. The Error message says :
Changed database context to 'master'.
Msg 15416, Level 16, State 1, Server xxxxx, Procedure sp_dbcmptlevel, Line 66
Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]
Valid values of the database compatibility level are 90, 100, or 110.
What might be the cause for above issue Is there any permission issues?
Regards,
Ram
September 6, 2017 at 2:50 am
sram24_mca - Tuesday, September 5, 2017 11:41 PMHello Everyone,
I am facing Issue when creating the new database in SQLSERVER 2012 with SQL SERVER 2005 compatible bulk scripts. The Error message says :Changed database context to 'master'.
Msg 15416, Level 16, State 1, Server xxxxx, Procedure sp_dbcmptlevel, Line 66
Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]Valid values of the database compatibility level are 90, 100, or 110.
What might be the cause for above issue Is there any permission issues?
Regards,
Ram
what are you attempting to set the compatability level to
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply