Nice writeup and accurate. I went to the first PASS in Chicago and this one was much better. Saw some good presentations, some average, but not that many since we...

Dont' know of any. We are talking of looking at it here when we get time.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Don't use sa. Create another user and use that, give it permissions to run the job.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

And keep in mind that the key management is one of the more difficult pieces of this. Most PKI solutions have problems with this part (As well as key distro).

I'd...

Use a separate db. Couple reasons.

1. If you need to move this, or alter it, or add a tlog backup of it, you want it in a separate table.

2....

Some bugs with Parallelism. Bit me on one server and had to turn it off. There are some fixes in SP3 for this one.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Intersting link and I agree. Definitely worth the read.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

Are you sure your process is failing over to the correct master db?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

I used to be on a weekly release cycle (new build released every Wed). I scheduled a refresh from Prod to QA every Mon, 4:00am, using scripting in a DTS...

I believe the ownership chain will cross the databases if the table owners (and proc owners) are the same. This either works pre SP3 or post SP3, but not both,...

For ease and flexibility (not the tlog), I'd do it in another db on the same server. Can back it up separately and if you need to restore in a...

Thanks for the comments. When I wrote this article, I had to dig through information to find out how to do it. By presenting it, I do so for...

HA is an interesting topic. We are looking at some products and will probably expand this area soon. Time is hard to come by with just...

Sorry you didn't like the article. Pretty much everything we write about is documented somewhere, just not always easy to find and not always clear.

The point of the article was...

Set dkrConnection = Server.CreateObject("ADODB.Connection")

Set dkrResult = Server.CreateObject("ADODB.Recordset")

dkrConnString = Application("driver=SQL Server;server=db1\steve;database=northwind")

dkrConnection.Open dkrConnString

dkrQuery = "select * from orders"

' Execute the query

dkrResult.Open dkrQuery, dkrConnection

if not dkrResult.EOF then

response.write(dkrResult.fields("customerid").value)

dkrResult.movenext

end if

set dkrResult =...