Forum Replies Created

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

  • Reply To: My New Resolution

    I guess Steve has no new years resolutions

  • Reply To: Beating the Cloud Vendors

    We do payment (CC)....  and the processors said they will  not certify us if we move to cloud.

  • Reply To: Oops, I deleted that data

    We backup the data we are going to change to a DB for that purpose only. We back up the key and any field we are going to modify, we...

  • Reply To: Printing Dates

    The option answers are all wrong but only 1 is in the proper format so I choose that.

  • RE: Detaching CDC

    George Vobr - Thursday, April 12, 2018 7:27 AM

    gary.mazzone - Thursday, April 12, 2018 6:29 AM

    April 12, 2018 at 8:58 am

    #1986603

  • RE: Detaching CDC

    According to MS docs you need to add the KEEP_CDC if reattaching to a new instance of SQL Server also needs to be Enterprise Edition or it will fail also

  • RE: Error on Backup

    All the problem is not a restore issue it is a backup issue! 
    I am using SQL Server 2016 Enterprise SP1 CU4 is applied

    I am issuing the following...

  • RE: Error on Backup

    The issue is on the primary. The cert is ok all other servers in the AG. I encrypt the DB it encrypts on all servers just will no...

  • RE: Error on Backup

    So everyone is saying that I need to bacip the cert. restore it to same machine. Restore the DB on same machine again then re-encrypt (which it currently...

  • RE: Error on Backup

    No the error is during the backup process when it reaches 100%. The same cert on the same system is used for 2 other database on the instance and...

  • RE: Error on Backup

    It is on the server the backup is running from  there are 2 others useing the same certificate on system that are backing up correctly.  If i drop the tde...

  • RE: Stretch Database Datatype Limitations

    Good question bad answer 2 != 3

  • RE: DBCC and disabled indexes

    Why are we assuming that the Clustered index is the PK for the table that is not a requirement..... What happens if the PK is not the clustered index...

  • RE: Can This Work?

    If you run the code as supplied they it fails with a syntax error. If you run each part but it's self you get a warning creating the sp1....

  • RE: Renaming a procedure

    Sorry but this is poorly worded and poorly thought out question. How do you alter a procedure that does not exist?

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