No announcements
Found 1929963 threads
-
0 Votescompatability level 2005 is set for sql server 2008
As the backup came from a 2005 server it doesn't know anything about 2008 - so you need to change the compatability mode yourself - using the script that Olaf ...Answered | 7 Replies | 5654 Views | Created by SQLUserDBA - Thursday, April 29, 2010 6:08 AM | Last reply by Seth Lynch - Thursday, April 29, 2010 1:32 PM
-
2 Votes
Database Compatible Level 2005 SQL
Dear Phil Brammer ,Olaf Helper & Tom Phillips , i want to know the problme with Compatibility Level is 80 when i am using the SQL ...Answered | 6 Replies | 5498 Views | Created by SAAD's - Thursday, January 28, 2010 1:52 PM | Last reply by Phil Brammer - Friday, January 29, 2010 6:17 PM -
2 Votes
Sharepoint 2010 DBs Installed on SQL 2008 r2 With Compatibility Level of 90
I think that the User Profile SyncDB Compatible level 90 (sql servr 2005) is by design.Answered | 8 Replies | 12678 Views | Created by Ray Giacalone - Tuesday, October 19, 2010 9:32 PM | Last reply by Trevor Seward - Thursday, April 25, 2013 5:29 AM -
0 Votes
Change from SQL 2008 to Compatibility level SQL 2005?
I ran the check and return 90 but why when I run the new insert only work in SQL 2008 is work in sql 2005 mode.Answered | 4 Replies | 4691 Views | Created by NguyenBL - Thursday, August 11, 2011 3:39 PM | Last reply by Naomi N - Thursday, August 11, 2011 7:15 PM -
0 Votes
Geography, Geometry datatype in SQL 2012 with database compatability 2005(90)
Here's some implicit confirmation; When the compatibility level is 100 or below in SQL Server 2012 then the geography data type ...Answered | 5 Replies | 1985 Views | Created by GRaju.dba - Monday, January 30, 2017 9:14 PM | Last reply by davidbaxterbrowne - Friday, February 3, 2017 3:21 AM -
1 Votes
SSDT: SQL Server 2005 Compatibility
If you want / need to deploy to SQL Server 2005, you have to set the project target version to 2005, you can deploy upwards, given that SQL Server ...Answered | 6 Replies | 4008 Views | Created by Andre' H - Thursday, October 4, 2012 10:07 AM | Last reply by Andre' H - Thursday, October 18, 2012 12:50 PM -
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 | 1707 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
sql server 2005 compatible with OS
See Hardware and Software Requirements for Installing SQL Server 2005 andAnswered | 2 Replies | 7654 Views | Created by Prakash GR - Thursday, July 10, 2014 4:14 PM | Last reply by Prakash GR - Tuesday, July 15, 2014 12:30 PM -
0 Votes
sql server 2005 backward compatibility
We have both ROW_NUMBER (Transact-SQL) and WITH common_table_expression (Transact-SQL) since SQL Server Version 2005, so yes, it ...Answered | 2 Replies | 1000 Views | Created by Arunprasath - Thursday, December 18, 2014 1:34 PM | Last reply by Patrick Hurst - Thursday, December 18, 2014 2:32 PM -
0 Votes
Memory Usage Improved by upgrading compatibility level 80 to 90?
As Alberto pointed the compatibilty level has nothing to do with performance.Answered | 2 Replies | 3696 Views | Created by buzbuz - Tuesday, February 14, 2012 12:18 AM | Last reply by Uri Dimant - Tuesday, February 14, 2012 3:29 AM -
0 Votes
Database compatibility Level
If I set the compatibility level to "SQL server 2005 (90) " , can I restore this database to sql server ...Answered | 2 Replies | 1301 Views | Created by dcode25 - Friday, April 4, 2014 2:42 PM | Last reply by Shanky_621 - Friday, April 4, 2014 3:01 PM -
3 Votes
Is SQL Server 2005 Compatible or not on Windows 7
Hello Rachna, Your screenshot stats Visual Studio 2005, not SQL Server.Answered | 3 Replies | 2478 Views | Created by Rachna Raibman - Monday, May 13, 2013 1:06 PM | Last reply by Rachna Raibman - Tuesday, May 14, 2013 6:53 AM -
0 Votes
SQL server Compatibility option
The new syntax for CUBE and ROLLUP (which I assume you are using) was introduced in 2008 so it is only reasonable that this isn't available in 2005 level - those things ...Answered | 5 Replies | 2132 Views | Created by Fereydoon - Wednesday, September 18, 2013 5:37 PM | Last reply by TiborK - Thursday, September 19, 2013 6:35 PM -
0 Votes
SQL 2005 backward compatibility SQL 2014?
If restoring backups of SQL 2005 DBs onto a SQL 2014 can they be kept in v9.0 and should still work & run?Answered | 3 Replies | 2124 Views | Created by techresearch7777777 - Thursday, July 16, 2015 10:54 PM | Last reply by Shanky_621 - Friday, July 17, 2015 5:09 AM -
0 Votes
Change Compatibility Level
In essence, you should run the mix ov SQL Server version/compatibility level that your application expects.Answered | 4 Replies | 5927 Views | Created by FitzC - Wednesday, April 27, 2011 4:02 PM | Last reply by TiborK - Thursday, April 28, 2011 6:49 AM -
0 Votes
Changing the compatibility level in SQL 2008 from SQL server 2005 (90) to SQL server 2005 (100) there is not displayed the option in the list to change it can you help me do this change?
Hi, Are you running this query on SQL Server 2005 or on SQL Server 2008?Answered | 3 Replies | 833 Views | Created by geli - Wednesday, November 13, 2013 3:23 PM | Last reply by Chongtham Rajen Singh - Thursday, November 14, 2013 6:09 AM -
0 Votes
Changing the compatibility level
hi, you can only choose three compatibility level back AFAIK, 100 is 2008 and 2008R2Answered | 3 Replies | 818 Views | Created by Debra has a question - Monday, July 18, 2016 1:59 AM | Last reply by Enric Vives - Monday, July 18, 2016 3:55 PM -
2 Votes
SQL server 2005 comparability mode
It just mean you will not get SQL Server 2005 features.Answered | 6 Replies | 3432 Views | Created by sl5 - Wednesday, January 16, 2013 4:04 AM | Last reply by Waqas M - Friday, January 18, 2013 1:51 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 ...Answered | 5 Replies | 3090 Views | Created by Andrea Caldarone - Wednesday, March 28, 2012 12:54 PM | Last reply by Tom Phillips - Wednesday, March 28, 2012 2:01 PM -
3 Votes
sql compatibility level
Hi All, We have SQL server 2008 Instance and its production server.Answered | 5 Replies | 1398 Views | Created by Karthik Sree - Tuesday, November 17, 2015 2:46 PM | Last reply by Uri Dimant - Wednesday, November 18, 2015 6:48 AM - Items 1 to 20 of 1929963 Next ›
No announcements
