Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tomnmoore
Starting Member
3 Posts |
 Posted - 2008-04-08 : 17:19:07
|
| So here is my dilemma:We have licensed software from a 3rd party and we do not have the source code, nor can we do anything to change the database schema, write our own procs, triggers, etc. With that said, we want to know which records in certain tables have been added or modified since a certain time (for example, in the past 24 hours). However, none of the tables has any datetime or timestamp columns on them for create date, update date, etc. I tried to look into hacking thru DBCC log (dbname, 2) to see if that would help, what a mess. Using a tool like that from Luminent or Red Gate doesnt help either, because long term this needs to be automated if possible. Does anyone have any ideas on how to do this, or is the answer simply, "Sorry mate, you need to get them to allow you to change the database to add new columns and/or triggers". :) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-08 : 17:36:58
|
| You can probably do it with the profiler.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 19:29:19
|
| Well you can only find the last modified date with query:select name,modify_date from sys.objectswhere type = 'U' for tables--type ='P' for SPand soon. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-09 : 20:49:01
|
quote:
Originally posted by sodeep
Well you can only find the last modified date with query:select name,modify_date from sys.objectswhere type = 'U' for tables--type ='P' for SPand soon.
that won't tell you when the data in the table was modified. it will tell you when the schema for a table was last modified (someone added a column, etc). or the last time a proc was altered.
elsasoft.org |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 21:36:21
|
| Ok |
|
|
|
tomnmoore
Starting Member
3 Posts |
Posted - 2008-04-22 : 17:09:02
|
| Thanks for the replies. We pushed back and are using a trigger based system. |
|
|
|
|
|
|
|
|
Help with finding out latest changes