If X lock is in grant status then why does the select...

No I did not...

I am not sure if I follow how grant to execute works

grant execute to public

If i run that I do not get the desired result of the sprocs and user...

Sorry, had to be away from this for a bit. Thanks for the responses. Let me explain why I think "Grant to public" is needed. We don't own...

When you say "could be stored in the Tempdb" that is because a user defined table type is technically memory driven verse disk driven like #temp table?

Good point. I am laying these down all at once. If I run that command will it take care of the TVP's and Sprocs?

Thank you very much. I must have been googling it incorrectly. Found a million pages of how to give permission/create a TVP but could not figure something that...

Your awesome thank you. I thought I broke my scripting solution.

opc. - So there is no way to really understand why it is reorganizing my tables from the original. Is it a black box? The join with the...

No - I changed them to inner joins. The developer had everything as left joins. I did not want that since they are required fields. It then reformatted the...

I think figured it out. the original query mostly had all Left Joins. When I change the linked tables as INNER the whole SQL portion of the view...

The applications language is C#. This is not something we are rolling out internally. This is going to clients.

I have known to always qualify in Joins but never ran into this in Where clauses. Lesson learned. I don't like it but I understand it now.

Thanks I want to say it was something I heard from SQL Saturday from Kevin Kline. Maybe I misunderstood. If you have a create table # or @...

Hey just wanted to thank you guys. I actually incorporated all your suggestions. Here is what the code looks like now:

UpgradeBuild.cmd "C:\SourceDirectory" "Server\Instance" "C:Upgrade files in TFS"

That called this...