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...