I was able to get what I need by using a combination of making the role the owner of all the schemas they need access to and by specifying deny...

Sue - I must not be setting it up correctly when trying to follow your advice. What permissions do I grant at the database level that won't apply to...

I'm away from a computer and will be for the next few days so I'll give it an attempt to type it out here. The headers will read:

Date, Code,...

whenriksen -

The example I provided is code for a report we are taking over from another group. The first goal is to convert it to ANSI-92 style joins so...

Here's some sample data. There is some more filtering I need to do on my end so that is why it returns so many results. My intent was...

I wanted to give this a bump in case someone missed it last week and can provide information on what I'm trying to do.

They are set to read-only now but it's not specified to not include them in the backups. I was also hoping to move them out of sight without having...

Thanks, MadAdmin and ZZ!

Eric - Thanks for the SSIS tip. That will make it much easier to capture the handful of records without a match as opposed to joining across tables manually.

We haven't created a client table of correct, distinct values yet. I'm thinking initially we will have to go through those 300k records to find any variations and then...

This is a new process so we haven't really taken a close look at the data at this point. I can't put a number on it but would venture...

Thanks for all the help! It sounds like I might have to maintain a table with the correct name and create a list of all of the incorrect names...

Thanks! That seems like exactly what I have going on. I'll play around with a few things and probably take a look at the recompile query option since...

The suggestion was made to help improve security since, you know, no one has ever been able to access an environment not using port 1433 :laugh:

The logs look pretty similar when the service fails to start with the exception of the port

2016-06-22 09:12:27.12 Server Microsoft SQL Server 2014 (SP1-CU6) (KB3144524)...