For what it's worth, here is what I use. It shows all the backups, the server, database, user name, start date, type (database, tranlog, etc.), size, physical file name,...

You could capture the HOST_NAME(). This gives the computer name that the user was on.

I use this. Works great.

Don't know if this gives you enough information to go...

Here is what I use. It isn't pretty, but it gets the job done. Just set the context to the desired database and run this.

You can change the...

OOOOPS!

Sorry, the @ProfileName in the last query comment line is a variable left over in my code.

I would suggest just doing some simple testing using T-SQL.

Try sending an email manually and see what it does. If using Exchange, ask the Exchange admin to check all...

You can set permissions on a view. This can be very useful for several reasons:

1) Lets you hide the complexity of joins, lookups, etc. in your code

2) Lets you...

The database only holds the data, it does not do the encryption/decryption. Specialized functions accomplish that in column-level encryption (also in TDE, just at a different spot, and invisible...

One of our vendors implemented Reporting Services on their solution by using local groups (created on the box with SQl Server and Reporting Services) to define the users and their...

Yes, that is what I do, but for 30 servers, many databases per server, how are you going to build the move statements without knowing where to put the new...

BTW - when I do scripts, I use the REPLACE function with the old drive:\directory structure\ and the new drive:\directory structure\ and just replace them for each file. These...

One thing to note is any difference in the drives and directories that the restored live data files go to. I have several SQL Servers myself, so any time...

Don't know if this will help, but see this link for a script I wrote for creating an instance audit documentation script. If you set the @outputtype variable = 2...

Also, don't forget to use the sp_help_revlogin stored procedure (can find it on the web) to move the affected logins if they are not already moved. This SP moves...

If it helps, here is a script that will create a script to set all values for documentation for the columns for all tables in a database. Just set...

Andy:

See if this is what you mean. I use this for the same thing. Change the select statement inside the cursor to the column and table you want...