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 |
|
manju3606
Yak Posting Veteran
78 Posts |
 Posted - 2011-11-04 : 02:28:02
|
| Hi to all,I have 120GB database,i have to import data from my DB to XML file by date ,but my problem is i dont know my DB tables structure whether column like datetime or timestamp are available or not in tables if column available then there is no proble for me if that cand of columns are not available in tables then what i have to do i am not understanding. So please could any one help me with this. ThanksManju |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-04 : 04:30:24
|
| if you dont have any datecolumn there's no straightforward means to export data based on date------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
manju3606
Yak Posting Veteran
78 Posts |
Posted - 2011-11-04 : 05:23:28
|
| Hi Visakh,Thanks for reply,There is any chance in serevr level,like server maintain records of data witch inserted on witch date ?like log maintains.ThanksManju |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-04 : 05:30:09
|
| thats only if you've enabled auditing in server or you've some audit triggers created for tables------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
data import