帮我写个存储过程

use master
go
SELECT name
FROM sysdatabases
go
这是所有的数据库
SELECT name
FROM sysobjects
这是数据库中所有的对象

create procedure haha
as
begin
use master
select
name as [数据库的名称],
dbid as [数据库 ID],
sid as [数据库创建者的系统 ID],
status as [状态位],
crdate as [创建日期],
reserved as [留作以后使用],
cmptlevel as [数据库的兼容级别],
filename as [主文件路径和名称],
version as [创建数据库的 SQL Server 版本号]
from sysdatabases
select
name as [表名],
Id as [对象标识号],
uid as [所有者对象的用户 ID],
parent_obj as [父对象的对象标识号],
crdate as [创建日期]
from sysobjects
where xtype='U' or xtype='S'
end

execute haha

感觉得没多少用!