declare @dbpwd as nvarchar(50) declare @dbcatalog as nvarchar(50) declare @dbserver as nvarchar(50) declare @accid as nvarchar(50) declare @dbpwdgo as nvarchar(50) set @dbpwd = '12345679a' set @dbcatalog = 'UFDATA_999_2014' set @dbserver = 'U8V13' set @accid = '1000000001' set @dbpwdgo = '12345679a' INSERT INTO MES_Comm_MAINACC (connstr,accid,caddress,cdbpwd,cdatabase) VALUES ('Provider=SQLOLEDB.1;Password=' + @dbpwd + ';Persist Security Info=True;User ID=sa;Initial Catalog=' + @dbcatalog + ';Data Source=' + @dbserver + ';Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=' + @dbserver + ';Use Encryption for Data=False;Tag with column collation when possible=False', @accid,@dbserver,@dbpwd,@dbcatalog)
UPDATE MES_Comm_MAINACC SET CONNSTR= 'Provider=SQLOLEDB.1;Password=' + @dbpwd + ';Persist Security Info=True;User ID=sa;Initial Catalog=' + @dbcatalog + ';Data Source=' + @dbserver + ';Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=' + @dbserver +';Use Encryption for Data=False;Tag with column collation when possible=False', CADDRESS = @dbserver,CDBPWD=@dbpwdgo
GO
找不到存储过程 'Password'。
按照此错误信息应该就是系统缺少‘password’这个存储过程，所以只要给系统添加这个存储过程就可以了，具解决方式如下：
打开“查询分析器”，登录的时候选择“Windows验证”而非默认的“SQL Server身份验证”，在MES_Comm_MAINACC 表右键选择“新建查询”下执行以下语句：
