that is ok maybe someone else will jump on this is what i was trying to do

select del_cmd,filter,filter_clause,ins_cmd,name, upd_cmd,upd_scripting_proc from sysarticles
 
del_cmd              filter      filter_clause       ins_cmd               name    upd_cmd            ...

i feel the same way but the person i am working for insist it does
is there a way to get this using one or two queries

sorry no specific i have someone that wants to know the publisher name,publication, tables , sp_names and filters
i was guessing i have to join sysarticles and syspublications to get...

thanks i have given up i realize there is no easy way to do this in 2005

there does not seem an easy with with it for 2005 or anything with 2005

you are and it is i posted here with title of 2005 because there is no 2005 forum

it does not work on 2005 because the code has system tables that do not exist in 2005

i get objects not found because the system tables for this in 2014 do not exist in 2005

here is my code that works on 2014
CREATE PROCEDURE [dbo].[get_crossdatabase_dependencies] AS

SET NOCOUNT ON;

CREATE TABLE #databases(
  database_id int,
  database_name sysname
);

INSERT...

when i run that against the database it returns nothing but my client says they do exist
Find the tables having Triggers starting with ‘FACTS’ and dump in excel
USALL-RS03...

thanks

no FACTS will just be in the trigger name

yes in the name of the trigger there are a lot of tables and we need a list of all triggers that contain the name FACT in the title of...

i found a way to automate it thank you

rats was hoping for a yes but it is what it is
thanks