Forum Replies Created

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

  • RE: Sending E-Mail from SQL 2008 Express

    Passing in a comma separated list of recipients is good and well if you were hard-coding them, but it would become more work if it were queried from a table....

  • RE: Snapshots

    I agree with palotaiarpad

  • RE: Process to truncate transaction log of replicated database

    Actually you need to run a full backup AFTER truncating the transaction log in order for the tlog backups to run because you have broken the log chain.

  • RE: Process to truncate transaction log of replicated database

    As mentioned in previous posts the methods described in the article are quite drastic and the article IMHO should caution readers and describe possible unintended side affects. "Resetting" replication...

  • RE: Restart Log Backups

    Great question. If I wanted to start performing tlog backups on a database yesterday I would automatically run a full backup after setting to full recovery model. Today...

  • RE: Transactions 2

    Great question! You'd be surprised to know how many SQL developers think if any error is encountered within a transaction it automatically gets rolled back like when XACT_ABORT is...

  • RE: SELECT options

    Good question. Didn't know about the WITH TIES clause.

  • RE: Foreign key

    My 2 cents... The question is either ambiguous or the answer is wrong. I know that you can't a FK constraint across databases. My interpretation of a...

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