Points have been awarded back and the answers corrected. The wrong one was selected.

My apologies.

Yep, we used to do this monthly when I worked in a large shop (JD Edwards). We...

Sean Lange (1/19/2012)

---

I agree with one small caveat. If we...

Locking this thread. This has gotten away from the original question

LOL, I know this is (was) the suggestions forum, but I can't change either of those things.

Well, I could put a .22 through Lowell's light, but it would be a...

It sounds as though you have some permissions issue with the older publications.

If you log in as "sa", can you do a sp_droppublication on the item?

http://technet.microsoft.com/en-us/library/ms188363.aspx

It's a complex subject and topic. basically the optimizer calculates a series of costs, using different execution plans. It does not consider them all, but considers a number, picks the...

Please start a new thread for new questions.

Is that official? Mar 23?

Yes, I meant stick with 2008 R2. Or stick with 2005 if you don't have a compelling reason for the upgrade.

You could use a local view or synonym, but that would be for objects, not all globally.

If these are stored procedures, why not do it the reverse way, have them...

Good question. I don't have a spare drive now I want to test FORMAT on. I think it applies only to TAPES, but I'm not positive.

Nothing in there: http://msdn.microsoft.com/en-us/library/ms186865.aspx

Disk, you...

jflynn-735049 (1/19/2012)

---

We have a large project that is using many stored procedures. The project uses multiple database so a stored procedure may call tables in another database. The issue...

Calculate the licensing costs. There isn't a set 2012 price yet, but give it a go based on the 2008R2 + 10-20% and see if the cores matter to you.

If...

jay holovacs (1/19/2012)

---

Well their control over independent software is part of the problem. But they do put a strangle hold on content providers such as magazine publishers. They contracturally mandate...

Jason has some good points. Be sure you look at licensing. The change from sockets to cores may or may not affect you. If you have high density processors (>...