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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Get Info

Author  Topic 

LopakaB
Starting Member

22 Posts

Posted - 2013-02-28 : 13:40:18
How can I get the data data was last update into a table? also, how do you get the properties of a table?

Thank you

Lopaka

Lamprey
Master Smack Fu Yak Hacker

4614 Posts

Posted - 2013-02-28 : 13:45:03
What is the schema of your table? Do yo have a column that would indicate what is "last?" Do you have CDC enabled?

http://www.sqlservercentral.com/articles/Best+Practices/61537/
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
Go to Top of Page
   

- Advertisement -