Hey SQLHammer,

Thank you for the feedback.

1. Are you making use of CMS in SQL Server? or merely querying for registered servers?

I am using a Central Management Server for my...

Hey there,

You can change the connection to your CMS server in the top function:

function GetServers

{

$ServerInstance = "vypdbmon01"

$Database = "msdb"

This is where you...

dbo on that database should be fine.

With regards to activity monitor, this should be included, but if they want to use sql profiler, you will need to grant alter trace...

What exactly does the user need to do?

You should focus on giving the least amount of access.

Get the details of what they are trying to achieve and then we can...

Hey,

Read up about backup Devices.

From what I understand, you create a device and specify the disks the device belongs to, then you simply do a backup to that device...

Hi,

Are you trying to match column names, datatypes, lengths?

I guess you could write a query that checks the sysobjects table for tables, and then joins onto syscolumns using the...

Hi,

I am not entired sure you can consolidate data files, as I have neverr been required to do so.

My best guess, hoping the database isnt too big, would be...