var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Sql server 7
Is there anyway to findout if list of tables that has been modified after august 2003 in a database.
Waiting for ur reply.
from some one else, not sure who...
use crdate from sysobjects
Isn't that the create data and not the modified date? Or is modification considered a new creation?
Last edited by rokslide; 01-14-04 at 18:54.
It depends on the level of the modification involved. If the change was done through EM it may not mean that ALTER was suffice.
Yeah, I know that EM will sometimes create a whole new table with a temporary name, copy the data across from the old table, delete the old table and rename the new one.... it would be interesting to know how it decides what to do though.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors