Chuck Hottle (9/23/2011)

---

When we moved to a new data center and upgraded from SS 2000 to 2005, I had to develop a custom log-shipping solution because the built-in could not...

On the other hand.

Any reason you're not doing some sort of replication to a 2nd server so they can't mess with production?

It's the default behavior. If they can't access it they shoudln't be able to see it.

If they do you probably messed up something.

Run the code taht fails but from the other db.

It fails because it's in compatibily mode 80.

Alternatively you could just swap DB_ID('ABPMaster') with the db id and the code will...

I don't use it but it looks so cool!

I just need to buy 3 more computers now!

Ninja's_RGR'us (9/23/2011)

---

Ratheesh.K.Nair (9/23/2011)

---

But if thats the case tehn it should not run fast next day morning right??

It is like everyday morning the query executes in seconds and in afternoon its...

The extra join multiplies the rows so you add too much.

You can simply do an outer apply or use a derived table to preagregate that data, then left join to...

What's the value you have in that variable?

@Commoditylike

Your post is cut off.

So where are you having issues? You seem to know what you are doing!

Joy Smith San (9/23/2011)

---

Thank you all for the quick responses.

Had I taken atleast a full backup, I could have taken the tail log backup and do a PIT recovery, right...

pwalter83 (9/23/2011)

---

I tried this one before including some other permutations and combinations but this hard shell doesnt crack...

You could if you had a full before the incident. Because then you could take a log backup and do the PIT restore.

Right now you're hosed without 3rd party...

and (Commodity like '%' + @Commoditylike + '%') or (@Commoditylike Is NULL)

Use this to split the string into rows, then you can just take everything right of the next splitting character

http://www.sqlservercentral.com/articles/Tally+Table/72993/