Re: reading a SQL log file

From: JaiGanesh Srinivasam (jaigan@teledata-usa.com)
Date: 05/14/02 

From:     JaiGanesh Srinivasam <jaigan@teledata-usa.com>
Date: Tue, 14 May 2002 06:55:23 -0700

i already got it...
thnx...but it can not read other database other than

Northwind and pubs

but we can do it in sql itself

dbcc log(<databasename>, type=3)

will give u the log

jai

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
    ... Master, msdb, Northwind and pubs are set to Simple recovery. ... the transaction log can not be backed up, which causwes the error you see. ... looking in database maintenance plans history i ...
    (microsoft.public.sqlserver.server)
  • Re: stored proc question
    ... >use northwind ... >use pubs ... >> As I was implementing a sproc to one of my database, ...
    (microsoft.public.sqlserver.server)
  • Re: Sample ETL Advice
    ... Thank you for the data generator. ... possible to use Northwind or pubs, since neither database seems to be ...
    (microsoft.public.sqlserver.dts)
  • Re: Sample ETL Advice
    ... possible to use Northwind or pubs, since neither database seems to be ... included with SQL 2005? ...
    (microsoft.public.sqlserver.dts)
  • Re: reading a SQL log file
    ... If you are on SQL 2000, ... >Northwind and pubs ...
    (microsoft.public.sqlserver.security)
Quantcast