You shouldn't need to drop any publications. I restore my Production (publisher) database on top of my test database fairly regularly. The difference is that I use my regular Prod backup,...

Will there be updating at the different locations, or is the data updated just at one location, then pushed to the other location for inquiry only ?     Log Shipping is...

How about Log Shipping ?

I noticed quite a lot of this today as well, and wonder if anyone else has fresh thoughts on this.

We're on SP4, by the way

EDIT:  I just found this:

http://support.microsoft.com/default.aspx?scid=kb;en-us;906344

I do something similar, to reduce maintenance.

I create a stored proc on the server that does all the calculations, then just "exec StredProc" in the pivot table. That way, many users...

"..... When they do the table changes current dbo owner to their account. ..... "

Don't ya hate that !!??

You can run:

exec sp_addalias 'Login_Name','dbo'

It's a SQL 7.0 holdover, but it works

" ......... Is there some way of monitoring what happens to the Log during a complete process cycle? If so then I could monitor a small and a large DB...

Simple question, but not a simple answer !!

Here's a completely different way.

1) In Enterprise Manager, create a NEW copy of the OLD table, with unique contraints, and "Ignore Duplicate Key" checked.

2) Copy from OLD table with duplicates,...

The account I'm testing with WAS a sysadmin, but now it's just a regular user as far as I can see. However, I tried it with another test user that...

I want to do something similar. I have a test user that has read access to the database. I put deny permission on the credit card column, but I was...

Steve, I ran your code, and other than a few extra parentheses, yours gives the correct results too.

How about this field in syssubscriptions table:

" ......... i could delete the transaction logs everynight after the backup since I have a new, full backup of the databases, correct? ......."

Correct ... unless you think you might have...

Idera's Diagnostic Manager is another one ... Not terribly expensive. One of their performance features is called "worst performing", and will give you a list of all the SQL SPs,...