Forum Replies Created

Viewing 15 posts - 16 through 30 (of 1,583 total)

  • RE: Error 7929, Check statement aborted. Database contains deferred transactions.

    Oh, that's the actual table name.
    I did try restoring a copy of the database at a point it time that was about 15 minutes after the database was brought...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Error 7929, Check statement aborted. Database contains deferred transactions.

    We never did the maintenance (which is good because I'd like more time to research).
    I'm going to try and restore a copy of the database from after the service...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Replication Issues after Upgrading SQL Server 2014 with service pack2

    Has anyone ever encountered a similar issue?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Linked server permissions issue

    You can't control permissions from within your linked server connection.

    It depends on the permissions granted to the account that's on linked server (the destination).  If you want to...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Log Shipping for Disaster Recovery and Transactional backups through Commvault

    sqld-_-ba - Wednesday, January 25, 2017 3:05 PM

    We currently use Commvault to do transactional backups our important OLTP databases, and nightly diff...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Auditing copy/paste from a spreadsheet

    We all know accessing production table data is typically a bad idea, we would all probably architect things differently if we could, and we probably all would instantly revoke their...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Auditing copy/paste from a spreadsheet

    LOL - yeah that was my first thought...
    Apparently they want to audit to see how prevalent it is so that's why I thought I'd reach out here first

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: SQL running on an AWS EC2 instance

    Thanks, this is what I thought but wanted to make sure I wasn't missing the obvious.

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Training?

    I've got access to things like Skillsoft and PluralSight but with that type of training I'm still sitting here in my office and easily approachable and/or engulfed with production requests...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Training?

    Those are some I've heard of, and the types of recommendations I'm looking for - hoping to find something that I'd come out having actually learned something I could directly...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Log shipped db in suspect mode

    1. Can you provide the errors you're receiving when the secondary attempts to restore the log file?
    2. What 3rd party?  Do you mean like Idera, RedGate, or Lightspeed?
    3....

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Integration Services evaluation period has expired.

    So...seriously a silly question but does anyone know how to fill out a support ticket with Microsoft?  Every attempt I've tried on multiple browsers results in this entire section below...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Integration Services evaluation period has expired.

    This node has 3 jobs that are nearly identical...and are the only ones we have that are deployed to the MSDB store...so compare the sysjobstep's command for each and noticed...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Integration Services evaluation period has expired.

    To further this "oddness", other jobs which are using SSIS on the node are running just fine...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • RE: Integration Services evaluation period has expired.

    No, no previous existence.  I thought the same thing...perhaps it was first installed with an evaluation copy of SQL Server but don't believe it to be the case.  In any...

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 15 posts - 16 through 30 (of 1,583 total)