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 2005 Forums
 Other SQL Server Topics (2005)
 new field

Author  Topic 

slimjen
Yak Posting Veteran

61 Posts

Posted - 2007-09-20 : 11:12:31
Hello all,
I noticed that when I upsize MSAccess databases to Sql Server 2005, a field named upsize_ts appears in all the tables. Can anyone tell me why or what this means?
Thank you

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2007-09-20 : 12:29:31
Hi

If upsizing from Access to SQL, MS Access adds the Upsize_Ts field. Basically it's timestamp representing when the data was upsized. useful for multiple users.

Jack Vamvas
--------------------
Need an IT job ? http://www.ITjobfeed.com
Go to Top of Page
   

- Advertisement -