Objects related to DB: log

Showing posts with label log. Show all posts

Friday, March 30, 2012

ODBC Error

I am trying to reinstall MSQL Server 2000, but the
installation fails. The sqlstp.log has the message
below. I have reinstalled MDAC and the error persists. Can someone tell me
what is wrong and how to fix
it?
Sincerely,
Alvin
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql
server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
on SQL_HANDLE_ENV failed
driver={sql
server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
on SQL_HANDLE_ENV failed
driver={sql
server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
on SQL_HANDLE_ENV failed
SQL Server configuration failed.Hi
What OS and Edition are you trying to install SQL Server on? Do you have
admin rights on the machine?
Regards
Mike
"Alvin" wrote:
> I am trying to reinstall MSQL Server 2000, but the
> installation fails. The sqlstp.log has the message
> below. I have reinstalled MDAC and the error persists. Can someone tell me
> what is wrong and how to fix
> it?
> Sincerely,
> Alvin
> Starting Service ...
> SQL_Latin1_General_CP1_CI_AS
> -m -Q -T4022 -T3659
> Connecting to Server ...
> driver={sql
> server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
> [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
> on SQL_HANDLE_ENV failed
> driver={sql
> server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
> [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
> on SQL_HANDLE_ENV failed
> driver={sql
> server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
> [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
> on SQL_HANDLE_ENV failed
> SQL Server configuration failed.
>|||I am installing it on Server 2003 and yes, I have admin rights.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> What OS and Edition are you trying to install SQL Server on? Do you have
> admin rights on the machine?
> Regards
> Mike
> "Alvin" wrote:
> > I am trying to reinstall MSQL Server 2000, but the
> > installation fails. The sqlstp.log has the message
> > below. I have reinstalled MDAC and the error persists. Can someone tell me
> > what is wrong and how to fix
> > it?
> >
> > Sincerely,
> > Alvin
> >
> > Starting Service ...
> >
> > SQL_Latin1_General_CP1_CI_AS
> >
> > -m -Q -T4022 -T3659
> >
> > Connecting to Server ...
> >
> > driver={sql
> > server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
> >
> > [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
> > on SQL_HANDLE_ENV failed
> >
> > driver={sql
> > server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
> >
> > [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
> > on SQL_HANDLE_ENV failed
> >
> > driver={sql
> > server};server=DENISPUTNAMTOSH;UID=sa;PWD=;databas e=master
> >
> > [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
> > on SQL_HANDLE_ENV failed
> >
> > SQL Server configuration failed.
> >
> >

Wednesday, March 7, 2012

obtaining physical file and path using T-SQL

SQL 2000.
Is there a way to get a databases physical file names for data and log
using t-sql?
exec sp_helpdb '<database name>' returns two resultsets, the latter
would be good if I can get at the filename in the second resultset. If
anyone knows how?...
sysdatabases seems to hold the physical name for the data only. So
where is the logfile physical name stored?
I need to get the physical names into t-sql variables for later use.
Any help much appreciate.
thanks
PaulDid you look at sp_helpfile?
"Paul Fell" <penzina@.iinet.net.au> wrote in message
news:bea9531b.0308271721.7a2ea54f@.posting.google.com...
> SQL 2000.
> Is there a way to get a databases physical file names for data and log
> using t-sql?
> exec sp_helpdb '<database name>' returns two resultsets, the latter
> would be good if I can get at the filename in the second resultset. If
> anyone knows how?...
> sysdatabases seems to hold the physical name for the data only. So
> where is the logfile physical name stored?
> I need to get the physical names into t-sql variables for later use.
> Any help much appreciate.
> thanks
> Paul|||> I found all the info I needed by looking at sysdatabases and sysaltfiles
Note that the behavior (and existence!) of these tables might change in a
future release, which is why I tend to recommend using system stored
procedures (and information_schema views, where possible) rather than direct
system table access, especially if you're putting code into production.|||Agreed. But if you look at my orginal posting, you'll see I did try
sp_helpfile.
This system SP returns two recordsets. How do I get at the second
records set in my SP? I need to be able to access this data and I
don't know of a way of doing it dynamically.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message news:<#FImIRWbDHA.2580@.TK2MSFTNGP09.phx.gbl>...
> > I found all the info I needed by looking at sysdatabases and sysaltfiles
> Note that the behavior (and existence!) of these tables might change in a
> future release, which is why I tend to recommend using system stored
> procedures (and information_schema views, where possible) rather than direct
> system table access, especially if you're putting code into production.|||> This system SP returns two recordsets. How do I get at the second
> records set in my SP?
No can do. INSERT ... EXEC only picks up the first resultset. Either pick it up in a client program,
or use the source code for the proc to write your own proc.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Paul Fell" <penzina@.iinet.net.au> wrote in message
news:bea9531b.0308281845.730c942b@.posting.google.com...
> Agreed. But if you look at my orginal posting, you'll see I did try
> sp_helpfile.
> This system SP returns two recordsets. How do I get at the second
> records set in my SP? I need to be able to access this data and I
> don't know of a way of doing it dynamically.
> "Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:<#FImIRWbDHA.2580@.TK2MSFTNGP09.phx.gbl>...
> > > I found all the info I needed by looking at sysdatabases and sysaltfiles
> >
> > Note that the behavior (and existence!) of these tables might change in a
> > future release, which is why I tend to recommend using system stored
> > procedures (and information_schema views, where possible) rather than direct
> > system table access, especially if you're putting code into production.

Obtaining business hours based on start and end date

I have a transaction log that tracks issues from a call center. Each
time an issue is assigned to someone else, closed, etc. I get a time
stamp. I have these time stamps for the beginning of an issue to the
end of an issue and I'd like to determine how many business hours these
issues were open.

Issue BeginDt Enddt Total hours
1 3/29/05 5:00 PM 4/1/05 2:00 PM 69

Basically, this is the type of data I'm looking at and my hours of work
are from 7:30 - 5:00 weekdays. I need to come up with a way to remove
all nonbusiness hours, weekends, & holidays from the difference of the
two dates. Issues can span for 2-3 days or 20-30 days.

Please let me know if anyone has any ideas or has done something like
this before.

Thanks!On 1 Apr 2005 14:26:14 -0800, mitchchristensen@.gmail.com wrote:

>I have a transaction log that tracks issues from a call center. Each
>time an issue is assigned to someone else, closed, etc. I get a time
>stamp. I have these time stamps for the beginning of an issue to the
>end of an issue and I'd like to determine how many business hours these
>issues were open.
>Issue BeginDt Enddt Total hours
>1 3/29/05 5:00 PM 4/1/05 2:00 PM 69
>Basically, this is the type of data I'm looking at and my hours of work
>are from 7:30 - 5:00 weekdays. I need to come up with a way to remove
>all nonbusiness hours, weekends, & holidays from the difference of the
>two dates. Issues can span for 2-3 days or 20-30 days.
>Please let me know if anyone has any ideas or has done something like
>this before.
>Thanks!

Hi mitchchristensen,

The easiest way to do it is to use a calendar table. What that is, how
you can make it and various good ways to use it are described at Aaron's
site: http://www.aspfaq.com/show.asp?id=2519.

For this specific situation, I'd suggest the following approach:

DECLARE @.Start smalldatetime,
@.End smalldatetime
SET @.Start = '2005-03-22T17:00:00'
SET @.End = '2005-04-01T14:00:00'

SELECT DATEDIFF (minute, @.Start, @.End) / 60.0
- DATEDIFF (day, @.Start, @.End) * 14.5
- (SELECT COUNT(*)
FROM Calendar
WHERE dt > @.Start
AND dt < @.End
AND (isWeekday = 0 OR isHoliday = 1)) * 9.5

This might not be the quickes, but it has the advantage that it'spretty
straightforward: first, calculate the number of clock hours from start
to end; then subtract 14.5 hours (the time from 5:00 PM - 7:30 AM) for
each full day in the range; finally subtract another 9.5 hours (the time
from 7:30 AM to 5:00 PM) for each weekend or holiday in the range.

The assumption I made is that start and end dates will always be during
opening hours (i.e. not on weekends or on holidays and never outside the
7:30 AM - 5:00 PM range).

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)|||Hugo Kornelis (hugo@.pe_NO_rFact.in_SPAM_fo) writes:
> Hi mitchchristensen,
> The easiest way to do it is to use a calendar table. What that is, how
> you can make it and various good ways to use it are described at Aaron's
> site: http://www.aspfaq.com/show.asp?id=2519.
> For this specific situation, I'd suggest the following approach:
> DECLARE @.Start smalldatetime,
> @.End smalldatetime
> SET @.Start = '2005-03-22T17:00:00'
> SET @.End = '2005-04-01T14:00:00'
> SELECT DATEDIFF (minute, @.Start, @.End) / 60.0
> - DATEDIFF (day, @.Start, @.End) * 14.5
> - (SELECT COUNT(*)
> FROM Calendar
> WHERE dt > @.Start
> AND dt < @.End
> AND (isWeekday = 0 OR isHoliday = 1)) * 9.5

Since it seems unlikely that Mitch would like to disregard Christmas,
Thanksgiving and other holidays, Hugo solutions is very good. However,
I believe this is a solution that would work if we are for some reason
talking all Monday to Friday:

SELECT DATEDIFF (minute, @.start, @.stop) / 60.0 -
DATEDIFF (day, @.start, @.stop) * 14.5 -
DATEDIFF (week, @.start, @.stop) * 2 * 9.5

I owe Hugo's original query lot for this extension.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks for the suggestions!

Unfortunately I do need to disregard certain holidays based on the
region(I will have a holiday calendar for each region)

Also, end dates can occur on weekends or even holidays as some issues
are closed by the system based on a time parameter and the system has
no regards for whether or not it's an actual working day.

Mitch|||I have tried to do this in SQL and can tell you that you will be better
off doing it in application logic. The solution posted above performs
terribly.|||(mitchchristensen@.gmail.com) writes:
> Unfortunately I do need to disregard certain holidays based on the
> region(I will have a holiday calendar for each region)

Well, Hugo's solution should be your choice.

> Also, end dates can occur on weekends or even holidays as some issues
> are closed by the system based on a time parameter and the system has
> no regards for whether or not it's an actual working day.

Since I don't have any test data, I can't test Hugo's solution
for the case where the end date is a non a working day, but at a
glance it appers that his solution should handle this situation.

Since it was time, I repost Hugo's solution here:

DECLARE @.Start smalldatetime,
@.End smalldatetime
SET @.Start = '2005-03-22T17:00:00'
SET @.End = '2005-04-01T14:00:00'

SELECT DATEDIFF (minute, @.Start, @.End) / 60.0
- DATEDIFF (day, @.Start, @.End) * 14.5
- (SELECT COUNT(*)
FROM Calendar
WHERE dt > @.Start
AND dt < @.End
AND (isWeekday = 0 OR isHoliday = 1)) * 9.5

The complete thead can be reviewed at
http://groups.google.com/groups?dq=...0127.0.0.1%253E

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

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

Friday, February 24, 2012

Obtaining a report with alters of a table

Thank in advance!
I need to know how Can I obtanin a report or log of alters and deletes in
some tables in a time period?Hi
Use sql profiler
Under the Filters tab
set Object ID equals to the id of the table you want to audit
set text data like 'alter%, 'delete%
Hope this help
Regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Nacho" <Nacho@.discussions.microsoft.com> wrote in message
news:93E9178F-6DC9-4C42-9309-760123EB7F78@.microsoft.com...
> Thank in advance!
> I need to know how Can I obtanin a report or log of alters and deletes in
> some tables in a time period?|||Is it for Audit trail? Or you just want to have to monitor it onces in a
while to check what is happening in the system?
If for audit, you can create a new table and populate it with the
information from the table affect with an After Update, Delete trigger on
table in question. This way you can history going far back as possible. As
in new table you can track time the delete/update happened and by whom.
If it's just onces in a while thing then VT's suggestion works ;-).
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Nacho" wrote:

> Thank in advance!
> I need to know how Can I obtanin a report or log of alters and deletes in
> some tables in a time period?

Obtaining a report with alters of a table

Thank in advance!
I need to know how Can I obtanin a report or log of alters and deletes in
some tables in a time period?
Is it for Audit trail? Or you just want to have to monitor it onces in a
while to check what is happening in the system?
If for audit, you can create a new table and populate it with the
information from the table affect with an After Update, Delete trigger on
table in question. This way you can history going far back as possible. As
in new table you can track time the delete/update happened and by whom.
If it's just onces in a while thing then VT's suggestion works ;-).
Thanks!
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Nacho" wrote:

> Thank in advance!
> I need to know how Can I obtanin a report or log of alters and deletes in
> some tables in a time period?

Obtaining a report with alters of a table

Thank in advance!
I need to know how Can I obtanin a report or log of alters and deletes in
some tables in a time period?Hi
Use sql profiler
Under the Filters tab
set Object ID equals to the id of the table you want to audit
set text data like 'alter%, 'delete%
Hope this help
Regards
VT
Knowledge is power, share it...
http://oneplace4sql.blogspot.com/
"Nacho" <Nacho@.discussions.microsoft.com> wrote in message
news:93E9178F-6DC9-4C42-9309-760123EB7F78@.microsoft.com...
> Thank in advance!
> I need to know how Can I obtanin a report or log of alters and deletes in
> some tables in a time period?|||Is it for Audit trail? Or you just want to have to monitor it onces in a
while to check what is happening in the system?
If for audit, you can create a new table and populate it with the
information from the table affect with an After Update, Delete trigger on
table in question. This way you can history going far back as possible. As
in new table you can track time the delete/update happened and by whom.
If it's just onces in a while thing then VT's suggestion works ;-).
Thanks!
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Nacho" wrote:
> Thank in advance!
> I need to know how Can I obtanin a report or log of alters and deletes in
> some tables in a time period?

Obtain Info

Hi
I have SQL 2000 server Sp3 on my network, i want know if is possible obtain
major information from log file, i.e. if a user loggin to db i want know the
time/date to login, operation excute etc.
Can help me please
Tia PupoHi
Logins/Logout can be logged into the SQL Event log, but what the user
executed, you need to use Profiler for that.
Generally, for SOX compliance, people run Profiler to capture all the events
and use that to report on.
Regards
Mike
"Pupo" wrote:
> Hi
> I have SQL 2000 server Sp3 on my network, i want know if is possible obtain
> major information from log file, i.e. if a user loggin to db i want know the
> time/date to login, operation excute etc.
> Can help me please
> Tia Pupo
>
>|||Hi,
How to Enable the Audit for Logins:-
--
SQL 2000 - Open enterprise manager -- Right click on server and select
properties and then choose the Security tab and
select Audit level "ALL" and click Ok and restart SQL server service.
Operation excuted: These information can not be looged into the SQL Server
error log. But you could create the trace and schedule it to
run and log to a file. See the commands
sp_trace_create, sp_trace_setevent, sp_trace_setstatus in books online.
Thanks
Hari
SQL Server MVP
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:E2A4F98E-5C4C-46B0-BE40-EDB530C6162E@.microsoft.com...
> Hi
> Logins/Logout can be logged into the SQL Event log, but what the user
> executed, you need to use Profiler for that.
> Generally, for SOX compliance, people run Profiler to capture all the
> events
> and use that to report on.
> Regards
> Mike
> "Pupo" wrote:
>> Hi
>> I have SQL 2000 server Sp3 on my network, i want know if is possible
>> obtain
>> major information from log file, i.e. if a user loggin to db i want know
>> the
>> time/date to login, operation excute etc.
>> Can help me please
>> Tia Pupo
>>|||Thanks i try it, in others newsgroup tell me about specific programm to
monitorate log as "log explorer" someone have use it before?
Tia
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23EWsVRpPFHA.3788@.tk2msftngp13.phx.gbl...
> Hi,
> How to Enable the Audit for Logins:-
> --
> SQL 2000 - Open enterprise manager -- Right click on server and select
> properties and then choose the Security tab and
> select Audit level "ALL" and click Ok and restart SQL server service.
>
> Operation excuted: These information can not be looged into the SQL Server
> error log. But you could create the trace and schedule it to
> run and log to a file. See the commands
> sp_trace_create, sp_trace_setevent, sp_trace_setstatus in books online.
> Thanks
> Hari
> SQL Server MVP
>
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:E2A4F98E-5C4C-46B0-BE40-EDB530C6162E@.microsoft.com...
> > Hi
> >
> > Logins/Logout can be logged into the SQL Event log, but what the user
> > executed, you need to use Profiler for that.
> >
> > Generally, for SOX compliance, people run Profiler to capture all the
> > events
> > and use that to report on.
> >
> > Regards
> > Mike
> >
> > "Pupo" wrote:
> >
> >> Hi
> >> I have SQL 2000 server Sp3 on my network, i want know if is possible
> >> obtain
> >> major information from log file, i.e. if a user loggin to db i want
know
> >> the
> >> time/date to login, operation excute etc.
> >> Can help me please
> >> Tia Pupo
> >>
> >>
> >>
>|||Sounds like you are asking about this product:
http://www.lumigent.com/products/le_sql.html
It works quite well.
Steve
"Pupo" <123star@.libero.it> wrote in message
news:OBzC7VpPFHA.576@.TK2MSFTNGP15.phx.gbl...
> Thanks i try it, in others newsgroup tell me about specific programm to
> monitorate log as "log explorer" someone have use it before?
> Tia
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWsVRpPFHA.3788@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > How to Enable the Audit for Logins:-
> > --
> > SQL 2000 - Open enterprise manager -- Right click on server and select
> > properties and then choose the Security tab and
> >
> > select Audit level "ALL" and click Ok and restart SQL server service.
> >
> >
> > Operation excuted: These information can not be looged into the SQL
Server
> > error log. But you could create the trace and schedule it to
> >
> > run and log to a file. See the commands
> >
> > sp_trace_create, sp_trace_setevent, sp_trace_setstatus in books online.
> >
> > Thanks
> >
> > Hari
> >
> > SQL Server MVP
> >
> >
> > "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> > news:E2A4F98E-5C4C-46B0-BE40-EDB530C6162E@.microsoft.com...
> > > Hi
> > >
> > > Logins/Logout can be logged into the SQL Event log, but what the user
> > > executed, you need to use Profiler for that.
> > >
> > > Generally, for SOX compliance, people run Profiler to capture all the
> > > events
> > > and use that to report on.
> > >
> > > Regards
> > > Mike
> > >
> > > "Pupo" wrote:
> > >
> > >> Hi
> > >> I have SQL 2000 server Sp3 on my network, i want know if is possible
> > >> obtain
> > >> major information from log file, i.e. if a user loggin to db i want
> know
> > >> the
> > >> time/date to login, operation excute etc.
> > >> Can help me please
> > >> Tia Pupo
> > >>
> > >>
> > >>
> >
> >
>|||Hi,
You can also use Log explorer from Lumigent. Great tool to read the
transaction logs. Try it out from:-
www.Lumigent.com
Thanks
Hari
SQL Server MVP
"Pupo" <123star@.libero.it> wrote in message
news:OBzC7VpPFHA.576@.TK2MSFTNGP15.phx.gbl...
> Thanks i try it, in others newsgroup tell me about specific programm to
> monitorate log as "log explorer" someone have use it before?
> Tia
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23EWsVRpPFHA.3788@.tk2msftngp13.phx.gbl...
>> Hi,
>> How to Enable the Audit for Logins:-
>> --
>> SQL 2000 - Open enterprise manager -- Right click on server and select
>> properties and then choose the Security tab and
>> select Audit level "ALL" and click Ok and restart SQL server service.
>>
>> Operation excuted: These information can not be looged into the SQL
>> Server
>> error log. But you could create the trace and schedule it to
>> run and log to a file. See the commands
>> sp_trace_create, sp_trace_setevent, sp_trace_setstatus in books online.
>> Thanks
>> Hari
>> SQL Server MVP
>>
>> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
>> news:E2A4F98E-5C4C-46B0-BE40-EDB530C6162E@.microsoft.com...
>> > Hi
>> >
>> > Logins/Logout can be logged into the SQL Event log, but what the user
>> > executed, you need to use Profiler for that.
>> >
>> > Generally, for SOX compliance, people run Profiler to capture all the
>> > events
>> > and use that to report on.
>> >
>> > Regards
>> > Mike
>> >
>> > "Pupo" wrote:
>> >
>> >> Hi
>> >> I have SQL 2000 server Sp3 on my network, i want know if is possible
>> >> obtain
>> >> major information from log file, i.e. if a user loggin to db i want
> know
>> >> the
>> >> time/date to login, operation excute etc.
>> >> Can help me please
>> >> Tia Pupo
>> >>
>> >>
>> >>
>>
>|||Hi
Those log reader tools only can report on what was changed. If someone ran a
SELECT, it is not logged as non-data monification statements are not logged
into the transaction log.
SQL Server Profiler/Trace is the only tool that will report on everything
that is going in and out the server.
Regards
Mike
"Hari Prasad" wrote:
> Hi,
> You can also use Log explorer from Lumigent. Great tool to read the
> transaction logs. Try it out from:-
> www.Lumigent.com
> Thanks
> Hari
> SQL Server MVP
> "Pupo" <123star@.libero.it> wrote in message
> news:OBzC7VpPFHA.576@.TK2MSFTNGP15.phx.gbl...
> > Thanks i try it, in others newsgroup tell me about specific programm to
> > monitorate log as "log explorer" someone have use it before?
> > Tia
> >
> >
> > "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> > news:%23EWsVRpPFHA.3788@.tk2msftngp13.phx.gbl...
> >> Hi,
> >>
> >> How to Enable the Audit for Logins:-
> >> --
> >> SQL 2000 - Open enterprise manager -- Right click on server and select
> >> properties and then choose the Security tab and
> >>
> >> select Audit level "ALL" and click Ok and restart SQL server service.
> >>
> >>
> >> Operation excuted: These information can not be looged into the SQL
> >> Server
> >> error log. But you could create the trace and schedule it to
> >>
> >> run and log to a file. See the commands
> >>
> >> sp_trace_create, sp_trace_setevent, sp_trace_setstatus in books online.
> >>
> >> Thanks
> >>
> >> Hari
> >>
> >> SQL Server MVP
> >>
> >>
> >> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> >> news:E2A4F98E-5C4C-46B0-BE40-EDB530C6162E@.microsoft.com...
> >> > Hi
> >> >
> >> > Logins/Logout can be logged into the SQL Event log, but what the user
> >> > executed, you need to use Profiler for that.
> >> >
> >> > Generally, for SOX compliance, people run Profiler to capture all the
> >> > events
> >> > and use that to report on.
> >> >
> >> > Regards
> >> > Mike
> >> >
> >> > "Pupo" wrote:
> >> >
> >> >> Hi
> >> >> I have SQL 2000 server Sp3 on my network, i want know if is possible
> >> >> obtain
> >> >> major information from log file, i.e. if a user loggin to db i want
> > know
> >> >> the
> >> >> time/date to login, operation excute etc.
> >> >> Can help me please
> >> >> Tia Pupo
> >> >>
> >> >>
> >> >>
> >>
> >>
> >
> >
>
>

Friday, March 30, 2012

ODBC Error

ODBC Error

Wednesday, March 7, 2012

obtaining physical file and path using T-SQL

Obtaining business hours based on start and end date

Friday, February 24, 2012

Obtaining a report with alters of a table

Obtaining a report with alters of a table

Obtaining a report with alters of a table

Obtain Info

Obtain Info

Obtain Info

Obtain Info

Obtain Info

Objects related to DB

Blog Archive

About Me