PROJECT SERVER. CONSULTA PARA OBTENER LA LISTA DE OBJETOS AÑADIDOS RECIENTEMENTE A UNA BASE DE DATOS

Buenas, En el post de hoy vamos a tratar un asunto que consideramos interesante, acerca de localizar los objetos añadidos a una base de datos, después de instalar una actualización: use DatabaseName select name, xtype, crdate from sysobjects where crdate > <Date> order by xtype Por ejemplo: use ProjectServer_Published select name, xtype, crdate from sysobjects where crdate > ‘2009-02-15’ order by xtype Object type: AF Aggregate function (CLR) C CHECK constraint D DEFAULT (constraint or stand-alone) F FOREIGN KEY constraint PK PRIMARY KEY constraint P SQL stored procedure PC Assembly (CLR) stored procedure FN SQL scalar function FS Assembly (CLR) scalar function FT Assembly (CLR) table-valued function R Rule (old-style, stand-alone) RF Replication-filter-procedure S System base table SN Synonym SQ Service queue TA Assembly (CLR) DML trigger TR SQL DML trigger IF SQL inline table-valued function TF SQL table-valued-function U Table (user-defined) UQ UNIQUE constraint V View X Extended stored procedure IT Internal table Esperamos os resulte de utilidad. Un saludo Jorge Puig