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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Oversee DB progress

Author  Topic 

skypq
Starting Member

1 Post

Posted - 2009-01-12 : 14:48:24
Hello everyone. I'm new to this forum and new to SQL (or you can say I know almost nothing).

I'm not a programmer however I have a group of peers who are currently working on the database for several clients. Every day, they send me an update of what they're working on for the date in *.mdf and *.ldf file. I have MS SQL 2005 Express install and can view the *.mdf file structures and other things. However my question is, is there a way for me see what they have done each day? Is there anything like transaction log or similar to see how much coding has been coded each day, etc...?
Thank you for your time.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-12 : 23:26:16
Yes you can with the help of DDL and DML triggers.
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-13 : 03:41:27
As sodeep says you can create some special triggers that will capture all events like CREATE TABLE and ALTER PROCEDURE and all that kind of stuff. Here are a few links you can look at:

http://www.sqlteam.com/article/using-ddl-triggers-in-sql-server-2005-to-capture-schema-changes

http://technet.microsoft.com/en-us/library/ms190989.aspx



- Lumbago
Go to Top of Page
   

- Advertisement -