各位和邹老师放松之后帮我看看这段代码那里有问题,我实在找不出来
int Dealwith:: AddLogUser()
{
int result=0;
string sql;
try
{
sql="if exists(select * from master.dbo.syslogins where N'XXX')"
"EXEC sp_dropuser N'XXX'";
sql="if exists(select * from master.dbo.syslogins where N'XXX')"
"exec sp_droplogin N'XXX'";
sql="if not exists(select * from master.dbo.syslogins where N'XXX')"
"BEGIN"
declare@logindb nvarchar(132),@loginlang nvarchar(132)"
"select @logindb=N'master;',@loginlagn=N'简体中文'"
“if @logindb is null or not exist ()select * from master.dbo.sysdatabases where name=@logindb”
"select@logindb=N'master'"
"if @loginlang is null or (not exist (select * from mater.dbo.syslanguage where name=@loginlang)and@loginlang<>N'us_english) "
"select @loginlang=@@language"
"exec sp_sddlogin'XXX',NULL,@logindb,@loginlang"
“exec sp_password NULL,'network','XXX'"
"exec sp_adduser 'XXX'"
"exec sp_addsrvrolemember 'XXX',sysadmin"
"END";
Dbbk->ExecSQL(Sql);
}
catch(Exception &e)
(
Application->MessageBox(e.Message.c_str(),"系统提示",16);
result=-1;
}
return result;]
}
我也不知道那里出现错误了,但就是不能把密码改过来,而且重新安装数据库还是这样,这是安装的代码,我觉的问题也只出在这里,添加新的登陆名的话也可以成功,
大家帮我看看,或者有能帮我写个小程序恢复原代码的也可以我都非常感谢