当前位置:首页 数据库 正文
+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条留言

  • Andrea

    1楼
    2011 年 08 月 14 日 23:07:59

    Hi there, I just became aware of your blog through a friend, and found that this is really informative.I will be grateful if you can continue posting these helpful articles in the future. I promise A lot of people will be benefited from your writing. Thank you!

  • buy keflex online

    2楼
    2011 年 08 月 11 日 15:57:23

    Great article with very interesting information. You are a very skilled blogger, thats for sure! =)

  • unitedpro

    3楼
    2011 年 08 月 11 日 06:54:14

    admin thnx for info, add please picture ;P

  • Andie Lee

    4楼
    2011 年 08 月 10 日 18:25:59

    Hello there, You have done a great job. I’ll definitely digg it and personally suggest to my friends. I am confident they’ll be benefited from this website.

  • buy atenolol mg

    5楼
    2011 年 08 月 09 日 23:06:31

    I just added your website on my blogroll. Really enjoyed reading through. Excellent information!

  • lexapro online

    6楼
    2011 年 08 月 08 日 09:06:08

    I just added your website on my blogroll. I may come back later on to check out updates. Excellent information!

  • sex ladies

    7楼
    2011 年 07 月 31 日 22:48:13

    Comfortably, the article

  • Evelyn

    8楼
    2011 年 07 月 28 日 03:44:27

    Definitely believe that which you stated. Your favorite reason appeared to be on the internet the easiest thing to be aware of. I say to you, I certainly get irked while people think about worries that they just do not know about. You managed to hit the nail upon the top and defined out the whole thing without having side effect , people can take a signal. Will likely be back to get more. Thanks

  • Les Nettle

    9楼
    2011 年 07 月 27 日 07:33:48

    Good content in addition to simple to help realize story. How do When i try obtaining agreement to help publish element on the content around my approaching e-newsletter? Offering correct credit ratings to your account this writer in addition to website link towards webpage will not become a dilemma.

  • Linwood Laudenslager

    10楼
    2011 年 07 月 25 日 20:58:24

    Exceptional page and even quick to help you figure out justification. Exactly how can As i continue acquiring concur to help you place element belonging to the document inside new newssheet? Getting right credit standing you that journalist and even backlink with the internet site won’t even be a concern.