Yep. Saw that one. One comment I thought was hillarious, on a news...

Michael Fried (12/13/2012)

---

OK, thanks for the response. I guess there are two potential views on this setting:

1) Functionality that has been deprecated (or changed) in a newer version will...

I guess it depends a lot on which definition of "the cloud" you're dealing with.

Is a virtual server on the Amazon EC2 infrastructure "the cloud"? How about a hosted...

Sean Lange (12/13/2012)

---

This works for me.

...

However the reason I suggested using a temp table is because you want to capture all the rows not just one. If you don't need...

Stefan Krzywicki (12/13/2012)

---

GSquared (12/13/2012)

---

Steve Jones - SSC Editor (12/13/2012)

---

There might be a few things in the points that we haven't accounted for. To be honest, we didn't dig into it...

Steve Jones - SSC Editor (12/13/2012)

---

There might be a few things in the points that we haven't accounted for. To be honest, we didn't dig into it much. As the...

I just tested this, and it worked:

USE ProofOfConcept;

GO

CREATE FUNCTION dbo.MyFunction (@Input INT)

RETURNS TABLE

AS

RETURN (SELECT @Input AS C1, @Input+1 AS C2);

GO

DECLARE @Var1 INT, @Var2 INT;

SELECT @Var1 = C1, @Var2 = C2

FROM...

A suggestion: Ask about "lookup tables". Restore-no-data, does it include things like a table of US states and Canadian provinces? Are there tables that will need to have...

You're welcome.

Don't worry about the time. This kind of thing happens to all of us.

I've seen situations where hours were spent trying to debug something, but it just kept...

Unless you need to restore to an earlier state (point-in-time restore), the last diff is the only one you need.

Opening a new connection that way is definitely a valid alternative. Not at all "less professional". It won't change the connection of an existing tab/window, but it will...

Yes, you can do that, but you need to plan for what to do if the function returns more than 1 row, or make absolutely sure it can never do...

I don't know. Only way to find out is to ask them.

Of course, it'll probably be something where you end up going, "Ack! How'd I miss that?" and...

CELKO (12/12/2012)

---

...

DDL trigger on the databases, or DML trigger on some tables?

Either way, you run a cursor that executes a script for you. It's just how to write it that...