Logging user activity

I want to find out how to turn/configure logging so I can "see" who makes
changes to the databases. Thanks
Run profiler all the time and log to a table or use a product like
Lumigent's Entegra.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick R." <PatrickR@.discussions.microsoft.com> wrote in message
news:CBA06229-DC30-4773-A460-831ABB1115E2@.microsoft.com...
>I want to find out how to turn/configure logging so I can "see" who makes
> changes to the databases. Thanks
|||Patrick R. wrote:
> I want to find out how to turn/configure logging so I can "see" who makes
> changes to the databases. Thanks
If you want to "see" who makes changes to the database, you'll have to
create an audit mechanism on the tables that you want to track. See
http://www.nigelrivett.net/AuditTrailTrigger.html
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Logging user activity

I want to find out how to turn/configure logging so I can "see" who makes
changes to the databases. ThanksRun profiler all the time and log to a table or use a product like
Lumigent's Entegra.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick R." <PatrickR@.discussions.microsoft.com> wrote in message
news:CBA06229-DC30-4773-A460-831ABB1115E2@.microsoft.com...
>I want to find out how to turn/configure logging so I can "see" who makes
> changes to the databases. Thanks|||Patrick R. wrote:
> I want to find out how to turn/configure logging so I can "see" who makes
> changes to the databases. Thanks
If you want to "see" who makes changes to the database, you'll have to
create an audit mechanism on the tables that you want to track. See
http://www.nigelrivett.net/AuditTrailTrigger.html
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Logging user activity

I want to find out how to turn/configure logging so I can "see" who makes
changes to the databases. ThanksRun profiler all the time and log to a table or use a product like
Lumigent's Entegra.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Patrick R." <PatrickR@.discussions.microsoft.com> wrote in message
news:CBA06229-DC30-4773-A460-831ABB1115E2@.microsoft.com...
>I want to find out how to turn/configure logging so I can "see" who makes
> changes to the databases. Thanks|||Patrick R. wrote:
> I want to find out how to turn/configure logging so I can "see" who makes
> changes to the databases. Thanks
If you want to "see" who makes changes to the database, you'll have to
create an audit mechanism on the tables that you want to track. See
http://www.nigelrivett.net/AuditTrailTrigger.html
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Logging of Schema changes

Is there a way to log any schema changes on databases(Eg change in datatype in a database) and who made the change?
Regards
Jonas
Hi,
There is no functinality build in to audit schema changes in SQL Server. But
you could try the free utility by Lumigent. (utility is "Lumigent Schema
Alert")
Download and test it from :
http://www.lumigent.com/downloads/schemaalert/
Thanks
Hari
MCDBA
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:ECD9EE38-ACC0-4899-92A1-34CAB7BEFDE8@.microsoft.com...
> Is there a way to log any schema changes on databases(Eg change in
datatype in a database) and who made the change?
> Regards
> Jonas
|||also check out www.dbghost.com for database configuration and change management.

Logging of Schema changes

Is there a way to log any schema changes on databases(Eg change in datatype
in a database) and who made the change?
Regards
JonasHi,
There is no functinality build in to audit schema changes in SQL Server. But
you could try the free utility by Lumigent. (utility is "Lumigent Schema
Alert")
Download and test it from :
http://www.lumigent.com/downloads/schemaalert/
Thanks
Hari
MCDBA
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:ECD9EE38-ACC0-4899-92A1-34CAB7BEFDE8@.microsoft.com...
> Is there a way to log any schema changes on databases(Eg change in
datatype in a database) and who made the change?
> Regards
> Jonas|||also check out www.dbghost.com for database configuration and change managem
ent.

Logging of Schema changes

Is there a way to log any schema changes on databases(Eg change in datatype in a database) and who made the change
Regard
JonasHi,
There is no functinality build in to audit schema changes in SQL Server. But
you could try the free utility by Lumigent. (utility is "Lumigent Schema
Alert")
Download and test it from :
http://www.lumigent.com/downloads/schemaalert/
Thanks
Hari
MCDBA
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:ECD9EE38-ACC0-4899-92A1-34CAB7BEFDE8@.microsoft.com...
> Is there a way to log any schema changes on databases(Eg change in
datatype in a database) and who made the change?
> Regards
> Jonas|||also check out www.dbghost.com for database configuration and change management.

Logging of logon success filling up logs.

How can I turn off the logging of succesfull user logon to the databases?
This is filling up both the SQL logs and the Application event logs.
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 17055
Date: 12/07/2003
Time: 2:14:14 PM
User: N/A
Computer: ***
Description:
18454 :
Login succeeded for user '*********'. Connection: Non-Trusted.
--
John Tolmachoff
MCSE, CSSA
Owner Consultant/Engineer
eServices For YouIn enterprise manager server properties ecurity set the audit level to
not log successful logons.
Nigel Rivett (SQL Server MVP)
www.nigelrivett.net
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!