Re: Tool for view transaction log

From: Greg Crowe (anonymous_at_discussions.microsoft.com)
Date: 03/15/04

  • Next message: Andrew L Arnott: "SQLDMO _Column.ComputedText not updating" 
    Date: Mon, 15 Mar 2004 14:05:28 -0800

    (Actually, I'd posted this before posting the new thread.)

    I did try DBCC from the Query Analyzer, and it said I
    didn't have permission. So I'm off to do battle with the
    provider to get a login that has permission. Wish me luck.

    Thanks for the quick responses!
    >-----Original Message-----
    >Greg Crowe wrote:
    >> Wait, you just said that there is no option, and then
    you
    >> implied that there is an option, but what you get isn't
    >> readable. Which is it?
    >
    >Isn't DBCC log command I referred you to before working
    for you? You may
    >run it from Query Analyzer.
    >
    >sincerely,
    >--
    >Sebastian K. Zaklada
    >Skilled Software
    >http://www.skilledsoftware.com
    >This posting is provided "AS IS" with no warranties, and
    confers no rights.
    >
    >
    >.
    >

  • Next message: Andrew L Arnott: "SQLDMO _Column.ComputedText not updating"

    Relevant Pages

    • Re: Access sometimes wont use index of linked view
      ... DBCC DBREINDEX or DBCC INDEXDEFRAG? ... SELECT * FROM foo ORDER BY fldSorting; ... If i execute this in the query analyzer, ...
      (microsoft.public.sqlserver.clients)
    • Re: Access sometimes wont use index of linked view
      ... DBCC DBREINDEX or DBCC INDEXDEFRAG? ... SELECT * FROM foo ORDER BY fldSorting; ... If i execute this in the query analyzer, ...
      (microsoft.public.sqlserver.clients)
    • Re: Timeout expired when add new record
      ... Login to query analyzer and execute the below command, ... DBCC SHOWCONTIG ... Replace the dbname and Table name with your actual. ...
      (microsoft.public.sqlserver.programming)
    • Re: Fehler 8115 beim Verkleiner einer attached Datenbank
      ... > auch nach DBCC DBCHECK bekomm ich dann im Enterprise-Manager ... ob es via DBCC SHRINKFILE im Query Analyzer ...
      (microsoft.public.de.sqlserver)
    • DBCC CHECKDB
      ... I run the DBCC for a database in Query Analyzer, ... I take the same SQL script and place it in a job through Enterprise Manager, ...
      (microsoft.public.sqlserver.clustering)