这个问题还不简单吗?就是把系统表和用户表进行关联就可以了,用下面的语句、SELECT dbo.sysusers.uid, dbo.sysobjects.name, dbo.sysusers.name AS UName FROM dbo.sysobjects INNER JOIN dbo.sysusers ON dbo.sysobjects.uid = dbo.sysusers.uid
SELECT host_name() AS A ,dbo.sysusers.uid, dbo.sysobjects.name, dbo.sysusers.name AS UName FROM dbo.sysobjects INNER JOIN dbo.sysusers ON dbo.sysobjects.uid = dbo.sysusers.uid ,你觉得这样可以吗?
TO:noviceliu 谢谢您的关注,呵呵 ^^
SELECT sysobjects.name,sysusers.name FROM sysobjects INNER JOIN sysusers ON sysobjects.uid = sysusers.uid WHERE sysobjects.xtype = 'U'这样?
use master select loginname,updatedate from syslogins
select crdate,[name] from sysobjects where xtype = 'p'可以查出存储过程的创建时间,修改的不会差。
sysobjects
syssegments
sysconstraints
FROM dbo.sysobjects INNER JOIN
dbo.sysusers ON dbo.sysobjects.uid = dbo.sysusers.uid
你理解有误我要的是 host_name() 这个
这位高手!你变出来一个给我看看吧,谢谢顺便:host_name() 我要的是 主机名
FROM dbo.sysobjects INNER JOIN
dbo.sysusers ON dbo.sysobjects.uid = dbo.sysusers.uid ,你觉得这样可以吗?
谢谢您的关注,呵呵 ^^
sysusers ON sysobjects.uid = sysusers.uid
WHERE sysobjects.xtype = 'U'这样?
use master
select loginname,updatedate from syslogins
select crdate,[name] from sysobjects where xtype = 'p'可以查出存储过程的创建时间,修改的不会差。