Thanks Gail

When I look at the Login Properties--Securables of a login I see the permission of 'Connect SQL' and grant is checked and the Grantor is 'sa'--even though I have the...

So if you need an sa type account do you just rename it or do you use all windows authentication?

Doesn't the UNION ALL include duplicates. Could that be why you are getting more rows than you thought. UNION removes the duplicates.

Good luck

Kathy

Thanks for the input--I'll be glad when we are off 6.5 and 7

The users that are actually using the table. So I guess I mean the user that are actively using the table. I did use sp_who2 and found the user, host...

I tried to rename the instance as #2 but didn't work. I would feel better installing an instance vs a rename--so I've decided to getting an ISO in the cloud...

I was able to get into the database engine by having the Network admin spin up the sql server by using a local username and password.

Now I have to...

When the network admin provisions the sql server it defaults to Windows Authentication and the sa account is disabled. I sign into the sql server using remote desktop with domain\username....