Thanks for your replies guys, however, I am having problems getting triggers and SP's to work even when there IS a connection. The following senario seems to get the system...

Sussed it..

DECLARE @TableName varchar(256)

SELECT @TableName=s2.[name]

FROM sysobjects s

INNER JOIN sysobjects s2 ON s2.id=s.parent_obj

WHERE s.id=@@PROCID AND s.type='tr' AND s.name='[[name of trigger]]'

Has anybody got any further ideas on this? its something I am trying to do as well, but with little success.