No announcements
Found 1406324 threads
-
1 VotesRAISERROR in and database compatability level in SQL 2012
Backup your database in 2008, restore your database in 2012.Answered | 11 Replies | 13045 Views | Created by Assaf Rahav - Thursday, April 4, 2013 5:32 PM | Last reply by Erland Sommarskog - Saturday, March 25, 2017 5:51 PM
-
1 Votes
RAISERROR in SQL 2012 since SQL 6.5
And now, my question is, it is possible to change in a automated way (not manually please) all the RAISERROR in the database?Answered | 6 Replies | 2945 Views | Created by Max Berganza - Monday, August 19, 2013 3:30 PM | Last reply by remcaro - Wednesday, September 18, 2013 7:11 PM -
2 Votes
Database Compatible Level 2005 SQL
The only issue is that you cannot use SQL Server 2005 query features on a database set to 80 compatibility level.Answered | 6 Replies | 5444 Views | Created by SAAD's - Thursday, January 28, 2010 1:52 PM | Last reply by Phil Brammer - Friday, January 29, 2010 6:17 PM -
3 Votes
Biztalk 2013 Database Compatability Levels
So what would be you view on using BizTalk 2013 R2 with SQL Server 2014 SP2 and bumping the database compatibility levels up to 120.Answered | 9 Replies | 1497 Views | Created by DigitalPhil - Monday, January 16, 2017 2:12 PM | Last reply by Johns-305 - Wednesday, January 18, 2017 4:45 PM -
0 Votes
SQL Server 2012 sp1- Changing SQL Server Compatibility Level
also is it safe to update the compatibility to SQL Server 2012 ?Answered | 1 Replies | 1239 Views | Created by Liran Dobrish - Wednesday, January 8, 2014 7:44 AM | Last reply by Shanky_621 - Wednesday, January 8, 2014 7:56 AM -
0 Votes
Raiserror and SQL Agent Jobs
I tried a severity level of 10, but that is a warning and thus the statement run is considered a success not failure.Answered | 6 Replies | 2813 Views | Created by bawarbis - Monday, February 8, 2016 5:33 PM | Last reply by pituach - Tuesday, February 9, 2016 12:08 AM -
0 Votes
Raiserror @message_id @message (undocumented) is not supported anymore in SQL Server 2012 and onwards.
Is there any possible solution/option to make changes in existing code which could support in both versions of SQL Server i.e. 2008R2 and 2012.Answered | 4 Replies | 1469 Views | Created by Pranshul Gupta - Friday, February 19, 2016 8:29 AM | Last reply by Erland Sommarskog - Friday, February 19, 2016 2:07 PM -
0 Votes
Database compatibility Level
If I set the compatibility level to "SQL server 2005 (90) " , can I restore this database to sql server 2005 and 2008 ?Answered | 2 Replies | 1236 Views | Created by dcode25 - Friday, April 4, 2014 2:42 PM | Last reply by Shanky_621 - Friday, April 4, 2014 3:01 PM -
1 Votes
database compatability level
Or know everything what was added in each version by heart :) Say, we support compatibility with SQL 2000, but I have SQL 2008 R2.Answered | 4 Replies | 5090 Views | Created by prk - Thursday, November 18, 2010 8:36 PM | Last reply by prk - Sunday, November 21, 2010 8:02 PM -
3 Votes
sql compatibility level
One of my database is running under compatibility level 80.Answered | 5 Replies | 1345 Views | Created by Karthik Sree - Tuesday, November 17, 2015 2:46 PM | Last reply by Uri Dimant - Wednesday, November 18, 2015 6:48 AM -
0 Votes
Database Compatibility Level
Changing compatibility level doesn't require exclusive access to the database.Answered | 6 Replies | 2199 Views | Created by VijayKSQL - Saturday, June 6, 2020 5:12 AM | Last reply by Shanky_621 - Tuesday, June 9, 2020 4:46 PM -
1 Votes
Migrating 2005 SQL Server to 2012 SQL Server with Database Compatibility as 2008R2
To quote from BOL: Compatibility level provides only partial backward compatibility with earlier versions of SQL Server.Answered | 2 Replies | 2552 Views | Created by lcerni - Thursday, August 1, 2013 5:56 PM | Last reply by lcerni - Tuesday, August 6, 2013 12:24 PM -
0 Votes
RAISERROR question
If you use 10 seveity, For compatibility reasons, the Database Engine converts severity 10 to severity 0 before returning the error ...Answered | 4 Replies | 5808 Views | Created by CCGPlayer - Wednesday, July 7, 2010 10:13 PM | Last reply by HONGJU JUNG - Wednesday, July 14, 2010 11:13 AM -
0 Votes
Change Compatibility Level?
Hi, I have a database using Compatibility Level SQL server 2008 (100) running on a SQL server 2014 - can I change ...Answered | 11 Replies | 1633 Views | Created by dktoa - Monday, October 10, 2016 2:09 PM | Last reply by Shanky_621 - Wednesday, October 12, 2016 10:23 AM -
0 Votes
How to set the Compatibility Level of a Azure SQL database to 110 or above
MMort, Azure SQL database currently does not support changing the compatibility level.Answered | 6 Replies | 2527 Views | Created by MMort - Tuesday, November 4, 2014 11:13 PM | Last reply by MMort - Monday, November 17, 2014 10:13 PM -
2 Votes
Compatibility Level
In addition, I have one application which actually gets the SQL Server version and errors with "not a supported version of SQL Server" on ...Answered | 5 Replies | 3026 Views | Created by Andrea Caldarone - Wednesday, March 28, 2012 12:54 PM | Last reply by Tom Phillips - Wednesday, March 28, 2012 2:01 PM -
0 Votes
"Always on" for a server with sql 2012 sp1 and databases on sql 2008 compatibility mode
Hi yes it is possible ref:http://technet.microsoft.com/en-us/library/ff878487#PrerequisitesForDbs 'AlwaysOn Availability Groups works with any supported ...Answered | 2 Replies | 2563 Views | Created by Ranga1 - Monday, March 3, 2014 7:50 PM | Last reply by Ranga1 - Tuesday, March 4, 2014 2:13 PM -
0 Votes
Compatibility level 80 and database mirroring
yes it should work fine. quote from http://msdn.microsoft.com/en-us/library/ms189852.aspx "Database mirroring works with any supported database ...Answered | 1 Replies | 3757 Views | Created by MrFlinstone - Tuesday, July 26, 2011 3:47 PM | Last reply by Krystian.Zieja - Tuesday, July 26, 2011 3:56 PM -
2 Votes
COMPATIBILITY LEVEL not = 110
:( As I understand what you've installed is client tools for SQL 2012 ie Sql managenet studio,SSDT etc but the actual ...Answered | 6 Replies | 1306 Views | Created by plaster502 - Monday, July 21, 2014 8:15 PM | Last reply by Visakh16 - Tuesday, July 22, 2014 6:10 AM -
1 Votes
What is the compatibility level and the internal version of the database?
The compatibility level doesn't change automatically to match the version of SQL Server, so if you restore backup of the SQL Server 2014 database on ...Answered | 5 Replies | 2218 Views | Created by ComptonAlvaro - Monday, June 13, 2016 8:23 PM | Last reply by Naomi N - Tuesday, June 14, 2016 1:55 AM - Items 1 to 20 of 1406324 Next ›
No announcements
