Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
idamithw
Starting Member
1 Post |
 Posted - 2013-08-01 : 18:50:15
|
| Can i get last updated column id/value from particular table in sql server? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-01 : 20:12:28
|
quote:
Originally posted by idamithw
Can i get last updated column id/value from particular table in sql server?
Not sure exactly what you mean.If you are thinking about identifying the last update to a table, then unless you have some type of auditing (such as a trigger that captures the changes or Change Data Capture ) enabled, you cannot get that information.If you are thinking about changes to the schema - i.e, a new column added, the data type of an existing column changed etc., look up Schema Changes Report under standard reports. You can get to the standard reports from SSMS object explorer by right-clicking on the database name and selecting Reports -> Standard Reports. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-08-02 : 01:45:04
|
| http://www.mssqltips.com/sqlservertip/1468/designing-tables-for-audit-data-in-sql-server/Another option is Server Auditinghttp://msdn.microsoft.com/en-us/library/dd392015(v=sql.100).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
sql server last update column