经常遇到这样的问题，想还原数据库的时候发现有程序在使用该数据库导致无法还原，可以采用以下方法解决：

需要有master数据库的执行权限，然后执行以下sql语句

declare @dbname varchar
set @dbname='labor' -------这里设置对应的数据库名
declare @sql nvarchar(500)
declare @spid int
set @sql='declare getspid cursor for
select spid from sysprocesses where dbid=db_id('''+@dbname+''')'
exec (@sql)
open getspid
fetch next from getspid into @spid
while @@fetch_status<>-1
begin
exec('kill '+@spid)
fetch next from getspid into @spid
end
close getspid
deallocate getspid

create PROCEDURE [dbo].[up_PagingLarge]
@TableNames VARCHAR(500),     --表名，可以是多个表，但不能用别名
@PrimaryKey VARCHAR(100),     --主键，可以为空，但@Order为空时该值不能为空
@Fields     VARCHAR(500),      --要取出的字段，可以是多个表的字段，可以为空，为空表示select *
@PageSize INT,                --每页记录数
@CurrentPage INT,             --当前页，0表示第1页
@Filter VARCHAR(500) = '',    --条件，可以为空，不用填 where
@Group VARCHAR(500) = '',     --分组依据，可以为空，不用填 group by
@Order VARCHAR(500) = '',      --排序，可以为空，为空默认按主键升序排列，不用填 order by
@pages bigint output
AS
BEGIN

DECLARE @sql nvarchar(4000),@where1 varchar(800),@where2 varchar(800)
IF @Filter is null or rtrim(@Filter)=''
BEGIN--没有查询条件
   SET @where1=' WHERE '
   SET @where2='   '
END
ELSE
BEGIN--有查询条件
   SET @where1=' WHERE ('+@Filter+') AND '--本来有条件再加上此条件
   SET @where2=' WHERE ('+@Filter+') '--原本没有条件而加上此条件
END
SET @sql='SELECT @Pages=CEILING((COUNT(*)+0.0)/'+CAST(@PageSize AS varchar)+
          ') FROM '+@TableNames+@where2
EXEC sp_executesql @sql,N'@pages int OUTPUT',@pages OUTPUT--计算总页数

     DECLARE @SortColumn VARCHAR(500)
     DECLARE @Operator CHAR(2)
     DECLARE @SortTable VARCHAR(500)
     DECLARE @SortName VARCHAR(500)

     IF @Fields = ''
         SET @Fields = '*'
     IF @Filter = ''
         SET @Filter = 'WHERE 1=1'
     ELSE
         SET @Filter = 'WHERE ' +   @Filter
     IF @Group <> ''
         SET @Group = 'GROUP BY ' + @Group

     IF @Order <> ''
     BEGIN
         DECLARE @pos1 INT, @pos2 INT
SET @Order = UPPER(@Order)
         IF CHARINDEX(' DESC', @Order) > 0
             IF CHARINDEX(' ASC', @Order) > 0
             BEGIN
                 IF CHARINDEX(' DESC', @Order) < CHARINDEX(' ASC', @Order)
                     SET @Operator = '<='
                 ELSE
                     SET @Operator = '>='
             END
             ELSE
                 SET @Operator = '<='
         ELSE
             SET @Operator = '>='

         SET @SortColumn = REPLACE(REPLACE(REPLACE(@Order, ' ASC', ''), ' DESC', ''), ' ', '')
         SET @pos1 = CHARINDEX(',', @SortColumn)
         IF @pos1 > 0
             SET @SortColumn = SUBSTRING(@SortColumn, 1, @pos1-1)
         SET @pos2 = CHARINDEX('.', @SortColumn)
         IF @pos2 > 0
         BEGIN
             SET @SortTable = SUBSTRING(@SortColumn, 1, @pos2-1)
             IF @pos1 > 0
                 SET @SortName = SUBSTRING(@SortColumn, @pos2+1, @pos1-@pos2-1)
             ELSE
                 SET @SortName = SUBSTRING(@SortColumn, @pos2+1, LEN(@SortColumn)-@pos2)
         END
         ELSE
         BEGIN
             SET @SortTable = @TableNames
             SET @SortName = @SortColumn
         END
     END
     ELSE
     BEGIN

SET @SortTable = @TableNames
SET @SortColumn = @PrimaryKey
SET @SortName = @SortColumn

SET @pos1 = CHARINDEX('.', @SortName)
         IF @pos1 > 0
             BEGIN
                 SET @SortTable = SUBSTRING(@SortName, 1, @pos1-1)
                 SET @SortName = SUBSTRING(@SortName, @pos1 + 1, LEN(@SortName))
             END
        
         SET @Order = @SortColumn
         SET @Operator = '>='
     END

     DECLARE @type varchar(50)
     DECLARE @prec int
     SELECT @type=t.name, @prec=c.prec
     FROM sysobjects o
     JOIN syscolumns c on o.id=c.id
     JOIN systypes t on c.xusertype=t.xusertype
     WHERE o.name = @SortTable AND c.name = @SortName

     IF CHARINDEX('char', @type) > 0
     SET @type = @type + '(' + CAST(@prec AS varchar) + ')'

     DECLARE @TopRows INT
     SET @TopRows = @PageSize * @CurrentPage + 1

     Declare @StrSQL NVarChar(2000)
     Set @StrSQL = 'DECLARE @SortColumnBegin ' + CAST(@type AS VARCHAR) + '
   SET ROWCOUNT ' + CAST(@TopRows AS varchar) +'
   SELECT @SortColumnBegin=' + @SortColumn + ' FROM   ' + @TableNames + ' ' + @Filter + ' ' + @Group + ' ORDER BY ' + @Order + '
          SET ROWCOUNT ' + CAST(@PageSize AS VARCHAR) + '
          SELECT ' + @Fields + ' FROM   ' + @TableNames + ' ' + @Filter   + ' AND ' + @SortColumn + ' ' + @Operator + '@SortColumnBegin ' + @Group + ' ORDER BY ' + @Order + '    
       '
     Exec(@StrSQL)
     Print(@StrSQL)

END

sp_changeobjectowner
更改当前数据库中对象的所有者。

语法
sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'


最稳妥的处理办法：

EXEC sp_changeobjectowner '所有者.authors', '新的所有者'

<img src="cid:123">

使用cid:标记,表明图片是放在一个叫123的附件中的
然后加入一个附件,指定为
content-type: image/gif
content-id: <123> 即上面那个123
content-disposition: inline; filename="sdfsdf" filename是随便指定的
content-transfer-encodinf: base64

这里是附件内容要求用base64编码

Command Identifiers

2D-Position

Allows absolutely positioned elements to be moved by dragging.

AbsolutePosition

Sets an element's position property to "absolute."

BackColor

Sets or retrieves the background color of the current selection.

BlockDirLTR

Not currently supported.

BlockDirRTL

Not currently supported.

Bold

Toggles the current selection between bold and nonbold.

BrowseMode

Not currently supported.

ClearAuthenticationCache

Clears all authentication credentials from the cache. Applies only to execCommand.

Copy

Copies the current selection to the clipboard.

CreateBookmark

Creates a bookmark anchor or retrieves the name of a bookmark anchor for the current selection or insertion point.

CreateLink

Inserts a hyperlink on the current selection, or displays a dialog box enabling the user to specify a URL to insert as a hyperlink on the current selection.

Cut

Copies the current selection to the clipboard and then deletes it.

Delete

Deletes the current selection.

DirLTR

Not currently supported.

DirRTL

Not currently supported.

EditMode

Not currently supported.

FontName

Sets or retrieves the font for the current selection.

FontSize

Sets or retrieves the font size for the current selection.

ForeColor

Sets or retrieves the foreground (text) color of the current selection.

FormatBlock

Sets the current block format tag.

Indent

Increases the indent of the selected text by one indentation increment.

InlineDirLTR

Not currently supported.

InlineDirRTL

Not currently supported.

InsertButton

Overwrites a button control on the text selection.

InsertFieldset

Overwrites a box on the text selection.

InsertHorizontalRule

Overwrites a horizontal line on the text selection.

InsertIFrame

Overwrites an inline frame on the text selection.

InsertImage

Overwrites an image on the text selection.

InsertInputButton

Overwrites a button control on the text selection.

InsertInputCheckbox

Overwrites a check box control on the text selection.

InsertInputFileUpload

Overwrites a file upload control on the text selection.

InsertInputHidden

Inserts a hidden control on the text selection.

InsertInputImage

Overwrites an image control on the text selection.

InsertInputPassword

Overwrites a password control on the text selection.

InsertInputRadio

Overwrites a radio control on the text selection.

InsertInputReset

Overwrites a reset control on the text selection.

InsertInputSubmit

Overwrites a submit control on the text selection.

InsertInputText

Overwrites a text control on the text selection.

InsertMarquee

Overwrites an empty marquee on the text selection.

InsertOrderedList

Toggles the text selection between an ordered list and a normal format block.

InsertParagraph

Overwrites a line break on the text selection.

InsertSelectDropdown

Overwrites a drop-down selection control on the text selection.

InsertSelectListbox

Overwrites a list box selection control on the text selection.

InsertTextArea

Overwrites a multiline text input control on the text selection.

InsertUnorderedList

Toggles the text selection between an ordered list and a normal format block.

Italic

Toggles the current selection between italic and nonitalic.

JustifyCenter

Centers the format block in which the current selection is located.

JustifyFull

Not currently supported.

JustifyLeft

Left-justifies the format block in which the current selection is located.

JustifyNone

Not currently supported.

JustifyRight

Right-justifies the format block in which the current selection is located.

LiveResize

Causes the MSHTML Editor to update an element's appearance continuously during a resizing or moving operation, rather than updating only at the completion of the move or resize.

MultipleSelection

Allows for the selection of more than one site selectable element at a time when the user holds down the SHIFT or CTRL keys.

Open

Not currently supported.

Outdent

Decreases by one increment the indentation of the format block in which the current selection is located.

OverWrite

Toggles the text-entry mode between insert and overwrite.

Paste

Overwrites the contents of the clipboard on the current selection.

PlayImage

Not currently supported.

Print

Opens the print dialog box so the user can print the current page.

Redo

Not currently supported.

Refresh

Refreshes the current document.

RemoveFormat

Removes the formatting tags from the current selection.

RemoveParaFormat

Not currently supported.

SaveAs

Saves the current Web page to a file.

SelectAll

Selects the entire document.

SizeToControl

Not currently supported.

SizeToControlHeight

Not currently supported.

SizeToControlWidth

Not currently supported.

Stop

Not currently supported.

StopImage

Not currently supported.

StrikeThrough

Not currently supported.

Subscript

Not currently supported.

Superscript

Not currently supported.

UnBookmark

Removes any bookmark from the current selection.

Underline

Toggles the current selection between underlined and not underlined.

Undo

Not currently supported.

Unlink

Removes any hyperlink from the current selection.

Unselect

Clears the current selection.