ÐÞ¸ÄMSSQL±íËùÓÐÕßµÄÁ½ÖÖ·½·¨
ÍøÕ¾¸ü»»¿Õ¼äµÄʱºò£¬¾³£»áÒòΪMSSQLÊý¾Ý¿âÃû²»Í¬£¬µ¼Ö´Ӿɿռ䱸·ÝµÄÊý¾Ý¿âÔÚпռ仹ԺóÎÞ·¨Õý³£Ê¹Óá£Õâʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ý½«Êý¾Ý¿â±íµÄËùÓÐÕßÐÞ¸ÄΪ"dbo"À´½â¾öÕâ¸öÎÊÌ⣬¾ßÌåµÄ·½·¨ÈçÏ£º
´ò¿ª"Microsoft SQL Server"µÄ“ÆóÒµ¹ÜÀíÆ÷”£¬µã¿ªÒªÐ޸ĵÄÊý¾Ý¿â£¬Ñ¡Ôñ¹¤¾ßÀ¸Éϵē¹¤¾ß”£“SQL ²éѯ·ÖÎöÆ÷”£¬ÊäÈëÒÔÏ´úÂ룺
1¡¢ÅúÁ¿ÐÞ¸ÄMSSQL±íµÄËùÓÐÕß
exec sp_MSforeachtable 'exec sp_changeobjectowner "?","dbo"'
2¡¢µ¥¸öÐÞ¸ÄMSSQL±íµÄËùÓÐÕߣº
exec sp_changeobjectowner 'Òª¸ÄµÄ±íÃû','dbo'
È»ºó°´"F5"Ö´ÐÐÃüÁ¼´¿ÉÐ޸ijɹ¦£¬Ë¢ÐÂÊý¾Ý¿â¾Í¿ÉÒÔ¿´µ½½á¹ûÁË¡£
Ïà¹ØÎĵµ£º
ÈçºÎÇå³ýMSSQLÊÂÎñÈÕÖ¾Îļþ
ÈýÖÖ·½·¨£º
1¡¢É¾³ýLOG
1)£º·ÖÀëÊý¾Ý¿âÆóÒµ¹ÜÀíÆ÷££¾·þÎñÆ÷££¾Êý¾Ý¿â££¾ÓÒ¼ü££¾·ÖÀëÊý¾Ý¿â
2)£ºÉ¾³ýLOGÎļþ & ......
ÈçͼËùʾ£¬ÔÚ°²È«ÐÔ-µÇ½Àï¿ÉÒÔ¿´µ½ÓÒ±ßÁбíÀïµÄÓû§£¬Ñ¡ÖÐÓû§ÓÒ¼ü-ÊôÐÔ¿ÉÒÔ¸ü¸ÄÓû§ÃÜÂ룬¼°Êý¾Ý¿â½ÇÉ«µÈ¡£
²é¿´Óû§Ãû£¬¼°ÃÜÂëÊÇ·ñÕýÈ·£¬¿ÉÒÔµ¥¶ÀµÇ½ ²éѯ·ÖÎöÆ÷
Èç¹ûÄܵǽ˵Ã÷ÉèÖÃÕýÈ·£¬ÔÚmssql´î½¨µÄasp cmsÀï¾³£ÒªÓõ½Óû§Ãû£¬ÃÜÂë¡£
ÏÖÔÚ¿´Ã¿¸öÊý¾ÝÏÂÃæµÄÓû§Ñ¡ÏÈçͼ
Ñ¡ÖÐÒ»¸öÒ»¸öÊý¾Ý¿â£¬»òÏÂÃæµÄÓû§Ñ ......
/// <summary>
/// ´´½¨Êý¾Ý¿â¡£
/// </summary>
/// <param name="srvName">±íÊ ......
public sealed class DbOper
{
///<summary>
/// DbOperÀàµÄ¹¹Ô캯Êý
///</summary>
private DbOper()
{
}
......