could it be this reason:

http://support.microsoft.com/?id=972498

Unfortunately guys, several time I x-checked the source table. No duplicate was found.

Hi Koen,

No we do not insert same amount of rows every time.

Its only inserting with no update.

It takes source from a table then does some lookups etc. Then finally it...

No sp is being auto executed.

Also I just got the conformation that the server has not been restarted since 2 months.

So a reboot did not cause the xp_cmdshell to be...

connect to the sql instance and run it.

Dont forget to run it against the correct DB or put:

USE [DB_NAME] before it

Hope this helps

Thanks for the link.

However, how would i know the SP's running on server start?

I checked some of the system sp's but couldn't find any.

Thanks

Ally