Just a small point from an AD administrator... The local security policy can easily be overwritten with group policy. Therefore, if you're looking to keep your admins out by saying...

This works for EM, but the problem is that the public role has SELECT rights against sysdatabases, meaning they aren't hidden. While SELECT permissions aren't needed for most users, removing...

Or you can use RunAs at the operating system level. Hold down the shift key as you right click on Enterprise Manager or Query Analyzer. In the pop-up menu you'll...

You can't, at least not in SQL Server 2000.

1. You can, but as Steve indicated, you shouldn't. The local System account is actually more powerful than a normal administrator. If a service is running under that, it can...

From Books Online about error code 103:

If you enclose a character string that is more than 128 characters in double quotation marks, the application may receive this error. When the...

Yes. You can create an ODBC connection to MySQL using MyODBC. SQL Server you can use the OLEDB provider. In order to have a linked server connection from SQL Server...

That depends if you're going per device or per user. You can find the information you're looking for here:

Microsoft SQL Server: How to Buy

But right now you are talking about a SQL Server process having the capability of modifying your Active Directory structure... typically there are fewer folks with the ability to update...

David, were you ever able to piece together why the users had access they shouldn't through said view?

If you generate a local one, make sure the computer SQL Server is running on trusts the CA that generated it (which is should if it's local). As far as...

You have to write batch files or scripts? I'm hoping you mean the latter. Executing stored procedures and editing files is easy using scripts. You have access to CreateObject() which...

I'll take a look. Most of my work in this area has been using ADSI (VBScript or Perl). Is there a reason you have to do this through SQL Server?...

Yes, but they may not always be able to open them, at the least most current one, as SQL Server (or Agent) may have them open.

This would probably be better accomplished using a script and ADSI which queries the database and then executes the appropriate ADSI command. What information are you trying to push from...