Truncate not working

[enak]

I need to update a DTS package. One of the processes that it uses is deleting all of the data from a table. I have copied this from the production server onto a test server.

I can not get the process of deleting the data to work. The DTS uses the following statement:

truncate table [dbo].[tblCaseInfoAll]

If I run this on the test server I get a message that the user does not have permission to perform this action...or something like that. However, I can execute the following:

delete tblCaseInfoAll

and this works. I have checked the permissions of the user and they look good to me.

What am I missing?

Thanks,
enak

 

[Krickles]

Do you have any constraints on the table?

Krickles | 1.6180

 

[enak]

Nothing. I just dropped the table and recreated it but still can not truncate.

 

[mrdenny]

You must have dbo rights to the database in order to trunate.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[enak]

Thanks, the user id that I am using does not have dbo rights.

 

[jbenson001]

What is the EXACT error message?

 

[enak]

I made the userid a dbo. everything is fine now.

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)