Not a problem, glad all is working for you.

I found PBM to be a bit tricky first time I started using it, but you soon learn the ways of doing...

Check the SIDs of both users on each server, I suspect they are different.

If they are you need to add a mapping on the linked server configuration to mapp LL_LOGIN...

The training partner where I did all the training with was QA, they are pretty good in all honesty and got plenty of sites in London.

Well it all depends on your RTO and RTP as to which to choose and if you want hot, warm or cold standbys.

If you know this information then you can...

@Update or @Insert should be = True and @Name should be LIKE 'TRI%' or 'TRU%' depending on the trigger. They will need to be evaluated in the same condition

@Update...

2 CPUs, each with 4 cores, would mean you need to purchase 8 core licenses for SQL.

I have attached the QRG which contains some pricing, but to get latest prices,...

Not used litespeed in a while, but are you using the dynamic compression feature where it determins the best compression level or have you just set it to the max...

From reading, but this might be totally wrong.

As a checkpoint rights information relating to the transaction log as well as dirty pages to disk, if the transaction is not commited...

Would want to use the trigger facet, with name and either insert or update depending on the trigger as the conditions

If you run the copy manually then run the pkgmgr on its own does it still error?

Please explain a bit further.

Are you talking about tools to manage and query SQL? If so give them SSMS and limit what they can do to the database via...

As with anything licensing, speak to Microsoft or your reseller direct.

I have attached the QRG for SQL 2012 licensing.

Typically mirrored servers dont require licensing as long as no user activity...

select top 1 cmp_id from CSR_COMPLEMENT

where DOS_ID = (select DOS_ID from CSR_DOSSIER where DOS_NODE = @DOS_NODE) order by cmp_numordre desc

Might be missing something but if you only want 1 cmp_id...

Festo SmartBird

dwain.c (8/7/2012)

---

Lynn Pettis (8/7/2012)

---

I don't know, but I'm really getting tired of questions wanting answers but not getting enough information to for me to even start to give a decent...