Login

following, do I work with adp, do I use the safety of the sql server to
authenticate the users, then in my front I do configure the access with my
password, for the item connection of the menu, when do I distribute that
front for each station, (do they use runtime) does the system always suggest
my name in the login, do the users complain then because every time that
they enter, t there my name, does that have solution?
ps. I didn't get to use to authenticate of the domain, I don't know because
but it didn't roll, I had to create the logins, roll, user, etc in the sql.anybody?
"Frank Dulk" <fdulk@.bol.com.br> escreveu na mensagem
news:ePLeXPUTGHA.4452@.TK2MSFTNGP12.phx.gbl...
> following, do I work with adp, do I use the safety of the sql server to
> authenticate the users, then in my front I do configure the access with my
> password, for the item connection of the menu, when do I distribute that
> front for each station, (do they use runtime) does the system always
suggest
> my name in the login, do the users complain then because every time that
> they enter, t there my name, does that have solution?
>
> ps. I didn't get to use to authenticate of the domain, I don't know
because
> but it didn't roll, I had to create the logins, roll, user, etc in the
sql.
>|||Hi Frank,
clean the connection string before distribute your front.
--
Currentproject.OpenConnection ""
--
then when you distribute reconnect it with a vba routine
bye
--
Giorgio Rancati
[Office Access MVP]
"Frank Dulk" <fdulk@.bol.com.br> ha scritto nel messaggio
news:ub02TXfTGHA.4264@.TK2MSFTNGP11.phx.gbl...
> anybody?
> "Frank Dulk" <fdulk@.bol.com.br> escreveu na mensagem
> news:ePLeXPUTGHA.4452@.TK2MSFTNGP12.phx.gbl...
my
> suggest
> because
> sql.
>

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 Sql queries

In SQLServer 2000, I am sure there was a way that you configure the
database to log to a file each query that gets run against it.
However, I cannot seen to find where to set this up in Enterprise
Manager."Mystery Man" <PromisedOyster@.hotmail.com> wrote in message
news:87c81238.0405130309.7c0013fb@.posting.google.c om...
> In SQLServer 2000, I am sure there was a way that you configure the
> database to log to a file each query that gets run against it.
> However, I cannot seen to find where to set this up in Enterprise
> Manager.

I don't know any way to do exactly what you want, but there are options:

If you're going through ODBC, you can enable ODBC logging.
You can also enable profiler to capture all the traffic.

Another option is to invest in
http://www.lumigent.com/products/le_sql/le_sql.htm|||Mystery Man (PromisedOyster@.hotmail.com) writes:
> In SQLServer 2000, I am sure there was a way that you configure the
> database to log to a file each query that gets run against it.
> However, I cannot seen to find where to set this up in Enterprise
> Manager.

The Profiler is the tool you should use. Or at least where you should
start looking. If you are seriously into log everything which happens
on the server, you should set up a server-side trace with help of
the sp_trace procedures.

Furthermore, if you cannot accept anything to be unlogged because the
trace file fills up the disk, set the C2-autiding configuration option,
which throttles the server in this situation.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp