SQL Server在存储(或触发)中连接远程SqlServer

Question

http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=5489远程连接SQL Server的方法： 
　　 ConnStr = "Provider=SQLOLEDB.1;Network Library=DBMSSOCN;Persist Security Info=True;User&nbs 
　　 p;ID=UserName;Password=Password;Initial Catalog=远程数据库名;Data Source=203.129.92.1"

Answer 1

ConnStr = "Provider=SQLOLEDB.1;Network Library=DBMSSOCN;Persist Security Info=True;User ID=UserName;Password=Password;Initial Catalog=远程数据库名;Data Source=203.129.92.1".