@steve-2

The reference link is http://msdn.microsoft.com/en-us/library/ff642522.aspx

and http://technet.microsoft.com/library/cc645993(SQL.110).aspx

PaceIT,

Unless they removed it from R2, you should be able to use Service Broker to audit someone account modifications.

http://support.microsoft.com/kb/971524/

We do have a development server, however its shared with serveral other groups. I trying to see what is the best way to grant them the necessary permissions to do...

Can you have them work on their own schema instead of the default dbo. That way they can drop there own tables and no longer need ddl rights. Of course...

Dana,

So what reason did the Sysadmin give in saying that adding more RAM SQL cluster? Do you have any performance data on your environment. Maybe if you have a 64bit...

Since your system is a 32bit environment and you already have 8 GB per node, your already hitting the max memory limitations of the OS. Is there any reason why...

In regards to the securityadmin role, doesn't this bring the issue of granting that user the ability the alter/remove any login from the system. I'm facing the similiar issue where...

AVB,

I am not familiar with a Buy-out type license. It looks like something new with microsoft. Most of the site in the google link references a Buy-out type license

AVB

You can always downgrade to the previous versions. However from my knowledge its still going to be the same price whether you chose to downgrade to SQL 2008 or SQL...

Just wondering what requirements do you need for an audit? Capturing a serverside trace is fine, however, if the data table needs to be audited you may need to look...

What client are you using on the workstation?

I would like easier manageability of job access and creation. Something like a table matrix where you can set who can exec, run, modify instead of going through the process...

Krasavita

The expire option will not remove the backup file.

You need to use the Maintenance Cleanup Task.

Please refer to http://www.sqlservercentral.com/Forums/Topic361562-149-1.aspx

Darren,

Thanks for your reply, I expecting this type of answer but hoping for an alternative. For what ever reason, I can't understand why developers not all are hesistant in...