I'm sorry, Jeff, but I am lost by this comment.

If the data is no longer needed, then create the new column with a new name, drop the old column, then rename the new column to name of the old...

• This reply was modified 5 years ago by Lynn Pettis.

I don't know, sounds a little fishy, but I could be wrong.  Unfortunately, without seeing the actual code it may be difficult to help you figure out what is going...

As a (mostly) lurker on this esteemed forum for around five years, I've only recently come across this thread.

I've not managed to consume all 4000+ pages to...

Have tried separating each create index statement with GO (batch separator)?

Oh, and I also agree with everything said by Jeff, Brandie, Greg, and Jason. Your DBA should be 100% involved in assigning appropriate permissions.  Using AD groups is also a...

And what I was trying to get at was instead of having to add permissions to each of the newly written views, the views could be created in the appropriate...

• This reply was modified 5 years ago by Lynn Pettis.

Taking a guess here but it looks like you are assigning permissions for select access on each view created by your analysts for the users using the views.

Are these view...

Just confirming that I am in as well.

Thank you for posting your code.  Now, what errors are you getting when you run this code?  I can't actually run the code as I don't have servers to run...

So, post the code you are working with.

So, no response after actual code is provided?

I have a little bit of good news, sort of. I have managed to find work at Parsons that has extended my stay to the end of September.  Better than...

No promises but this should at least get you started.

-- The following table variables or for writing the code only, they should be replaced
-- with your tables...

IIRC, there is also a difference in the dates in Excel and SQL Server.  Only problem is that I don't quite remember what the problem, had I haven't...