Re: Who made changes to the database

Dave
I'd sugget you to keep all object's script into VSS (Source Safe) where you
can back to the previous version


If we are talking about the data (not a structure's change) ,so you need to
handle it by using triggers and insert the data into Audit Tables





"Dave" <dave@xxxxxxxx> wrote in message
news:uLJYE%239rGHA.4660@xxxxxxxxxxxxxxxxxxxxxxx
yeah , it's SQL 2000

can I use the profiler to see changes that have already been made or do I
need to set it up for that beforehand?

Thanks for your help,
Dave

"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:%23yV5Y%238rGHA.4208@xxxxxxxxxxxxxxxxxxxxxxx
Dave
Is it SQL Server 2000?

If it is, SQL Server does not track such info , you will have to use SQL
Server Profiler to see what is going on



"Dave" <dave@xxxxxxxx> wrote in message
news:umbSIg8rGHA.4324@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

there have been some changes made to a DB of ours and I'm trying to find
out which user is responsible. I didn't have C2 auditing active (I do
now ;) ). Is there a way to extract this information from the database?

Thanks for your help,
Dave








.

Relevant Pages

  • RE: VSS Errors using NTBackup
    ... A Volume Shadow Copy Service (VSS) update package is available for Windows ... regsvr32 /i swprv.dll ... Click Start, point to Programs, point to Microsoft SQL Server, and then ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: starting with sourcesafe
    ... how do you source-control your SQL Server schema, views, etc. in CVS? ... All 3rd party SQL Server version control products I've seen use VSS and ... For this I'm considering to install VSS on our server. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Connecting VSS to Query Analyzer
    ... VSS has a CLI that can be used to integrate with SQL QA. ... SQL Server MVP ... > Anyone know of a way to connect Visual Source Safe to query analyzer? ...
    (microsoft.public.sqlserver.tools)
  • Re: Tracking changes in stored procedures within Visual Source Safe
    ... Not sure if this is the group to ping at for VSS related queries. ... inhouse tool that will take the latest and run it on the SQL Server ... My application has a lot of Stored Procedures and user ... > I would really like to hear what developers have been doing out there. ...
    (microsoft.public.sqlserver.programming)
  • Re: Database change management process
    ... plus VS and Visual Source Safe costs an assload. ... your other environments via a controlled process (i.e. DBA applies database ... processes of change control for sql server databases and so on... ...
    (microsoft.public.sqlserver)