Hello,
I am trying to do this and i am getting this error..

create table #temptbl (rec varchar(284))

BULK INSERT #temptbl FROM 'z:\Testline.txt'
WITH ( DATAFILETYPE = 'char',
FIELDTERMINATOR = '\r\n',
CODEPAGE = 'RAW',
MAXERRORS = 10000,
FIRSTROW = 2)

Server: Msg 8104, Level 16, State 2, Line 3
The current user is not the database or object owner of table '#timberline'.
Cannot perform SET operation.


User has BulkAdmin rights and he is a dbo in the database.

Pls advise.

Thanks,

--
Message posted via http://www.sqlmonster.com

This should work according to:

http://support.microsoft.com/default...b;en-us;302621
http://support.microsoft.com/default...b;en-us;243023

Are you certain the user is dbo or a db_owner role member? Please confirm
with SELECT USER, IS_MEMBER('db_owner') in the tempdb database. Tempdb is
recreated at startup so any permissions in that database are lost.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"msqldba m via SQLMonster.com" <u11604@uwe> wrote