Get a list of changed records in a table

Is there a way to get a list of records that have changed since a specific
Date/Time?
I could create a trigger and a new table and work off that data but I have a
lot of tables I want to query so I don't necessarily want to create triggers
for each one.You cannot get this unless you have a datetime column on the table that you
update when data changes. or a triggering mechanism to store changed data.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Bishop" <nospam@.nospam.com> wrote in message
news:e9zRyVwqIHA.3900@.TK2MSFTNGP05.phx.gbl...
> Is there a way to get a list of records that have changed since a specific
> Date/Time?
> I could create a trigger and a new table and work off that data but I have
> a lot of tables I want to query so I don't necessarily want to create
> triggers for each one.
>|||> Is there a way to get a list of records that have changed since a specific
> Date/Time?
No, SQL Server does not keep this information for you automagically.
> I could create a trigger and a new table and work off that data but I have
> a lot of tables I want to query so I don't necessarily want to create
> triggers for each one.
If you allow ad hoc access to your tables, then this is how it's done, I'm
afraid. If you deny INSERT/UPDATE rights to the table and force those
actions through stored procedures, then you could perform the logging within
a stored procedure, which at least avoids some of the problems with doing
this in a trigger. But for DELETE you would have to log to a separate table
or use a trigger.
While it doesn't help you today, SQL Server 2008 will have several options
to make this easier... from change tracking and change data capture to the
extreme of audit all actions.
A|||You could use the new OUTPUT clause to automatically pump the pre-existing
data into another table and then query that 2nd table
--
Sincerely,
John K
Knowledgy Consulting
http://knowledgy.org/
Atlanta's Business Intelligence and Data Warehouse Experts
"Bishop" <nospam@.nospam.com> wrote in message
news:e9zRyVwqIHA.3900@.TK2MSFTNGP05.phx.gbl...
> Is there a way to get a list of records that have changed since a specific
> Date/Time?
> I could create a trigger and a new table and work off that data but I have
> a lot of tables I want to query so I don't necessarily want to create
> triggers for each one.
>

Generate Executed Subscriptions Report.

Hi
Now i need a report of executed subscriptions in specific shared schedules,
Someone have something to parse Subscriptions table or only way is consuming
webservice?
Someone have an idea?
I program a module to get subscriptions (with lastexecution, emails, report
name, etc.) but i need a report.
--
Carlos E. Mosquera
DBA - Project Manager
BAC PanamáThere is a RSExecution DTS Package under tools that comes with SQL Reporting
services.. Have you looked into it..?
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:9940F556-770B-4DD4-8C73-BDF4F2B263CC@.microsoft.com...
> Hi
> Now i need a report of executed subscriptions in specific shared
schedules,
> Someone have something to parse Subscriptions table or only way is
consuming
> webservice?
> Someone have an idea?
> I program a module to get subscriptions (with lastexecution, emails,
report
> name, etc.) but i need a report.
> --
> Carlos E. Mosquera
> DBA - Project Manager
> BAC Panamá|||Hi RK,
Where i can find info about this tool?
Thanks for you help.
"RK Balaji" wrote:
> There is a RSExecution DTS Package under tools that comes with SQL Reporting
> services.. Have you looked into it..?|||Hi RK,
Where i can find info about this tool?
Thanks for you help.
"RK Balaji" wrote:
> There is a RSExecution DTS Package under tools that comes with SQL Reporting
> services.. Have you looked into it..?|||Hi all,
Someone know about this RSExecution DTS Package?
Thanks.
"Carlos E. Mosquera" wrote:
> Hi RK,
> Where i can find info about this tool?
> Thanks for you help.
> "RK Balaji" wrote:
> > There is a RSExecution DTS Package under tools that comes with SQL Reporting
> > services.. Have you looked into it..?