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

  • Authentic Ninja Sword

    1楼
    2014 年 05 月 21 日 04:34:06

    Love it! Fast shipping thanks!

  • motorkkkurrye

    2楼
    2014 年 04 月 07 日 22:22:27

    I love your blog.. very nice colors & theme. Did you make this website yourself or did you hire someone to do it for you? Plz reply as I’m looking to create my own blog and would like to know where u got this from. thanks a lot

  • Pingback: viagra

  • kaley cauco kaly caouco big bang theory throy download hd

    3楼
    2014 年 04 月 05 日 23:03:07

    Enjoyed reading through this, very good stuff, regards . “A man does not die of love or his liver or even of old age he dies of being a man.” by Percival Arland Ussher.

  • So Marketing

    4楼
    2014 年 04 月 05 日 22:35:09

    Wonderful blog! Do you have any tips for aspiring writers? I’m hoping to start my own blog soon but I’m a little lost on everything. Would you recommend starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely overwhelmed .. Any recommendations? Thanks a lot!

  • phentermine

    5楼
    2014 年 04 月 05 日 21:51:29

    My doc is prescribing Valium for me to get rid of the feeling of a lump in my throat. I was just wondering how well it would work..

  • Jacken Von Belstaff

    6楼
    2014 年 04 月 05 日 21:12:53

    Excellent beat ! I wish to apprentice even as you amend your website, how can i subscribe for a weblog site? The account helped me a acceptable deal. I were a little bit familiar of this your broadcast provided brilliant clear concept