OK DB bods,
I have a table that needs copying into a specific named table regularly.

I have tried using 'select * from t1 into t2' but that does not work if t2 already exists and the user that is running the job doesnt have permission to drop the table.

is there a similarly quick way of copying the contents of one table into another? (apart from a cursor on each line which is very slow)

also is there a way to get certain parts of a stored procedure to run under different permissions, for example to run certain parts of a procedure as SA, to overcome the above.

cheers

 

Eagle,

Rather than drop and re-create t2 could you not just issue a:
DELETE FROM <t2>
INSERT INTO <t2> (columns) SELECT (columns) from t1

periodically or setup and INSERT trigger on t1 to automatically post records to t2???

Gary

 

cheers

ive managed to sort this now i think.

my permissions were all messed up.

cheers for help

[Edited by Eagle7 - 3/21/2003 11:41:02 AM]