Forum Replies Created

Viewing 15 posts - 1 through 15 (of 115 total)

  • RE: SAP requires SQL sysadmin to work

    Anyone ?

  • RE: Replication not workiing

    Lempster (1/30/2014)


    MarvinTheAndriod (1/30/2014)


    The Publication that say "The initial snapshot for publication is not yet available." is the one that isn't working.

    Should I reintialise again. Is it worth starting the...

  • RE: Replication not workiing

    The Publication that say "The initial snapshot for publication is not yet available." is the one that isn't working.

    Should I reintialise again. Is it worth starting the snapshot agent...

  • RE: Replication not workiing

    Ankit Mathur-481681 (1/29/2014)


    Can't you confirm if updated data is flowing by updating a record on Server A and querying for the same record in Server B.

    If the value stands updated...

  • RE: Replication not workiing

    Suresh B. (1/29/2014)


    Right click on the subscription and select "View synchronization status"

    I clicked on the subscriptions and selected "View synchronization status"

    For most of the subscriptions it said:

    No replicated transactions are...

  • RE: logical consistency-based I/O error

    The EXP_TRV had a truncation run on it a few days before the error occurred. It was something suggested by our supplier, after The growth of the data in this...

  • RE: logical consistency-based I/O error

    Msg 8939, Level 16, State 98, Line 1

    Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -8578841379021586432 (type Unknown), page (19720:-1112196647). Test (IS_OFF (BUF_IOERR, pBUF->bstat))...

  • RE: Find where Database uses CLR

    This isn't returning a CLR data type that I know is in the database. Is this query accurate, I want to find all uses of CLR in the database.

  • RE: Wiggle Room

    Unfortuately we now have to give consultants full technical interviews like we do permanent staff. Some of the consultants I have interviewed wouldn't even get a full time role if...

  • RE: DBCC CHECKDB failure

    John Mitchell-245523 (7/2/2012)


    OS error 21 means "the device is not ready", so, as the error message suggests, you probably have something wrong with your disk. I'm not sure whether...

  • RE: DBCC CHECKDB failure

    SQLKnowItAll (7/2/2012)


    carlos.sfc (7/2/2012)


    is SQL Server Running under Local system account or Domain account?

    If is running under Domain Account check permissions under SQL Server Data Folder where is located your msdb...

  • RE: DBCC CHECKDB failure

    DBCC CHECKDB

    AND

    DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS

    Same result

  • RE: Identifying location of SQL install

    Sorry but you are both wrong:

    http://geekswithblogs.net/normski_blog/archive/2007/03/01/107662.aspx

    There is a Microsoft link as well but I cannot find it. Anyone able to answer my inital question ?

  • RE: Identifying location of SQL install

    I am rehearsing DR senarios. One senario is that we have no back for the master database and have to rebuild it (we backup all our system databases, but this...

Viewing 15 posts - 1 through 15 (of 115 total)