Changing Compatability From 65 To 80

Apr 21, 2008

Finally, 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

View 14 Replies


ADVERTISEMENT

Changing The Compatability Level Risks?

Feb 19, 2008

I 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?
 
 

View 2 Replies View Related

Top N And Compatability Level

Aug 16, 2000

How 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.

View 3 Replies View Related

Hardware Compatability

Sep 26, 2007

Does 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 View Related

How Do You Tell A Databases Compatability Level?

Nov 18, 1999

How do you tell a databases compatability level?

View 1 Replies View Related

SQL 2005 Compatability Mode

Feb 23, 2007

Hi,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 Related

SQL Server 2005 Backwards Compatability

Jan 18, 2006

I'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

View 1 Replies View Related

SQL 2000/Terminal Services Compatability

Oct 11, 2001

I 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!

View 1 Replies View Related

Switching Compatability Mode From 6.5 To 2000

Jan 9, 2006

Do you know of any resources in terms of Transact SQL in order to migrate from 6.5 to 2000?

View 1 Replies View Related

General Questions On This Product (compatability)

Jul 20, 2005

hiI 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 Related

90 Compatability Mode Option Not Available After Upgrade

Dec 18, 2006

I 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!

View 3 Replies View Related

Report Server Compatability Issues

Mar 30, 2006

Hello!

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.



View 3 Replies View Related

Upgrade Advisor For Compatability Level.

Jan 23, 2008

Is 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?

View 6 Replies View Related

NT Svpk 3 ODBC Connection Compatability W/ SQL7

Nov 10, 1999

We 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?

View 1 Replies View Related

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

View 2 Replies View Related

Restoring 2005 Backup With 8.0 Compatability Mode On 2000 - Help

Feb 26, 2007

Hi,

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

View 3 Replies View Related

Changing The Sqldataroot

Dec 14, 2000

A college forgot to change the data root when installing a developer server. My question is can this be changed whitout reinstalling the server and restoring the developer databases.
I found sqldataroot under [HKEY_LOCAL_MACHINESoftwareMicrosoftMSSQLServerSetu pSQLDataRoot]
If I stop the sql server and change this value and move the *.mdb and *.ldf files. Would I risk currupting the databases and do I need to change something else? For example would changeing this value change the default path for backupdevices?

View 2 Replies View Related

Changing Passwords

Dec 5, 2000

I have a problem where our developers would like to change the passwords of the SQL Logins without knowing the users old password.

The only way they can use the below syntax is that they must be a member of the SYSAdmin Server Role.

sp_password NULL, 'newpassword',Max

I need a way to allow them to change the passwords without making a user a member of the SYSAdmin Server Role.

Any thoughts would be greatly apprecitated. Thanks in advance.

Max

View 1 Replies View Related

Changing Security

Dec 20, 2000

I need to change my security settings from "Windows NT Only" to "SQL Server and Windows NT". Does anyone know of any issues with doing this? Does this subtract anything or does it only add access??

View 1 Replies View Related

Changing License Key

Jun 5, 2002

Is there a way to change the license key after installation of SQL7.0?

View 1 Replies View Related

Changing Database Name

Nov 19, 2002

hi, I have created a database in sql server 2000. I need to duplicate the database under different name, how can I do that?
Also, can I rename a database name?
thanks
Ali

View 3 Replies View Related

Changing Server Name

Dec 7, 1999

Hi all,

I need to change the NT Server computer name (and the SQL Server name). I know how to do it in NT, but how would I go about changing the SQL Server name. Can anyone help me with this? Is this an easy process?

Thanks,
LC

View 3 Replies View Related

Someone Changing Permissions..

Mar 1, 2005

Someone is changing permissions on our production sql databases frequently which is causing big problems..any idea how to know who is changing and when? Any code that can be written to capture such activity?

thanks,
dbfan.

View 6 Replies View Related

Changing The Sa Password

Aug 6, 1998

I`m running SQL 6.5 with standard security. We`re running NT 4.0. I am a member of the NT Admin group - which, of course, has sa privileges in SQL Server. I changed the sa password (via Enterpise Manager on my client machine); and it worked. I tested the password change by connecting to ISQL/w - both on my client machine and at the server machine.

However, when I attempted to connect to the server via Enterprise Manager (SEM) - on my client machine - my login attempt failed. But at the server machine, I connected just fine.

Somehow, even though we`re using standard security, I`m getting locked out of SEM because of the new password. Changing the sa password back to what it had been resolved the problem; but the old password was only meant to be temporary.

Any suggestions or explanations?

View 3 Replies View Related

Changing SA Passwword

Dec 15, 1998

Hi,

During SQL installation I left the SA password blank. Now when I try to change it, the event log fills up with the following errors:

Mesg 18456 : Login failed- User: sa.
I am using SQL database for SMS and I have a SMS service account.
The error type in event viewer is "Failure Audit".

I am stopping and starting SQL once changes are made. I am also registering server with "Use Trusted Connection". I have also tried with "Use Standard Security" and the SA account.

Can anyone tell me how to change my SA password without affecting my SMS service account?

Thanks,

Terry

View 1 Replies View Related

Changing Column Name

Nov 9, 2004

Hi all,

I have a table that has integrity constraints in place and it is populated with the data. I need to rename one of the columns in the table. I am hesitant to use sp_rename procedure because when I used it before I get a warning message that says "changing any part of an object name could break scriptd and stored procedure." how big of a problem is it? Is there any other way to do it without hearting anything? Thanks.

View 1 Replies View Related

Changing A Column Name

Nov 30, 2005

How can you change a Column name for MS SQL 2000 ?

something like :

ALTER TABLE [dbo].[MyTable]
OldName RENAME NewName
GO

thank you

View 6 Replies View Related

Changing Collations...

Mar 2, 2006

I have looked thru the forum but have a couple of questions:
1) data base was created with case insensitive collation
2) all the tables were then create (72 tables) and by default got the CI collation on all columns
3) lots of data was added 2GB
4) discovered mistake and altered the database to have case sensitive collation
5)..... how to change all the collations for all the columns without doing them all manually
can i backup the database and change some settings and restore it?
export all the data, drop and recreate tables and import data?
????

View 7 Replies View Related

Tracking Who Is Changing What?

Aug 9, 2006

We are building an inventory management system complete with BOM. It is important to track what employee is updating what tables. Currently all such tables have a Date field that is updated when a change is made, and an EmployeeID field which records the employee making the change. I am wondering if someone knows of a better way to track this information. Any suggestions?

View 4 Replies View Related

Changing Formats

Apr 25, 2007

Hey guys,
I have a file that has date formatted like so: 2006-11-16 20:12:00
I would like the dateformat to be like mm/dd/yyy hh:mm

The file is being pulled into a varchar field..... as 2006-11-16 20:12:00
when I do a conversion i can only get it to mon 11,2006


any suggestions

View 1 Replies View Related

Changing A Date

Jan 25, 2012

SO, If I had a problem with server computer date & stored false dates for some operations, How can I alter those dates to correct dates.

View 1 Replies View Related

Changing Server Name

Jan 29, 2004

Hi. Sorry to be asking this. I know there is a KB article with the steps for changing a SQL2K server name, but I can't find it for the life of me.

Anyone have it tagged?

TIA

View 3 Replies View Related

Changing Server Name

Oct 8, 2015

We are going to install new SQL Server 2014 on Windows 2012 R2. There is a copy of this server which is running on SQL Server 2005. This one has old operating system and wont be able upgrade to SQL Server 2014.

After doing some checks on 2014 we would like to change this server-name with the old server-name which is running on 2005.how can we change the server-name?

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved