Thank you. This information really helped out. I appreciate all the feedback.

Thanks for clarifying this!

I am going to give it a try.

If the record set was small, I could write a union or insert for each record like you have provided.

However, my real table has thousands of rows with multiple combinations.

I...

I did post my result wrong, thanks for noticing and attempting to help me.

I need to explain more clearly. The table I am selecting from contains thousands of records....

Thanks for all the feedback. I will be presenting my case to the Server Admin for RDP access tomorrow morning.

I have been given SysAdmin rights for the all machines with SQL Server installed. I have been able to figure out the SQLExpress instances. I was also able...

Let me ask this: If your given a list of computer names that have SQL Server installed and asked to take on managing them, wouldn't you at least need...

It looks like I will need to ask the Server Admin to hop on the machine and check the Services to let me know what instances are on each machine....

Well, I guess I will need to give this some consideration. They have been asking for it for a long time now. I assumed that SSMS gave them...

I am still not seeing what functions on the server they would need. If they can work in SSMS from their machine, why do they need to login to...

We do not use SSIS or Reporting Services. We only use MS SQL database engine.

We really want to protect the server and limit the amount of unnecessary access. Although I am not an expert at DBA work, I have used SSMS in the...

They do not do installs.

Not sure what DAC enablement is for? If the server is down, we bring it back up for them.

We just feel the DBAs need to...

This problem was first identified because we have a Web report that works when logging in as one user, but not working when logging in as another even from the...

This is occuring on the same computer.