Thanks for posting back!

From the article...

chrisph (7/27/2011)

---

I am pulling a database from a 3rd party contained in a .7z nightly, running a command to extract it and now need a SQL script that will restore...

homebrew01 (7/27/2011)

---

I don't quite understand. What is .7z ?

Is the database backup file changing nightly, but the databse will ulimately have the same name each day ? Could...

PERSISTED was a nice idea but it can't be done due to the data access the UDF is trying to do.

Sure, HTH 🙂

Here's a quick demo SQLTestUser to show the technique:

IF OBJECT_ID(N'tempdb..#temp_table') > 0

DROP TABLE #temp_table ;

CREATE TABLE #temp_table

(

type_smallint SMALLINT,

type_bit BIT

) ;

INSERT INTO #temp_table

...

Ahhh...got it. Sorry, I was looking at your latest "is not quite a performance-booster" comment as a claim of loss of performance or something.

<still_learning>I know collations as a set of...

Anytime, HTH 🙂

Jeff, I figure you were trying to dilute things a bit here, which I do too depending on the forum as it were, but I want to make sure we...

Regarding item 3: granting permissions at the schema level simplifies things significantly. If your requirements allow it I would do that rather than going to the object level.

Regarding item 4:...

Dan explains a one-size-fits-all approach that I think is elegant and is the one I use and recommend unless "granular or complex" security requirements exist:

Keep Schema and Ownership Simple

Please post the resolution so others can see in case they had the same error or similar issue.

SELECT roles.name AS role_name,

...

Upgrade Advisor is a good place to start. Are you doing an in-place upgrade? Will you have new servers? Make sure you have good backups whatever you do. Here is...

Ninja's_RGR'us (7/27/2011)

---

opc.three (7/27/2011)

---

Ninja's_RGR'us (7/27/2011)

---

Ok, keep us posted. I'd love to hear a happy ending on this one, even if there's little hope...