SQL Server 2014 has a new cardinality estimator that could lead to totally different execution plans. What compatibility level is the database?

If you have good enough performance from the 2008R2...

Resource Governor would be a perfect fit for this.

In Standard Edition there's not much you can do. You could refuse connections from an application server in a logon trigger,...

Looks like a GUI issue. What were you doing when you received the error?

Jeff Moden (10/21/2014)

---

Use the "Copy only" feature to do a native backup the database so you don't break the Point-in-Time natue of DPM, whatever that happens to stand for today....

Double post.

Replies here please: http://www.sqlservercentral.com/Forums/FindPost1627525.aspx

LutzM (10/21/2014)

---

spaghettidba (10/21/2014)

---

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a HUGE fan of real Italian, so now I'm hungry....

This is one of my favourite Spaetzle recipes:

https://translate.google.com/translate?hl=it&sl=it&tl=en&u=http%3A%2F%2Fliberamenteincucina77.blogspot.it%2F2012%2F09%2Fspaetzle-agli-spinaci-con-pancetta.html

If the production server is logging failed logins, you should find the reason in the errorlog

It's a connectivity issue. Talk to your network admins.

It's something similar to a "conditional" cross join:

DECLARE @Products TABLE (ProdID int, ProdGrp char(1))

INSERT INTO @Products VALUES (11,'*')

INSERT INTO @Products VALUES (12,'*')

DECLARE @ProductGroups TABLE (ProdGrp char(1), ProdGrpDesc varchar(50))

INSERT INTO @ProductGroups...

What happens if you try to connect directly from SSMS?

Ed Wagner (10/21/2014)

---

Parma, Venice...these cities are making me think of authentic Italian food. I cook and am a HUGE fan of real Italian, so now I'm hungry. I...

rodjkidd (10/21/2014)

---

I want to go to at least one SQL Sat in Italy. November is probably a no go due to going to PASS, and December is so full at...

rodjkidd (10/21/2014)

---

Welcome back Gianluca! So not that far from...

I'm in Conegliano, home of the Prosecco sparkling wine.

It's 50 km from Venice.