设置企业管理器连接SQL数据库时只显示自己的实例.docVIP

设置企业管理器连接SQL数据库时只显示自己的实例 设置企业管理器连接SQL数据库时只显示用户自己的数据库 1.备份sql2000数据库安装目录Microsoft SQL Server\MSSQL\Install下Sqldmo.sql文件(一般备份在安装目录D:\SQL2000) 2.打开查询分析器(master下)执行如下命令： /*******************************************************************************/ /* exec sp_MSdbuseraccess perm, dbname -- selecting priv bit from specified database */ /* exec sp_MSdbuseraccess db, dbname -- select databases, must change the database if dbname is specified */ /* exec sp_MSdbuseraccess init, dbname -- noop */ /*******************************************************************************/ print N print NDropping sp_MSdbuseraccess print N go if exists (select * from master.dbo.sysobjects where (OBJECTPROPERTY(id, NIsProcedure) = 1 or OBJECTPROPERTY(id, NIsExtendedProc) = 1) and name = Nsp_MSdbuseraccess) drop procedure sp_MSdbuseraccess go print N print NCreating sp_MSdbuseraccess print N go create proc sp_MSdbuseraccess @mode nvarchar(10) = Nperm, @qual nvarchar(128) = N% as set deadlock_priority low create table #TmpDbUserProfile ( dbid int NOT NULL PRIMARY KEY, accessperms int NOT NULL ) create table #TmpOut ( name nvarchar(132) NOT NULL, version smallint, crdate datetime, owner nvarchar(132), dbid smallint NOT NULL, status int, category int, status2 int, fulltext int, ) set nocount on declare @accessbit int if (lower(@mode) like Nperm%) begin /* verify */ declare @id int, @stat int, @inval int select @id = dbid, @stat = status from master.dbo.sysdatabases where name = @qual if (@id is null) begin RAISERROR (15001, -1, -1, @qual) return 1 end /* Can we access this database? */ declare @single int select @single = DATABASEPROPERTY( @qual, Nissingleuser ) /* if ((@single 0) or ((@stat S