Auditing IN SQL 2k

Hello
I need to record the activities/changes in certain tables in my application
including who effected the change,time, the field that was changed, the new
and old value of the field. How do i go about doing this? I need to do this
without actually making code changes in my application.
Would be quite helpful if someone could help me with clear steps as to how
this is to be done as I'm a newbie to this field.
Thanks in advance
Regds
Rachel
Take a look at
http://www.microsoft.com/technet/sec.../sql2kaud.mspx
You could also do a Google search on "SQL Server 2000 Auditing" which will
turn up alternatives. For example:
http://www.akadia.com/services/sqlsr..._auditing.html
Hal Berenson, President
PredictableIT, LLC
"rachel" <rachel@.discussions.microsoft.com> wrote in message
news:7F547B93-A7FF-4200-93DB-8980A1E8A53E@.microsoft.com...
> Hello
> I need to record the activities/changes in certain tables in my
> application
> including who effected the change,time, the field that was changed, the
> new
> and old value of the field. How do i go about doing this? I need to do
> this
> without actually making code changes in my application.
> Would be quite helpful if someone could help me with clear steps as to how
> this is to be done as I'm a newbie to this field.
> Thanks in advance
> Regds
> Rachel
>
>

Auditing IN SQL 2k

Hello
I need to record the activities/changes in certain tables in my application
including who effected the change,time, the field that was changed, the new
and old value of the field. How do i go about doing this? I need to do this
without actually making code changes in my application.
Would be quite helpful if someone could help me with clear steps as to how
this is to be done as I'm a newbie to this field.
Thanks in advance
Regds
RachelTake a look at
http://www.microsoft.com/technet/security/prodtech/sqlserver/sql2kaud.mspx
You could also do a Google search on "SQL Server 2000 Auditing" which will
turn up alternatives. For example:
http://www.akadia.com/services/sqlsrv_table_auditing.html
Hal Berenson, President
PredictableIT, LLC
"rachel" <rachel@.discussions.microsoft.com> wrote in message
news:7F547B93-A7FF-4200-93DB-8980A1E8A53E@.microsoft.com...
> Hello
> I need to record the activities/changes in certain tables in my
> application
> including who effected the change,time, the field that was changed, the
> new
> and old value of the field. How do i go about doing this? I need to do
> this
> without actually making code changes in my application.
> Would be quite helpful if someone could help me with clear steps as to how
> this is to be done as I'm a newbie to this field.
> Thanks in advance
> Regds
> Rachel
>
>

Auditing IN SQL 2k

Hello
I need to record the activities/changes in certain tables in my application
including who effected the change,time, the field that was changed, the new
and old value of the field. How do i go about doing this? I need to do this
without actually making code changes in my application.
Would be quite helpful if someone could help me with clear steps as to how
this is to be done as I'm a newbie to this field.
Thanks in advance
Regds
RachelTake a look at
http://www.microsoft.com/technet/se...r/sql2kaud.mspx
You could also do a Google search on "SQL Server 2000 Auditing" which will
turn up alternatives. For example:
http://www.akadia.com/services/sqls...e_auditing.html
Hal Berenson, President
PredictableIT, LLC
"rachel" <rachel@.discussions.microsoft.com> wrote in message
news:7F547B93-A7FF-4200-93DB-8980A1E8A53E@.microsoft.com...
> Hello
> I need to record the activities/changes in certain tables in my
> application
> including who effected the change,time, the field that was changed, the
> new
> and old value of the field. How do i go about doing this? I need to do
> this
> without actually making code changes in my application.
> Would be quite helpful if someone could help me with clear steps as to how
> this is to be done as I'm a newbie to this field.
> Thanks in advance
> Regds
> Rachel
>
>

Attatching ASPNETDB to remote server

Hi there ;

I uploaded my app to host but crashed during membership activities, and i figured out it's cause of ASPNETDB.mdf that is not accessible in remote server, & it's driving me crazy.

As a solution i wanted to know :

is it possible to attatch my db in App_Data to remote server and make use of it just like before?

Please take it into concideration that i've already tried 'aspnet_regsql.exe' and the server gives me error:40 (only local access allowed ).

thanks in advance

No, for the AttacheDBFilename property, currently remote server, HTTP, and UNC path names are not supported. In other words the attached database file must be on the local disk of the SQL machine.|||

thanks lori ,

but i didn't say that i'm goin to set a http or sth alike as db File name . my problem is that my host company doesn't allow remote connections so that i can't use aspnet_regsql.exe .so i just wanted to know that if i send ASPNETDB.mdf to remote server (not necessarily to App_Date folder ) and ask admins to attach it in there, does it work just like the aspnet_regsql.exe ?so that i can then change my connectionstring to the one that my host offers after attaching.

thanks for any help

|||Sorry for misunderstanding Yes, aspnet_sql has nothing to do with database connection for your website, we use aspnet_regsql.exe to create database objects in specified database which can be used for membership. So just make sure connection can be made to the remote SQL Server.|||

So i'll do it .

really thanks for the help

|||

i did that, one final job is to set LocalSqlServer to the new one in the remote server, to do so, follow steps:

ControlPanel > Administrative Tools > Internet Information Services > here choose your website's virtual directory that is somewhere under "Default Web Site"

then right click and choose Properties, on the rightmost tab named "ASP.NET" click the button named "Edit Configuration..." .

on the window that will open, you see the "LocalSqlServer" under "Connection string manager", and it's value is set to the ASPNETDB.mdf that is in the App_Data directory, click on it & edit it to point to the one that is on the remote server .

Generally for those, who aren't allowed to access the db remotely, the best job, i think, is to generate a copy of "ASPNETDB.mdf" locally (In case there is someone else that has taken the name ASPNETDB, change its name) & send it to your remote server and ask them to attach it, then, with the connection string they offer you can have sth like "ASPNETDB.mdf" working remotely.

Thanks lori for the help