恢复SQL2000数据库远程连接显示多个实例（国外英文资料）.doc

恢复SQL2000数据库远程连接显示多个实例（国外英文资料） Open the previously backed Sqldmo.sql script file and search for sp_MSdbuseraccess to find such a batch / * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * / If the exists (select * from the master. The dbo. Sysobjects where (OBJECTPROPERTY (id, N IsProcedure) = 1 or OBJECTPROPERTY (id, N IsExtendedProc) = 1) and name = N sp_MSdbuseraccess) drop procedure sp_MSdbuseraccess The go / * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * / Execute the command in the query analyzer and remove the current version of the sp_MSdbuseraccess stored procedure Then search for sp_MSdbuseraccess, find the following command, and recreate the original process in the SQL query parser / * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * / / * exec sp_MSdbuseraccess perm, dbname -- selecting priv bit from specified db * / / * exec sp_MSdbuseraccess db, dbname - select databases, need to change db if dbname is specified * / / * the exec sp_MSdbuseraccess init, dbname - it * / / * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * / Print N Print N Creating sp_MSdbuseraccess Print N The go The create proc sp_MSdbuseraccess @mode nvarchar (10) = N perm, @qual nvarchar (128) = N % The as The set deadlock_priority low The create table # TmpDbUserProfile ( Dbid int NOT NULL PRIMARY KEY, Accessperms int the NOT NULL ) The create table # TmpOut ( Name nvarchar (132) NOT NULL, Version smallint, Crdate datetime, Owner nvarchar (132), Dbid smallint NOT NULL, Status int, The category int, Status2 int, Fulltext int, ) Set nocount on Declare @ accessbit int If (lower (@mode) like N perm %) begin / * veri