Advertisement

02.07.2008 at 10:58AM PST, ID: 23145447
[x]
Attachment Details

What are the differences between SQL Server 2000 and 2005 editions at stored procedure level?

Asked by unifi in SQL Server 2005, MS SQL Server

Tags: Microsoft, SQL Server, 2000 & 2005, Difference at Stored Procedure level

While buying one of the product, seller is informing that it is 2000 compliant. According to seller, there are few stored procedure in the database which are not compliat with SQL Server 2005 in case upgrade is expected.

Would anyone please help to list down differences between SQL Server 2000 and 2005 editions at Stored Procedure level? In other way... what all changes I have to make to stored procedure while restoring 2000 database to 2005?

ThanksStart Free Trial
[+][-]02.07.2008 at 11:00AM PST, ID: 20843831

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]02.07.2008 at 11:05AM PST, ID: 20843883

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]02.07.2008 at 11:08AM PST, ID: 20843926

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, MS SQL Server
Tags: Microsoft, SQL Server, 2000 & 2005, Difference at Stored Procedure level
Sign Up Now!
Solution Provided By: dportas
Participating Experts: 2
Solution Grade: A
 
 
[+][-]02.07.2008 at 11:12AM PST, ID: 20843971

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628