&

admin

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

：SQL Server數(shù)據(jù)庫(kù)表/視圖/存儲(chǔ)過(guò)程的所有者并非dbo或存在賬號(hào)孤立問(wèn)題時(shí)，錯(cuò)誤表現(xiàn)如下：

//獲取數(shù)據(jù)庫(kù)連接字符串

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

//創(chuàng)建連接對(duì)象

SqlConn = new SqlConnection(ConnectionString);

//打開(kāi)數(shù)據(jù)庫(kù)，修復(fù)賬號(hào)clicksun孤立問(wèn)題

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) { }

//修復(fù)數(shù)據(jù)庫(kù)表、視圖、存儲(chǔ)過(guò)程所有者不是dbo問(wèn)題

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 編輯過(guò)

91网首页-91网页版-91网在线观看-91网站免费观看-91网站永久视频-91网站在线播放