sort by Date Last Modified

[lkalman@financemgr.com]

Looking to add a column on the object to be able to
sort by Date Last Modified

[andy.campbell.smith]

Sorry - I'm not sure exactly how this relates to SQL Compare? If you want to order rows in a table by the date last modified, you'd need to set that up through SSMS - there's a little more information here that might be useful to you:

http://stackoverflow.com/questions/2610370/question-about-datecreated-and-datemodified-columns-sql-server

Is that the kind of thing you're after?
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer

[lkalman@financemgr.com]

Well this way you can sort by date order and determine which change you want per date.

For Example if you are only looking to find out today's changes and not all other changes.

[andy.campbell.smith]

Ah, right, OK. SQL Server doesn't capture any information like this by default, so you'd need to set up a computed column for SQL Compare or SQL Data Compare to have any access to that information. I'm assuming this question is actually about SQL Data Compare, given that you're talking about sorting by columns.

If you've got that DateModified column set up, then you can filter the data with a WHERE clause as detailed on this page:

http://www.red-gate.com/supportcenter/Content/SQL_Data_Compare/help/10.0/SDC_ApplyingConditions

That ought to let you filter for changes applied within a specific timeframe. Does that help at all?
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer