TRY~IF EXISTS ( SELECT * FROM tempdb.dbo.sysobjects WHERE id = OBJECT_ID(N'[tempdb].[dbo].[HoldforEachDB]') ) DROP TABLE [tempdb].[dbo].[HoldforEachDB] ; CREATE TABLE [tempdb].[dbo].[HoldforEachDB] ( [Server] [nvarchar](128) NULL, [DatabaseName] [nvarchar](128) NOT NULL, [Owner] [nvarchar](128) Not NULL, [Size_MB] [int] NOT NULL, [File_Status] [int] NULL, [Name] [nvarchar](128) NOT NULL, [Filename] [nvarchar](260) NOT NULL, [Status] [nvarchar](128) NULL, [Updateability] [nvarchar](128) NULL, [User_Access] [nvarchar](128) NULL, [Recovery] [nvarchar](128) NULL )INSERT INTO [tempdb].[dbo].[HoldforEachDB] EXEC sp_MSforeachdb 'SELECT CONVERT(char(100), SERVERPROPERTY(''Servername'')) AS Server, ''?'' as DatabaseName,( select suser_sname(sid) from master.dbo.sysdatabases where name=''?'' ) ,[?]..sysfiles.size*8/1024 as size_mb, [?]..sysfiles.status, [?]..sysfiles.name, [?]..sysfiles.filename,convert(sysname,DatabasePropertyEx(''?'',''Status'')) as Status, convert(sysname,DatabasePropertyEx(''?'',''Updateability'')) as Updateability, convert(sysname,DatabasePropertyEx(''?'',''UserAccess'')) as User_Access, convert(sysname,DatabasePropertyEx(''?'',''Recovery'')) as Recovery From [?]..sysfiles ' SELECT * FROM [tempdb].[dbo].[HoldforEachDB]
select * from master..sysusers
FROM tempdb.dbo.sysobjects
WHERE id = OBJECT_ID(N'[tempdb].[dbo].[HoldforEachDB]') )
DROP TABLE [tempdb].[dbo].[HoldforEachDB] ;
CREATE TABLE [tempdb].[dbo].[HoldforEachDB]
(
[Server] [nvarchar](128) NULL,
[DatabaseName] [nvarchar](128) NOT NULL,
[Owner] [nvarchar](128) Not NULL,
[Size_MB] [int] NOT NULL,
[File_Status] [int] NULL,
[Name] [nvarchar](128) NOT NULL,
[Filename] [nvarchar](260)
NOT NULL,
[Status] [nvarchar](128)
NULL,
[Updateability] [nvarchar](128)
NULL,
[User_Access] [nvarchar](128)
NULL,
[Recovery] [nvarchar](128)
NULL
)INSERT INTO [tempdb].[dbo].[HoldforEachDB]
EXEC sp_MSforeachdb 'SELECT CONVERT(char(100), SERVERPROPERTY(''Servername'')) AS Server,
''?'' as DatabaseName,( select suser_sname(sid) from master.dbo.sysdatabases where name=''?'' ) ,[?]..sysfiles.size*8/1024 as size_mb, [?]..sysfiles.status, [?]..sysfiles.name, [?]..sysfiles.filename,convert(sysname,DatabasePropertyEx(''?'',''Status'')) as Status,
convert(sysname,DatabasePropertyEx(''?'',''Updateability'')) as Updateability,
convert(sysname,DatabasePropertyEx(''?'',''UserAccess'')) as User_Access,
convert(sysname,DatabasePropertyEx(''?'',''Recovery'')) as Recovery From [?]..sysfiles '
SELECT *
FROM [tempdb].[dbo].[HoldforEachDB]
得到你所要的信息sp_helpdb 数据库名创建数据库的用户 怎么得到呢?
没看懂