yes, i agree. i ,may need to create a windows job and so i am hitting the forum if someone has done this before that can be shared. Thanks

I did run the query and interestingly for all the databases i am getting the date with in the last 2 days where in i am pretty sure there are...

Deos the query you provided give me the last date when some one read any database?

and if i am doing a daily backup, does that show wrong dates?

How do i know if a connection recycled or how can i track the usage of connection?

I dont see anything weired in any logs and temp tables are # local.

yes because source and destination are in the same database is it still ok?

also is there a way to use full cpu power to this inserts faster, may be increasing...

but i am loading data from a view to a table with in same database.

DEv, could you please tell what components i have to use for this simple process.

also the source table is a view and there wont be any ID column for source.

because i am selecting it from a view which has something like

select [col1] a,[col2] b from ....

when do script as for the same it has something like

SET...

NO even that would do tha same.

when i created new table with select into and when i check the definition of the new table by doing "script as create" i see alter stmts in the definition...

HI, All of these qey's are giving me restore % which is 100% but it is actaully recovering after the restore from the past few days not sure when that...

How do i know the % of recovery completed so far. Looks like i cant see this from the log becasue this recovery is not a regular one but this...

No, it was restarted when there was an active INSERT transaction and so it rolled back when the server was up and because i assumed it takes more time to...

yes, the instance was restarted.