As Ian indicates, a view defintion is stored in the user database. The master database stores information on the databases themselves and the logins to SQL Server (whether SQL Server...

The solution Greg gives works to identify the objects. It queries every database to see what objects the login actually owns.

The sp_change_users_login is used to reassociate disconnected user accounts with...

Per processor licensing means an unlimited # of users. Per seat is where you have to count heads.

Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."

This would indicate you're connecting with an account that is either untrusted (from a...

LiteSpeed has a command line utility which can expand a Lightspeed backup into a "normal" SQL Server backup. If you use it, is it able to read the backup file...

You could do the local account, thing, yes. However, a more feasible solution might be to install an SSL certificate and force encryption on the connection. Is that an option?...

Looks like everything is okay on the permissions side. The job steps that are failing... are they making calls to the same SQL Server where the package is running (as...

Who is the job owner? If not sa, is that job owner in the sysadmin fixed server role?

By default, yes, but the method of "encryption" is very, very weak. Check the following:

SQL Server Security: Login Weaknesses

If you mean how do you return all rows where address2 is null, you can do something like:

SELECT address1
FROM yourTable
WHERE address2 IS NULL

If you mean how can you get address1,...

When you log in as TestUser and go to the database, if you execute the following query, what user is returned?

SELECT USER_NAME()

Not if the login to SQL Server is done using a SQL Server login. That's the issue at hand. When a SQL Server login is used, no Windows account information...

Is TestUser a member of any other group? If you look at the OS level, is TUsers a member of the local administrators group?

You know, when all is said and done, you should write this up as an article and submit it to Steve.... names omitted or changed to protect the innocent, of...

Follow the principle of least privilege. Give the proxy account only what rights are absolutely necessary. If it needs access to a particular directory, grant it access to that directory,...