Forum Replies Created

Viewing 15 posts - 14,851 through 14,865 (of 39,970 total)

  • RE: Cannot drop SQL table

    Few choices.

    1. Can you rename the table? You could leave it in the db and ignore it. NOTE: I would not recommend this.

    2. Call MS CSS, spend the $500 or...

  • RE: Backup - Full and Diff Question

    The note from Dev should be correct. However if you are worried, run another full now. If that full backup from 11/26 has issues, you might be stuck.

    Extra full backups...

  • RE: Are the posted questions getting worse?

    Cadavre (12/6/2011)


    Can someone take over from me here please? I've had enough of trying to draw blood from a stone, maybe I'm phrasing things incorrectly?

    give up.

    Prolonging or repeating yourself...

  • RE: Are the posted questions getting worse?

    george sibbald (12/6/2011)


    I was first 🙂

    You were, and I've chimed in with Gail.

  • RE: Transaction Log Issue -- Please Help

    A second vote for Gail's post. You need to determine the reason the log is growing. If it's replication, then you need to clear that or solve the issues before...

  • RE: Set up production sql server

    You check the maximum memory that the OS can see. If you don't know how to do that, search for it. It's a basic item to check, and if you...

  • RE: SQL Saturday #104 - Colorado Springs

    Good catch, Carla. It was on the main page, but not in the article. I've added it, and I'll miss it as well :(, already have vacation scheduled that weekend...

  • RE: Layers of Security

    djackson 22568 (12/6/2011)


    Vendors still push for "sa" accounts for access and there is little I can do when I am told to implement a system with that poor of a...

  • RE: No Overtime

    sqlnyc (12/6/2011)


    Steve - I'm not sure where you're located, but here in NYC, some financial institutions implement what is known as a "professional day". In case this is foreign to...

  • RE: Encryption Key

    There is a lot more to encryption than creating a Database Master Key and a certificate. You, in general, don't want to encrypt data with a certificate or asymmetrical key...

  • RE: Set up production sql server

    I agree with Grant. Leave 2GB for the OS, then set the rest for SQL Server. You can also look at what SQL Server lists for the Target SQL Server...

  • RE: Help me with a code, please

    A couple of things. The month of payment, is that a date?

    Also, where does the beginning wage come from? Is that supplied by you?

    You don't have a SELECT that retrieves...

  • RE: delete .ldf files

    you cannot directly delete the log files. You need to empty them with log backups and ensure the one file you need is the active file.

    Also, make sure if you...

  • RE: High-level overview question - important SQL topics?

    Books Online is a good resource for getting started, as is this site. Use the searches to pick a topic and learn.

  • RE: Encryption Key

    SQL Server doesn't encrypt backups unless you have TDE enabled and then the key is auto-generated. You do need to back this up.

    The native SQL Server backup just uses passwords,...

Viewing 15 posts - 14,851 through 14,865 (of 39,970 total)