处理孤立用户的存储过程

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

CREATEPROCEDURE[LoneUser]
--INPUT
@DBName        nvarchar(50),
@UserName        nvarchar(50)
AS
  Execsp_configure'allowupdates','1'
  RECONFIGUREWITHOVERRIDE
  
  Declare@ExecStrnvarchar(4000)
  
  Select@ExecStr='Declare@bvarbinary(85)'
              +'UseMaster'
              +'Select@b=sidFromsysloginsWhereName='''+@UserName+''''
              +'Use'+@DBName
              +'UpdatesysusersSetsid=@bWherename='''+@UserName+''''

  --Print@ExecStr
  Exec(@ExecStr)

  Execsp_configure'allowupdates','0'
  RECONFIGUREWITHOVERRIDE  

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>