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 =...

Check the connections in the package. I think these are login errors. When you run in design mode, the package is running form your workstation. When you run it from...

Agree with Anatares. I think LogExplorer will attach to your log and work, but without regular backups, you may be stuck.

Steve Jones

sjones@sqlservercentral.com

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

Someone likely messed with the system tables.

I'd detach the databases and then reattach them again. Should repopulate the system tables.

Steve Jones

sjones@sqlservercentral.com

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

What do you mean see? in SP_WHO? Enterprise Manager?

Steve Jones

sjones@sqlservercentral.com

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

In working with MS Support and Tuning groups, they do not really look at the % costs. The reason is that these are so fluid and can change. The bigger...

Is the cache hit ratio taking a hit? Have you checked to see if there are lots of physical reads? You can run the queries in QA at the same...

If you are tight on disk space, what about a remove disk backup? Preferred to tapes.

Also, look at SQL Litespeed (www.sqllitespeed.com). It compresses the backups and runs faster than...

What do you mean? Limited set of data?

It really depends. There are some generators for data, but they tend to be a little pricey and they work for certain scenarios...