October 5, 2009 at 10:02 pm
hi
guys please help me to Find the Find Object Versions
Ex :
create proc GetTime
as
declare @Date DateTime = GetDate()
Select @Date as Date
Exec GetTime
The above Procedure will only Execute in SQL 2008
Can i Identify which are the Objects that will Only Comptable with SQL 2008 ,Is there any way to Find the Comptablility of The Objects. using
sp_dbcmptlevel we Find the Database compatibility but how t
Thanks
Deepak.A
October 6, 2009 at 8:02 am
I don't know of a way to find what is only SQL Server 2008 compatible, but you can download and run the SQL Server Upgrade Advisor to make sure you can upgrade 2000 and 2005 databases without issue.
You also should look at the What's New list which will help you see what is current version only.'
In your example the script is 2008 only compatible because you are assigning a value to a local value when you declare it:
declare @Date DateTime = GetDate()
To be pre-2008 compatible you would need to change that to:
declare @Date DATETIME
SET @date = GetDate()
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 6, 2009 at 8:55 am
The upgrade advisor should help you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply