Hardware Compatability
Sep 26, 2007Does SQL Server Express Edition work with a Pentium M computer? When I downloaded it there was a message that it wasn't the proper hardware but everything else fits the requirements for an install.
View 6 Replies
ADVERTISEMENT
Top N And Compatability Level
Aug 16, 2000How do I check the compatability level of a database?
The db in question was originally created in SQL 6.5 and converted to 7.0. Would this have reset the compatability level to 7 or left it at 6.5?
If it is at 6.5 what are the implications of changing it to 7?
Ray, if you answer this can you please forward me your email address. Thanks.
Changing Compatability From 65 To 80
Apr 21, 2008Finally, I may have a good enough excuse to justify changing the compatabilty level of one of the biggies I look after!
Before I go ahead with the change I just wanted to run a couple of questions passed the community.
I know this is very vague, but what sort of problems should I expect? I know there are a few syntax changes, but I don't imagine I will have a problem going up in compatability level!
What is the best method to perform this?
A very simple
EXEC sp_dbcmptlevel 'playdb', 80
Or
ALTER DATABASE SET SINGLE_USER
EXEC sp_dbcmptlevel 'playdb', 80
ALTER DATABASE SET MULTI_USER
How long does this process take; are we talking seconds, minutes, hours? I imagine it's seconds, but I pose this question because a colleague reckons it will take longer because of the database size. I argue that because it's a db configuration setting, it will make no difference...
Thanks a bunch,
George
How Do You Tell A Databases Compatability Level?
Nov 18, 1999How do you tell a databases compatability level?
View 1 Replies View RelatedSQL 2005 Compatability Mode
Feb 23, 2007Hi,We currently have a fairly old product, which was originally onlycompatible with SQL 2000.When we upgraded our server to SQL 2005, the client product gave us a"This product is not compatible with this version of SQL server"error.We put the server into SQL 2000 compatability mode, and things worked.Then I tested a Windows Vista workstation client. The error returned.I realise that if we are simply dealing with a client incompatabilitywith Vista, then I'm in the wrong forum, but what I'm hoping is thatsomeone knows anything server side, perhaps where SQL 2000compatability mode becomes ignored for some reason, when the client isrunning Vista.The vendor pretty much no longer exists, and nothing I've been able todo with Vista's compatability modes has been helpful so far.
View 1 Replies View RelatedChanging The Compatability Level Risks?
Feb 19, 2008I am currently running a sqlServer 2000 database and am considering changing it to 2005 I see that I can do this via Properties> options and changing the dropdownbut are there any risks?
SQL Server 2005 Backwards Compatability
Jan 18, 2006I'm sure this question has already been asked, I made an attempt to search the forums, but was unsuccessful.
Our production servers are currently running SQL Server 2000 3a. I just got a new development system and have no intentions of installing SQL Server 2000 dev, but SQL Server 2005 Dev Edition.
I was wondering if I will still be able to install SQL2005 and still be able to administer/modify 2000 mdfs with SQL 2005 Enterprise Manager. I wanted to be able to still make development on SQL 2k5 and update the production server (SQL2k). This is on my dev system not the production, the production will still be running SQL 2k, until the client decides on purchasing SQL 2k5.
Of course I will not be able to use the new db features and types on a SQL2000 server, I just want to maintain the legacy with 05 Enterprise Manager (i.e.: SP, UDF and DTO).
Thanks a gig.
Larry
SQL 2000/Terminal Services Compatability
Oct 11, 2001I need to know if Microsoft supports SQL Server 2000 running on the same server that functions as a Terminal Server (both NT and Windows 2000).
I checked out Microsoft.com and found that SQL Server 7 is supported with NT Terminal Services but can't locate any compatability information SQL 2000.
PS: I know this configuration doesn't make sense from a performance perspective but my customers will want to do this anyway.
Thanks!
Switching Compatability Mode From 6.5 To 2000
Jan 9, 2006Do you know of any resources in terms of Transact SQL in order to migrate from 6.5 to 2000?
View 1 Replies View RelatedGeneral Questions On This Product (compatability)
Jul 20, 2005hiI just gotta know:what is the database that sql server creates/works with?Can it be used in an oracle environment?Or can it be uploaded to a Oracle db? (like access thru odbec)thanks!!jim
View 1 Replies View Related90 Compatability Mode Option Not Available After Upgrade
Dec 18, 2006I upgrade to sql 2005 from sql2000. The problem is that the compatability mode 90 is not available, 8.0 and 7.0 are, when looking at the compatability level in the properties tab. THe GUI, Management studio is loaded and operational.
What do I need to do to make the 90 compatability mode available?
Thanks!
Report Server Compatability Issues
Mar 30, 2006Hello!
I have sql server 2000(sp2) rs installed on one of my mashine and I am using VS,NET 2005 to develop some reports.
At the deploing step I am getting some error:
"Connection could not be made to the report server http://..."
Additional information on error message says:
"The attempt to connect to report server failed.Check your connection information and that report server is a compatible version. (Microsoft.ReportingServices.Designer)."
Can't find any information about this issue. Is there anything I have to do to fix this.
Upgrade Advisor For Compatability Level.
Jan 23, 2008Is there any way to run upgrade advisor against a database the is on a sql 2005 server but set to 80 compatability level?
Or is there another tool to do this?
NT Svpk 3 ODBC Connection Compatability W/ SQL7
Nov 10, 1999We have multiple NT machines which have/require Service Pack 3 installed and run an application which makes an ODBC connection to an SQL 7 DB. Some of them are experiencing ODBC issues.
Question: Are there any known ODBC compatability issues with machines runnings service pack 3 ODBC connecting to SQL 7 running NT Service Pack 4?
Multi Language Compatability In DataBase Storage????
Jan 4, 2008
I have ran into a problem making a database where i have two versions of a book , one in russian and the other in English. The english part worked but when i input the data for Russian it gets replaced each time with question marks. Is there something i have to enable for the SQL database for it to be able to store Russian Text, or is it a DataType i have to set???
THANKS IN ADVANCE
Restoring 2005 Backup With 8.0 Compatability Mode On 2000 - Help
Feb 26, 2007Hi,
I have a database that is in the SQL Server 2000 compatability mode on my SQL 2005 server. I am trying to restore a backup of this database on my SQL Server 2000 database on another server and keep getting strange messages. First trying Red-Gate and then plain SQL Server with no luck.
It seems as I remember that the 7.0 and 2000 compatibility issue between backups did not arise when the compatibility mode was set to 7.0.
Is this "planned" behavior or an "undocumented feature"??? Anyone else have success doing this?
Thanks,
John Campbell