What’s Changed?

Someone fobbing you off saying nothing has changed ?

This script displays
the most recent object changes in the last nnn days.

Example
sp_objects 10
Will show any objects that have been (dropped and) created in
the last
10 days.

use master
go
if exists (select * from
sysobjects where id =
object_id(‘dbo.sp_objects’) and sysstat & 0xf =
4)
drop procedure dbo.sp_objects
GO

/****** Object: Stored
Procedure dbo.sq_objects Script Date:
04-Mar-98 1:46:20 PM
******/
create proc sp_objects @days int=9999 as
declare @msg
varchar(255)
select @msg=upper(db_name()) + ‘ objects changed in the last ‘ +

convert(varchar(30),@days) + ‘ days’
print @msg
select
@msg=replicate(‘=’,datalength(@msg))
print @msg
print ‘ ‘
select
Name=name,
Created=crdate,
Type=
case
when type=’C’ then ‘CHECK
constraint’ when type=’D’ then ‘Default
or DEFAULT constraint’ when type=’F’
then ‘FOREIGN KEY constraint’
when type=’K’ then ‘PRIMARY KEY or UNIQUE
constraint’ when
type=’L’ then ‘Log’ when type=’P’ then ‘Stored procedure’
when
type=’R’ then ‘Rule’ when type=’RF’ then ‘Stored procedure for

replication’ when type=’S’ then ‘System table’ when type=’TR’ then

‘Trigger’ when type=’U’ then ‘User table’ when type=’V’ then
‘View’ else
type
end
from sysobjects
where datediff(dd,crdate,getdate()) < @days
order by crdate desc
print ‘ ‘

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles