I am now facing a difficulty and hope you can help me. It is about sp_remotesql.
for some reasons (the table name is dynamic), i need to run an insert sql by sp_remotesql. Normally, it should work. However, this time, the table (my_table) contains an identity column "id" and string column "site"