Insert using OpenRowSet

Aug 7 2009 7:11 AM

hai friends
Good Day.....
i have 2 sql server in differend location. that connected with VPN. i wand to insert value my connected server. so i'm usinf openRowSet like this....
INSERT OpenRowSet('SQLOLEDB','Server=User-2,1433;UID=sa;PWD=;Trusted Connection=yes;') INTO triger..A (number) VALUES ('ss')
i'm getting error incorrect syntax near ')'.
any one know ... update me....!!!
thank you
Shouketh