Monitoring Changes in SP, Table and Views

27 Jan 2006 1:09 PM

Mehul Gurjar

Hello,
I would like to monitor the changes in current SQL Server Database
Objets like Tables, Stored Procedures, views and Triggers. I would like to
store the information in one table and would like to get the report.

How can i do this?

27 Jan 2006 3:53 PM

Ryan

Your best bet is via 3rd party tools. Take a look at the offerings of
lumigent. www.lumigent.com

--
HTH. Ryan

Show quote

"Mehul Gurjar" <Mehul Gur***@discussions.microsoft.com> wrote in message
news:4C2A4D8D-BE04-4B66-9D95-6A631C11A6B9@microsoft.com...
> Hello,
> I would like to monitor the changes in current SQL Server Database
> Objets like Tables, Stored Procedures, views and Triggers. I would like to
> store the information in one table and would like to get the report.
>
> How can i do this?
>

2 Feb 2006 10:31 AM

Mehul Gurjar

Hello Ryan,

        Thanks for the response. But can i do this using SQL server only.
The third party tool will either monitor the Changes using Processes and will
be storing the Data in some database only. We have Jobs, Stored procedures
and we can run the processes from the SQL server only.

        Do we have any other method except the third party tool ?

        If we can do this, we can use it to all other client's environment
and can monitor the changes.

With regards,

Show quote

"Ryan" wrote:

> Your best bet is via 3rd party tools. Take a look at the offerings of
> lumigent. www.lumigent.com
>
>
> --
> HTH. Ryan
> "Mehul Gurjar" <Mehul Gur***@discussions.microsoft.com> wrote in message
> news:4C2A4D8D-BE04-4B66-9D95-6A631C11A6B9@microsoft.com...
> > Hello,
> > I would like to monitor the changes in current SQL Server Database
> > Objets like Tables, Stored Procedures, views and Triggers. I would like to
> > store the information in one table and would like to get the report.
> >
> > How can i do this?
> >
>
>
>

2 Feb 2006 10:49 AM

Uri Dimant

In SQL Server 2005 you can take a lookn at modify_date in sys.all_objects
catalog view
MS wrote that you can see the changes if you use an ALTER statement, however
modify_date will be changed if you did it direclty in the object by right
click----Modify ( I checked views) as well.

Show quote

"Mehul Gurjar" <MehulGur***@discussions.microsoft.com> wrote in message
news:8F3AF150-AB1F-423C-B863-94D5A7010AE3@microsoft.com...
> Hello Ryan,
>
>        Thanks for the response. But can i do this using SQL server only.
> The third party tool will either monitor the Changes using Processes and
> will
> be storing the Data in some database only. We have Jobs, Stored procedures
> and we can run the processes from the SQL server only.
>
>        Do we have any other method except the third party tool ?
>
>        If we can do this, we can use it to all other client's environment
> and can monitor the changes.
>
> With regards,
>
> "Ryan" wrote:
>
>> Your best bet is via 3rd party tools. Take a look at the offerings of
>> lumigent. www.lumigent.com
>>
>>
>> --
>> HTH. Ryan
>> "Mehul Gurjar" <Mehul Gur***@discussions.microsoft.com> wrote in message
>> news:4C2A4D8D-BE04-4B66-9D95-6A631C11A6B9@microsoft.com...
>> > Hello,
>> >       I would like to monitor the changes in current SQL Server
>> > Database
>> > Objets like Tables, Stored Procedures, views and Triggers. I would like
>> > to
>> > store the information in one table and would like to get the report.
>> >
>> > How can i do this?
>> >
>>
>>
>>

Monitoring Changes in SP, Table and Views - Server Objects