最好最新中文字幕电影,帮帮我爱神迅雷下载,国产日韩亚洲

admin

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

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

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

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

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

SqlConn = new SqlConnection(ConnectionString);

//打開數(shù)據(jù)庫，修復(fù)賬號(hào)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) { }

//修復(fù)數(shù)據(jù)庫表、視圖、存儲(chǔ)過程所有者不是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 編輯過

狠狠色丁香婷婷综合尤物/久久精品综合一区二区三区/中国有色金属学报/国产日韩欧美在线观看 - 国产一区二区三区四区五区tv