Could you explain this in a little more detail? I am curious what...

I subscribe to SQL Server Magazine. I haven't read the article in depth, but a quick scan shows why the cursor-based solution works better than the set-based solution. ...

don_goodman (6/2/2009)

---

24 million Texans are skillfully armed and there are only about 10,000 Brits in the military and police(just guessing) and they likely don't know how to shoot. The rest...

I have to agree with Steve. Perhaps a disclaimer of some sort should be added to top of each article stating the content of the article is the opinion...

What is the value of the is_copy_only column?

Verify the recovery model of the database. Also, run this query: select * from msdb.dbo.backupset where backup_start_date > '20090602'

Steve Jones - Editor (6/2/2009)

---

Font edited, and pick me up added. You can't "regen" the symm key with the same certificate. It creates a new key, encrypted by the same...

Bob Shaw (6/2/2009)

---

Im trying to perform a transaction log backup to the same *.bak file holding the Full Database Backup. Im getting this error "BACKUP LOG cannot be performed because...

sqlguy (6/2/2009)

---

Thanks a lot for your valuable response.

Regarding backup question when I backup DMK and Certificate and regenerate the symmetric key by using the following scripts the column I was...

Regardless of recovery model, all updates, inserts, and deletes are written first to the transaction log. Which recovery model you use should be based on how much data loss...

Luke L (6/2/2009)

---

Really? I've always wanted to own a bridge, that way I could charges tolls.

But seriously, I...

Yes, you will have to create the database role in each existing user database. You can also create the role in the model database, which should then make that...

No problem. I just thought I might have missed something. Glad to hear that this works for you.

Would it be possible for you to provide more info? ...

I get 4 records back based on your sample data. Please see the code below and let me know what I missed.

CREATE TABLE dbo.Cust ( CID INT IDENTITY(1,1) PRIMARY...