_CommandPtr cmdRequest = NULL;
cmdRequest.CreateInstance(__uuidof(Command));

cmdRequest->PutActiveConnection(_variant_t((IDispatch*)pSQLConn));
// pSQLConn - _ConnectionPtr к SQL

sprintf(szRequest,"sp_dropserver 'sqltmp', 'droplogins'");
cmdRequest->CommandText = szRequest;
try
{ cmdRequest->Execute(NULL,NULL,adCmdText);
}
catch(_com_error &e)
{ char Msg[256];
_bstr_t bstrSource(e.Source());
_bstr_t bstrDescription(e.Description());
sprintf(Msg,"Source : %s \n Description : %s \n",(LPCSTR)bstrSource,(LPCSTR)bstrDescription);
}