Google helps.

Here is one:

http://forums.microsoft.com/msdn/showpost.aspx?postid=1972452&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1

HTH.

I used a temp table to select the latest one. (Not a good one, but works.):hehe:

You can google the instruction.

Here is one:

http://www.devarticles.com/c/a/SQL-Server/Replication-SQL-Server-2000-Part-2/

This problem occurs because the Snapshot Agent always sets the QUOTED_IDENTIFIER option to ON, regardless of the actual setting. Therefore, if the stored procedures or views use double quotation marks,...

I don't think you need to restore the Log backup.

Go for Transactional Replication.

Yes, you can.

Is there an option for "backup" check in the maint. plan?

The slowness is because SQL engine works hard to get 100G space from your HD (if your HD already has other stuff, it may take longer).

Usually, I create a relatively...

1. Replication: SnapShot or Transactional

2. Log Shipping.

3. Mirroring + Database SnapShot (SQL 2005)

Based on David's script:

SELECT j.[name],

MAX(CAST(

STUFF(STUFF(CAST(jh.run_date as varchar),7,0,'-'),5,0,'-') + ' ' +

STUFF(STUFF(REPLACE(STR(jh.run_time,6,0),' ','0'),5,0,':'),3,0,':') as datetime)) AS [LastRun],

CASE jh.run_status WHEN 0 THEN 'Failed'

WHEN 1 THEN 'Success'

...

Go to Books Online, check "CONVERT". There are lots of time format.

Check this article:

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

---- I got this from Gail Shaw.:)

I would rather create the 2nd Raid 1 for TempDB on Controller 1 since it is faster.

How about this?

UPDATE TIH--#TEMPINVENTORYHISTORY

SET

ORIGCONTAINERNO = TP.ORIGCONTAINERNO,

ORIGPACKAGENO = CAST(TP.ORIGPACKAGENO AS VARCHAR)

FROM #TEMPINVENTORYHISTORY TIH

INNER JOIN TRANSREPACKAGING TP ON TIH.TRANSID = TP.TRANSID

WHERE

...