当前位置:首页 数据库 正文
+28°

SQL SERVER 孤立用户问题

2011年07月23日 | 作者: 米豆网 - 1000seo | 分类: 数据库 | 

孤立用户问题:从别一台服务器上得到一个数据库备份.还原到本地,数据库中的用户无法登录,也就是联机帮助中说的还原备份可能产生的孤立用户问题.想保留原有用户.

一种方法是你在恢复好的数据库中把该用户删掉,请查找不同的角色是否对应有此用户。另一种方法是在sqlserver中先创建此用户,然后再恢复。显然第一种方法很简单。但如果如果该用户对应了自己的对象,你就无法删除,这样就要你先把它对应的对象更改所有者。

先增加一个SQL  SERVER登录,如果有就不要加了。然后运行存储过程

sp_change_users_login  ‘update_one’,’数据库用户名’,’SQL  SERVER登录名’

本文章由 米豆网 - 1000seo 于2011年07月23日发布在数据库分类下,
+复制链接 转载请注明:SQL SERVER 孤立用户问题-米豆网
关键字:,

好文章就要一起分享!

更多

目前共有28条留言

  • Pingback: Comprar Seguidores No Instagram

  • Marty Schummer

    1楼
    2014 年 04 月 05 日 13:36:48

    Regards for helping out, superb info .

  • Salomon Speed Cross

    2楼
    2014 年 04 月 04 日 10:03:53

    Thank you, I’ve recently been searching for info about this topic for ages and yours is the best I’ve discovered so far. But, what about the bottom line? Are you sure about the source?|What i don’t understood is in fact how you’re no longer really much more neatly-liked than you may be now. You’re very intelligent.

  • http://johnwaynecollectables.com

    3楼
    2014 年 04 月 04 日 00:21:01

    What i do not understood is actually how you’re not really much more well-liked than you might be now. You’re so intelligent. You realize therefore significantly relating to this subject, produced me personally consider it from numerous varied angles. Its like men and women aren’t fascinated unless it’s one thing to do with Lady gaga! Your own stuffs outstanding. Always maintain it up!

  • Boxer Calvin Klein

    4楼
    2014 年 04 月 04 日 00:08:01

    Hi, i believe that i saw you visited my site thus i got here to return the favor?.I am trying to to find things to improve my site!I suppose its good enough to use some of your concepts!!

  • Appliance Repair Long Island, Appliance Repair Long Island, Appliance Repair Long Island, Appliance Repair Long Island, Appliance Repair Long Island, Appliance Repair Long Island, Appliance Repair Long Island, Appliance Repair Long Island, Appliance Repai

    5楼
    2014 年 04 月 02 日 11:23:00

    Thanks for your beneficial post. As time passes, I have been able to understand that the actual symptoms of mesothelioma are caused by this build up connected fluid between your lining of the lung and the chest cavity. The sickness may start from the chest spot and spread to other parts of the body. Other symptoms of pleural mesothelioma include weight loss, severe inhaling trouble, vomiting, difficulty swallowing, and infection of the face and neck areas. It should be noted that some people having the disease will not experience virtually any serious indications at all.

  • 创业论坛

    6楼
    2011 年 08 月 30 日 01:03:03

    第一次访问,留个脚印,希望能回访!

  • Devon Pelkowski

    7楼
    2011 年 08 月 26 日 17:50:41

    Good article in addition to simple to help realize explanation. How do When i try obtaining permission to help publish element on the content around my approaching e-newsletter? Giving correct credit ratings to your account this author in addition to link towards webpage would not become a dilemma.

  • bing free games

    8楼
    2011 年 08 月 18 日 10:22:11

    Hey, I finally decided to write a comment on your blog. I just wanted to say good job. I really enjoy reading your posts.

  • one good guy

    9楼
    2011 年 08 月 15 日 09:24:07

    Really great article with very interesting information. You might want to follow up to this topic!?! 2011