hi i performed truncate table in sql server 2005 & i was successful but it just throws an alert not an error as u have mentioned

Hi KB,

We are under the same environment on 32-bit windows 2003 server. I would appreciate if you could tell us what version of iseries you are using. Our version of...

Dear Friends,

Thanks for your tips.

I did however manage to use a workaround by means of system sp's.

I used SQL Profiler.

Verify that the folder is missing:

exec sp_executesql N'exec [msdb].[dbo].[sp_dts_getfolder]...

hi gail,

thx for the patience u hv showed, detailed diagnosis & the appropriate solution. I have done the same thng in SQL 2005 & it works fine now. But...

thx for the instant response gail. Yeah u rite! the table is being imported from DB2/AS400. There are reasons that we could not create the index since we are dropping...

Dear Gail,

First of all am sorry for my typing etiquittes. Since I was working on RPG programming at that time i left the caps lock on. Anyhow thanks for...