Forum Replies Created

Viewing 15 posts - 5,656 through 5,670 (of 7,502 total)

  • RE: large transaction logs

    just open a new thread in sql2005

    Which recovery model did you use before sql2005 ?

    Keep in mind full recovery logs everything ! (also...

    August 20, 2007 at 4:00 am

    #727906

  • RE: Error: 7105

    please keep us informed regarding your tests with the sql2005 snapshot isolation level to solve this issue

    Also keep in mind you may have...

    August 20, 2007 at 3:55 am

    #727905

  • RE: Point in time restore issue - urgent

    I guess your rollback operation may be taking to long.

    If that is the case (long runnig transaction or a transaction with many logrecords),...

    July 26, 2007 at 12:44 am

    #722488

  • RE: Attempt to fetch logical page - Error

    That's SP4. (=latest sp) So this should be ok.

    IMO the DBCC CheckDB must be executed asap!

    from Books Online:

    Error 605
    Severity Level 21
    Message Text

    Attempt to fetch logical page %S_PGID in database...

    July 25, 2007 at 3:32 am

    #722196

  • RE: Point in time restore issue - urgent

    best is to start with putting your db read_only and single_user.

    USE PIT_TEST

    go

    ALTER DATABASE  PIT_TEST Set single_USER , READ_only  WITH ROLLBACK IMMEDIATE

    -- don't put a go here, because others...

    July 25, 2007 at 3:02 am

    #722192

  • RE: Attempt to fetch logical page - Error

    Indeed a dbcc checkdb would be the first action to be taken.

    If you cannot do it yourself, contact your dba-systemadmin to perform it asap.

    What's your version of sqlserver are you...

    July 23, 2007 at 4:57 am

    #721483

  • RE: Attempt to fetch logical page - Error

    - Can you provide the ddl or the query that produces this error ?

    - do you perform a checkdb on regular basis ?

    July 23, 2007 at 1:31 am

    #721443

  • RE: Ambiguous column name error

    Seems to be a flaw in sql2000

    With sql2005 SP2 + cumul HF *

    the query

    July 20, 2007 at 8:33 am

    #721148

  • RE: Ambiguous column name error

    Indeed, SQLUA-bol states

    "Column aliases in ORDER BY clause cannot be prefixed by table alias "

    With the example :

    For example, the following query executes in SQL Server 2000,...

    July 20, 2007 at 8:27 am

    #721142

  • RE: DTC Error

    did you install and configure MSDTC (control panel\add remove programs\windows components\application server)

    Keep in mind that if the sql2005 box is running with windows 2003 and the sql2000 may be running...

    July 20, 2007 at 12:00 am

    #721010

  • RE: Ambiguous column name error

    just my 2 ct

    With SQL2005 the order by in will use the column-aliasses whenever possible.

    That's why your query did not fail with sql2005 (you only specified location once in your...

    July 19, 2007 at 11:56 pm

    #721009

  • RE: Unable to launch startup trace with regread ....

    QA in this case was meanth for Query Analyser

    So when I run the sproc from query analyser, everythig works fine,

    If I schedule a...

    July 13, 2007 at 12:09 am

    #719180

  • RE: Unable to launch startup trace with regread ....

    Because we always have SQLAgent running, I've just implemented an extra job to check and launch the sox-trace proc.

    This job is scheduled to start whenever sqlagent starts.

    I've kept the startup...

    July 11, 2007 at 1:39 am

    #718517

  • RE: Please help for auditing

    Red Gate has a free "SQL Log Rescue" for SQL2000 !

    Very nice !

    July 11, 2007 at 12:56 am

    #718514

  • RE: ORACLE to MSSQL - Constraints and Tools??

    maybe it's worth to mention that MS has a free migration assistant for Oracle to SQL2005.

    I don't know if it supports the Oracle 7.3

    July 11, 2007 at 12:51 am

    #718511

Viewing 15 posts - 5,656 through 5,670 (of 7,502 total)