Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Oct 2, 2000

What's Changed?

By Alan Enderby

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 ' '



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM