October 14, 2002 at 4:27 am
Have you looked at the new freeware tool Lumigent released?
Andy
October 14, 2002 at 7:00 am
Thanks all of you whoever responded. I think I will go with query which is working fine now.
October 14, 2002 at 10:51 am
Keep in mind, crdate doesn't change unless there is a create involved. If an alter table is used, then no crdate change is made.
Steve Jones
October 14, 2002 at 11:47 am
I hate tooting my own horn but I have a script posted here that does just what is being described that works great for me. Hope it helps here as well.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
October 17, 2002 at 4:58 am
quote:
Have you looked at the new freeware tool Lumigent released?Andy
http://www.sqlservercentral.com/columnists/awarren/
Its not working for sql 7
October 17, 2002 at 6:37 am
David,
I have been using your script for a few months now, and like it a lot (thanks!). Unfortunately, it doesn't capture any objects that were ALTERed, which is one of my main interests. I picked up on this thread because I'm looking to find a way to capture things that were altered and probably dropped too. We are a SQL Server 7.0 shop and will be for awhile, otherwise I'd be using Lumigent's tool. I don't want to do the 'trigger thing', but I'm not sure that there is any other way to know when an object has been altered. To the original poster of this thread, I would recommend trying out David's script.
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply