Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Transaction Log Issues After Upgrade to SP1

    Rebuilding replication did not help.

    Some more research I've done on this so far:

    select * from sys.dm_tran_active_transactions

    152worktable2011-12-08 22:37:57.1472NULL200000NULL

    155worktable2011-12-08 22:37:57.1472NULL200000NULL

    157worktable2011-12-08 22:37:57.1472NULL200000NULL

    159worktable2011-12-08 22:37:57.1472NULL200000NULL

    162worktable2011-12-08 22:37:57.1472NULL200000NULL

    164worktable2011-12-08 22:37:57.1472NULL200000NULL

    14781user_transaction2011-12-08 23:02:19.4831NULL2025800-1NULL

    78270813SELECT2011-12-13 11:19:34.5332NULL200000NULL

    78270814SELECT2011-12-13 11:19:34.6632NULL200000NULL

    5577LobStorageProviderSession2011-12-08 23:01:57.9932NULL200000NULL

    78270291user_transaction2011-12-13 11:19:30.9831NULL2025800-1NULL

    I'm assuming that it's...

  • RE: Transaction Log Issues After Upgrade to SP1

    Jeffrey Williams 3188 (12/10/2011)


    Select log_reuse_wait_desc From sys.databases

    Using the above, that database will probably show REPLICATION. Is this database replicated - and if it is have you verified the replication...

  • RE: SQL Server 2008 Build List

    Quick question as Microsoft says one thing and the page says another (BTW, this is a great list and very helpful).

    Microsoft put out on the SP1 KB that it includes...

Viewing 3 posts - 1 through 3 (of 3 total)