tool that can give the list of depricated features in sql 2000

  • Hi All,

    we are in the process of upgrading our SQL servers 2000 (SP1) to sql server 2008 r2 version. I know that we have lot of features changed/depreicated from sql server 2000 to sql server 2008. I was wondering if we have any tool or some other way that scans all our databases and queries and gives us the list of all the features that needs to be modified before we upgraded the servers to 2008 version (For Ex: If we have some thing liek this "*=, =*" ........... that tool should gives this info)

    I really appreciate your help.

    Thanks

  • For a free tool (Microsoft's upgrade advisor) go to this link:

    http://msdn.microsoft.com/en-us/library/ms144256.aspx

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thanks for the reply....

  • I do not have an instance of SQL Server 2000 available for checking, but you might want to test by using this:

    select * from master.dbo.sysperfinfo

    If you do use the above, please post back on your results, it might assist others with the same situation as yours.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Hi Ron,

    Here is the output of that T-SQL query:

    Object_Name Counter_Name Instance_Name cntr_Value cntr_type

    SQLServer:Buffer Manager Buffer cache hit ratio 2676 537003008

    SQLServer:Buffer Manager Buffer cache hit ratio base 26801073939459

    SQLServer:Buffer Manager Page lookups/sec -2025620116272696320

    etc.......

    I think I was looking for the list of deprecated features that are in my current sql 2000 environment and needs to be modified while going to sql 2008 version

    Thanks & Regards

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply