SQL Server 2000 Upgrade

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Alan Cornell (anonymous_at_discussions.microsoft.com)
Date: 03/23/04

Next message: Aaron Bertrand [MVP]: "Re: to number the result of a query"
Previous message: Remi: "Re: to number the result of a query"
Next in thread: Marianne Sweeny (MSFT): "RE: SQL Server 2000 Upgrade"
Reply: Marianne Sweeny (MSFT): "RE: SQL Server 2000 Upgrade"
Messages sorted by: [ date ] [ thread ]

Date: Tue, 23 Mar 2004 09:56:10 -0800

I want to upgrade to SQL 2000, but I have several databases set to 65 compatibility. Does anyone have any scripts to help me identify the changes needed to make everything 2000 compatible?

Next message: Aaron Bertrand [MVP]: "Re: to number the result of a query"
Previous message: Remi: "Re: to number the result of a query"
Next in thread: Marianne Sweeny (MSFT): "RE: SQL Server 2000 Upgrade"
Reply: Marianne Sweeny (MSFT): "RE: SQL Server 2000 Upgrade"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: RFC: Alternate patch to have true new-style rc.d scripts in ports (without touching localpkg)
... Nearly nobody wants his scripts to be sourced in the ... > something else would be a gratuitous change and digression from NetBSD ... I'm not exactly concerned with NetBSD compatibility here, ... We shouldn't break backwards compatibility for no good reason. ...
(freebsd-current)
itools 0.16.5 released
... meta-package for easier development and deployment: ... all scripts have been renamed to have ... "igettext-extract.py" works now with Windows Python files. ... And backwards compatibility fixes for the forum. ...
(comp.lang.python.announce)
Re: RFC: Alternate patch to have true new-style rc.d scripts in ports (without touching localpkg)
... scripts to be sourced in the startup shell". ... Compatibility with NetBSD seems to be a myth, ... If ports rc.d scripts with .sh extensions aren't sourced in the same shell, ... >>the impact of ordering ports rc.d scripts with the base system scripts. ...
(freebsd-current)
Re: RFC: Alternate patch to have true new-style rc.d scripts in ports (without touching localpkg)
... >> Local rc.d scripts will continue to be executed as before. ... > except if they have a .sh extension. ... >> NetBSD), which doesn't exist in NetBSD, The only two scripts with ... Compatibility with NetBSD seems to be a myth, ...
(freebsd-current)
Re: Compatibility Level
... on SQL 2000. ... Books online says "Even when the database ... compatibility level is set to 60 or 65, applications gain almost all of the ...
(microsoft.public.sqlserver.programming)