The performance is based on what is happening with the base tables. Whether the views are wide or narrow isn't as important as what operations the query plan will perform...

If you stop the report services service

display name:

SQL Server Reporting Services (MSSQLSERVER)

Do the entries stop?

It sounds like the server principal does not exist in master.sys.server_principals

Try creating it:

CREATE LOGIN [SQLLogin] with Password = 'cleartext', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

After that you may need to synch the sids...

Also, and you may know this, but there is a difference between total space and used space. The comments others have posted are suggesting that some of the free space...

Yes, at the top you would just replace

Set @Username = 'Domain\Username'

with the actual account names you wish to place in the db_owner role of the database. However, I am not...

Okay, well I am happy to help if I can, but I just wanted to make sure I understood your request thoroughly before I attempted to help. Anyway, just post...

It places an active directory account in the db_owner role for each of the databases on a server except those that are in the in list ('msdb','master','etc').

For just one user or group you could run something like the following:

[Code="sql"]

Declare @Username sysname

Set @Username = 'Domain\Username'

Declare @DB sysname

,@SQL Varchar(8000)

Declare DB Cursor Static

for Select name

From master..sysdatabases

Where name not in...

Is there an active directory group that they are all part of, or will you be pulling the users from an active directory call?

Are you asking for help writing this becasue you want to encorporate it in a stored procedure?

I would suggest that it probably was not a "messed up system table", but that rather it was an unintended permissions collission. This can happen easily where it is not...

After considering what you wrote and what I was seeing I started having a sneaking susupicion that it might have something to do with the fact that it's been so...

If I remote into the server and open a connection from SSMS there I get Kerberos. However, all the other connections from SSMS that are Kerberos are connecting from their...

The...

It just occurred to me that you might not know how to add a directory to the path variable. Let me know if you don't and I will tell you.