In this case I don't think there are many clear advantages of one over the other method. But Here are some points for you to consider.

1. Method1 is using an...

Here are some of the reasons I have come across:

- App Vendor specific collation / sort order / case sensitivity

- Hard Coded Server Name

- Customer Isolation (by request)

- Service Pack...

Dave, Steve, DarylAndDaryl

Do you want to give this a shot? ....(IT WORKS FOR ME)

select *

from

openrowset ('SQLOLEDB','Server=(local);Trusted_Connection=yes','SET FMTONLY OFF EXEC msdb.dbo.sp_help_job') q

--where q.name...

FROM BOL:

-------------------------------------------------------

Disabling FOREIGN KEY Constraints

Existing FOREIGN KEY constraints can be disabled for:

• INSERT and UPDATE statements

 .............

• Replication processing.

...........

------------------------------------------------------

Therefore they can't be disabled for TRUNCATE TABLE operations, you will have...

Lori,

On index analysis column-order matters! and not only that the first column should be the most selective

The indexes you show are deinetly being...

Linda how big is the budget

If you can go to SAN disk then SAN replication is your best bet!

If that is too expensive...

JN,

I did that as an example, for the real deal you to get the data from tmp_listing not from Propmaster like it was on the example if you use:

FROM       tmp_Listings  B

Where...

You are welcome

JN,

The NOT EXISTS is meant to be used as:

FROM       PropMaster A

Where NOT EXISTS ( Select * FROM tmp_Listings B Where B.LSID = A.ListingID )

HTH

Dave:

What is the problem with using sp_help_job and use the current_execution_status field ?

Linda,

LogShipping is meant for STANDBY servers not for reporting because the user connections are going to be  kill every time a log is restored! You coud though have TWO log...

You may want to change the "NOT IN" for a "NOT EXISTS". "NOT IN" tends to be dagerous

What I was trying to say is:

If your MODEL Database has the 'default to local cursor' ON/TRUE then your cursors are going to be local (Mine are like that). For Databases that...

TRY THIS

HTH

Change:

FROM       PropMaster A,  tmp_Listings B

WHERE A.ListingID <> B.LSID

to:

FROM    tmp_Listings B   left join PropMaster A  on A.ListingID = B.LSID

WHERE A.ListingID IS NULL