• I would suggest that you create a temp table (in tempdb) for this as workaround.

    You will still have the create table permission issue in tempdb but what have done is maintain an empty 'template' table in the current database, then create the temp table in tempdb via select into.

    If you tempdb is tuned for good performance you usually be better off with your temp tables in there Vs in the current database.

    The probability of survival is inversely proportional to the angle of arrival.