Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 2,763 total)

  • RE: Create Certificate Error

    Yeah, I'd start there. I've not run into this, yet, mostly because the only certs I've needed have been for encrypting the network connection, so those go into the...

  • RE: Create Certificate Error

    If you're backing up a certificate, then SQL creates both the certificate and key files.

    So if you don't have the private key file, if you just have the cert file,...

  • RE: Create Certificate Error

    amy26 (6/15/2016)


    BAH! It didn't fix it when I changed the service to my domain admin account. I wish the error message was more specific... I assume a certificate...

  • RE: Create Certificate Error

    amy26 (6/15/2016)


    Yes, I'm trying to do it on my local database not to another server. I will check the startup accounts for the services... I think on my local...

  • RE: Create Certificate Error

    To clarify something: Is the SQL Server you're attempting to load this certificate to, also local to your PC, or is it a different system?

    If it's a different system,...

  • RE: Spreading/Spanning a SQL DB over multiple drives

    raf.figueroa (6/15/2016)


    Many thanks UDP Broadcaster,

    After reading your response, it reminded me that a viable alternative is to use RAID 0 (stripping) or JBOD.

    Cheers,

    -r

    I think you might have misunderstood me....

  • RE: Are the posted questions getting worse?

    So, just got done converting some views and table-value functions over to stored procedures that I can use instead.

    The TVFs and views are for security auditing, they're really just pre-written...

  • RE: Spreading/Spanning a SQL DB over multiple drives

    Couple thoughts on this one, leaving aside what curious_sqldba stated.

    First, are the disks Direct Attached Storage (DAS) or something else? If they're DAS, why wouldn't you be using a...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/8/2016)


    <headdesk>

    User asks me to move this bit of code into QA:

    ALTER TABLE MyTable

    ADD Col1 INT,

    Col2 INT

    GO

    I push back and say "Please add your statement...

  • RE: Silent Install - Question about parameters

    Bear in mind, this is from installing SQL2014 Enterprise from the command line, but what I use is:

    /FEATURES=SQLENGINE,IS,SSMS,ADV_SSMS

    This *does* install SSMS on the system. I would suggest make sure...

  • RE: Are the posted questions getting worse?

    Well, I'm planning to put together my own take on this, but I found someone who already invented the wheel so my take will need to be a better mousetrap...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/7/2016)


    jasona.work (6/7/2016)


    Lynn Pettis (6/7/2016)


    Jeff Moden (6/7/2016)


    Luis Cazares (6/7/2016)


    Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.

    It was almost as sarcastic as...

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/7/2016)


    jasona.work (6/7/2016)


    Luis Cazares (6/7/2016)


    Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.

    Nah. I was sorely tempted to put together a...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (6/7/2016)


    Jeff Moden (6/7/2016)


    Luis Cazares (6/7/2016)


    Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.

    It was almost as sarcastic as using LMGTFY but...

  • RE: Are the posted questions getting worse?

    Luis Cazares (6/7/2016)


    Maybe I shouldn't have post this. Or maybe they'll just stop trying to cheat on interviews.

    Nah. I was sorely tempted to put together a Powershell script to...

Viewing 15 posts - 1,516 through 1,530 (of 2,763 total)