?
Solved

can R2 hit from 2000 to Denali?

Posted on 2011-10-19
4
Medium Priority
?
210 Views
Last Modified: 2012-05-12
Can SQL R2 be able to reference and query all SQL Server databases from 2000 until Denali?
0
Comment
Question by:25112
  • 2
  • 2
4 Comments
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 2000 total points
ID: 36993630
from 2000 for sure.

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

Author Comment

by:25112
ID: 36993648
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)
0
 
LVL 70

Assisted Solution

by:Éric Moreau
Éric Moreau earned 2000 total points
ID: 36993740
if we are strictly speaking of data, stored procedures, views, yes it is possible.
0
 
LVL 5

Author Comment

by:25112
ID: 36993797
OK- thanks.
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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, …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

850 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