DBAs don't need local administrative access to the servers if the responsibilities for said DBAs are solely within SQL Server. Notice I said solely, as in nothing outside of SQL...

Contact your software reseller. Reporting Services is available for all SQL Server 2000 licenses. However, it looks like as MS has upgraded its site for SQL Server 2005, certain things...

Discussions on how to secure your SQL Server and database will go beyond any forum discussion. Are you trying to secure the database objects? What is the database going to...

Yes, I've gotten it working. Can you describe your setup and the error message you've gotten? I'm using a standard System DSN and connecting to it using the OLEDB Provider...

This is true, and the support for hyperthreading differs between Windows 2000 and 2003, making a hotfix specifically for SQL Server that much more difficult. Windows 2000 will see the...

xp_cmdshell & CmdExec are basically the same thing. You're shelling out to a command shell on both cases. However, if the application doesn't do a good job of error handling...

OK, I see what you're saying. By default they get the default domain policy but for some reason they override even that according to the MS docs. Hrm. Gotta test...

You can use sysindexes for the time being, but you probably want to query against the view sys.indexes. The column type_desc tells you what type of index it is. Clustered...

From http://www.sql-server-performance.com:

SQL Server 7.0 and 2000, by default, run in what is called "thread mode." What this means is that SQL Server uses what are called...

This is a known bug that happens after MS03-031. A hotfix is available here.

FIX: You are prompted for password confirmation after you change a...

Create yourself two columns. The first for @x, the second for @y. Follow through the program logic as if you were SQL Server. Keep track of what gets printed to...

Same result when you execute the xp_cmdshell manually, say through Query Analyzer?

I answered this in another posting of raj's. You cannot revoke access to the guest user in either master or tempdb. Bad things happen (Chris Leonard did this to test...

Unless the local policy is set to block the global policy, the domain policy, because it has a higher precendence, will override the local security policy. However, the policy that's...

Correct, but the question asks if you can set Check Password without Check Policy. You can't. If you want to perform password checking, policy checking is required.