Disabling MS SQL 7 triggers through VB6

[seosamh]

Hi

I need to temporarily disable and then reenable some triggers. This is not a problem when done through the MSSQL 7 query analyzer. However, when I attempt to disable these through an application written in VB6 I am presented with

run-time error '-2147217900 (80040e14)'... Only the owner or members of the sysadminrole can alter table 'xxxx'

I have used "sp_addsrvrolemember 'domain\user', 'sysadmin'", but to no avail. I have given every permission possible, but no joy either. What do I need to do?

Any help would be much appreciated

Seosamh