,,

admin

2021年6月5日 10:4 本文熱度 5862

：SQL Server數據庫表/視圖/存儲過程的所有者并非dbo或存在賬號孤立問題時，錯誤表現如下：

//獲取數據庫連接字符串

ConnectionString = "data source=(local);initial catalog=clicksun;user id=sa;pwd=clicksun$193$631;Connection Timeout=30";

//創建連接對象

SqlConn = new SqlConnection(ConnectionString);

//打開數據庫，修復賬號clicksun孤立問題

try

{

SqlConn.Open();

string ComText = "sp_change_users_login 'Auto_Fix', 'clicksun', NULL, 'clicksun2010'";

SqlCommand Comm = new SqlCommand(ComText, SqlConn);

Comm.ExecuteNonQuery();

SqlConn.Close();

}

catch (Exception) { }

//修復數據庫表、視圖、存儲過程所有者不是dbo問題

try

{

SqlConn.Open();

string sqlMessage = "select (user_name(uid)+'.'+name) as uname from sysobjects where status>=0 and xtype in('U','V','P') and user_name(uid)<>'dbo'";

SqlCommand sCmd = new SqlCommand(sqlMessage, SqlConn);

SqlDataReader sdr = sCmd.ExecuteReader();

string updateDBOwner = "";

while (sdr.Read()) { updateDBOwner += "exec sp_changeobjectowner '" + sdr.GetValue(0).ToString() + "','dbo';"; }

sdr.Close();

SqlConn.Close();

if (updateDBOwner != "")

{

SqlConn.Open();

SqlCommand Comm = new SqlCommand(updateDBOwner, SqlConn);

Comm.ExecuteNonQuery();

SqlConn.Close();

}

catch (Exception) { }

該文章在 2021/6/5 10:42:10 編輯過

公交车上荫蒂添的好舒服的电影-公用玩物(np双xing总受)-公用小荡货芊芊-公与妇仑乱hd-攻把受做哭边走边肉楼梯play-古装一级淫片a免费播放口