Viewing 15 posts - 2,821 through 2,835 (of 6,105 total)
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...
July 21, 2005 at 2:40 pm
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...
July 21, 2005 at 1:08 pm
Can you give us the error message and an example of how you're using it (please make sure to use dummy data)?
July 21, 2005 at 12:49 pm
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...
July 21, 2005 at 12:48 pm
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...
July 21, 2005 at 12:42 pm
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:
July 21, 2005 at 12:17 pm
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...
July 21, 2005 at 12:14 pm
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...
July 21, 2005 at 11:59 am
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....
July 21, 2005 at 11:57 am
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...
July 21, 2005 at 10:15 am
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...
July 21, 2005 at 10:12 am
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...
July 21, 2005 at 10:10 am
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...
July 21, 2005 at 9:10 am
It's not started, but is it installed and part of the cluster group?
July 20, 2005 at 10:52 am
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...
July 20, 2005 at 10:50 am
Viewing 15 posts - 2,821 through 2,835 (of 6,105 total)