16,471
社区成员
发帖
与我相关
我的任务
分享
CString sSql;
sSql = _T("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog= master;Data Source='") + ServerName
sSql += _T("'");
m_pConnection->ConnectionTimeout = 10;
m_pConnection->Open(sSqlTemp.GetBuffer(sSqlTemp.GetLeng()),"","",adModeUnknown);
然后,在使用
sSql = _T("Create database temp");
m_pRecordSet->Open(sSql.GetBuffer(sSql.GetLength()),(IDispatch*)m_pConnection,adOpenDynamic,adLockPessimistic,-1);
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.1.21'
--创建一个链路
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'zhk','zhk'
--链路的登陆名和密码
go
select * from srv_lnk.zhk.dbo.send_backup
exec sp_dropserver 'srv_lnk','droplogins'
--下面就可以查拉,send_backup是表名