Viewing 2 posts - 1 through 2 (of 2 total)
With drop/truncate, you are going to have to do a work-around like K. Brian Kelley suggested. SQL 2K doesn't have granular enough permissions :ermm:
April 20, 2009 at 1:47 pm
#981020
what if you execute a script like so, same error?
setuser 'USERNAME' -- Your user
go
delete [TABLENAME]
setuser
April 20, 2009 at 1:18 pm
#980993