Hi,
1) Can anyone help me in how to determine the file size of the table ?
2) How to shrink it , what will be the proper way? I have read a couple of threads about it but when I tried shrinking the database after deleting historical data nothing happens. the database size is the same.
Thanks in advance