It's better to remove the BUILTIN\Administrators and then add back in groups which need permission than to start issuying denys. About the only you can do is specifically deny a...

I like Sara's idea of using DTS. However, if you're going to stick with the SQL Server Agent job mechanism, the best thing to do is chain the jobs. In...

Can you give us the error message and an example of how you're using it (please make sure to use dummy data)?

Getting to what I think might be a biggr issue... so all managers have the ability to alter all projects? How are you segregating permissions at this level?

Also when you...

Key to finding out where any of the SQL Server Agent settings are is to take a look at sp_set_sqlagent_properties in the msdb database. It uses xp_instance_regwrite to store most...

Better yet, remove the BUILTIN\Administrators group from having sysadmin rights. Be sure your DBAs have rights through another group. Issues you need to be aware of here:

SQL Server Security:...

Instead of using stored procedures or the GUI to do this, can I not just shut down SQL Server and copy the files to the new server?

You can copy the...

Is your SQL Server agent service account a domain account (or even a local account, just long as it isn't SYSTEM)? Have you logged on as that account and created...

If you can guarantee they're coming in on a certain IP or set of IPs. A lot of times that can't be done with consultants who are using standard ISPs....

Um, no, he's not correct if he's just talking about what it takes within AD. If they have monitoring agents, etc., then he may be completely correct. AD in and...

Triggers on system tables aren't supported and aren't guaranteed to fire. Tracing through Profiler or the SQL Server trace sprocs would allow you to keep track of changes, though you'll...

If it's on the default port of 1433 (which it shouldn't be if it's on the Internet), you don't have to have udp/1434 exposed. In any case you don't want...

Assuming you've not assigned SQL Server to use specific processors, SQL Server will use multiple processors as the need arises. If the cost to manage the process using multiple processors...

It's not started, but is it installed and part of the cluster group?

To use an application role, first login with a normal login. This can be SQL Server or Windows based, but it must have access to the SQL Server. The application...