Shouketh EK

Shouketh EK

  • NA
  • 36
  • 30k

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

Answers (1)