can R2 hit from 2000 to Denali?

Posted on 2011-10-19
Last Modified: 2012-05-12
Can SQL R2 be able to reference and query all SQL Server databases from 2000 until Denali?
Question by:25112
    LVL 69

    Accepted Solution

    from 2000 for sure.

    including Denali, it should bu I didn't tried it
    LVL 5

    Author Comment

    the reason i ask is we have databases 2000,5,8,r2.. and we want to consolidate the databases into one VM. i want to know if the 2000,5,8,r2 can be in their own compatability mode and stay in an R2 instance without problems? and for future compatability, will be able to throw in a Denali database if needed, later on?

    when I say 2000, i understand that R2 maynot be able to do anything about DTS, Analysis services of 2000. other than that, can it at least hit the databases OK? (query against them from SSMS R2)
    LVL 69

    Assisted Solution

    by:Éric Moreau
    if we are strictly speaking of data, stored procedures, views, yes it is possible.
    LVL 5

    Author Comment

    OK- thanks.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now