I see the sports spam has returned. There's a "few" posts about a fight coming up. I presume the poster thinks it'll get some hits, but I honestly...

Please post back if you figure this out. I'm interested in knowing if it's a problem in 2012 or not.

Grant Fritchey (5/29/2015)

---

I can't honestly say the number of times I've seen this go badly. Views calling other views that are joined to views which contain other nested views... It...

Sean Lange (5/29/2015)

---

Ed Wagner (5/29/2015)

---

Sean Lange (5/29/2015)

---

No offense but if your view is like the pseudocode below your issue is only beginning....

Missile Command

Natural

Restore

Letron Brantley (5/29/2015)

---

Hmmm... No I'm not including the schema when passing the table name. Could that be the issue?

How did you determine whether the permissions persisted after the rename?...

Management (Couldn't resist :-D)

Sean Lange (5/29/2015)

---

No offense but if your view is like the pseudocode below your issue is only beginning. The performance of this...

Millipede

Did you try to use sp_rename (without using the procedure) to rename the table as someone with proper privs? If so, did it keep the permissions through the rename?

Pac Man

Letron Brantley (5/29/2015)

---

Thanks for working with me on this guys. Below is the code for the usp_RenameTable stored proc.

CREATE PROCEDURE [dbo].[usp_RenameTable]

-- Add the parameters for the stored procedure here

@t1...

No problem, but thanks for the confirmation. I thought it did...