I just need to know if I can create a table which will automatically get dropped after N number of days. The reason is I create lots of physical tables in side sp's to store the logging and mail it, when there is any issue that table is retained in the database.
I know that this can be replaced with global tables (##table_name). But just need know to if I can create table like this. Can any one know how to do this?
Thanks is Advance,
View Complete Post