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

  • Article

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