Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to Find Object Versions Expand / Collapse
Author
Message
Posted Monday, October 5, 2009 10:02 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, January 2, 2014 9:57 AM
Points: 554, Visits: 863
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
Post #798303
Posted Tuesday, October 6, 2009 8:02 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:16 PM
Points: 10,381, Visits: 13,441
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #798528
Posted Tuesday, October 6, 2009 8:55 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:11 PM
Points: 31,368, Visits: 15,837
The upgrade advisor should help you.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #798593
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse