Can you post the snippet of code that's not working as it should (sanitized, of course, to protect your organization and your databases)? That would help a lot in trying...

Discourage is a good word here, just like "impede" when talking about how to keep system administrators out of a clustered SQL Server. However, if there is a rule that...

sounds like a bunch of FUD (Fear, Uncertainty, and Doubt) if you ask me. FireFox is my primary browser mainly because of tabbed browsing (it's not necessarily more secure... see...

It's usually a several month cycle from beta to RTM, at least according to my experience. We kicked around SP3 for a while before it went RTM.

Actually it's not so much sysadmin authority. The real level this hits home is at dbo. If a user is dbo within a database, no security applies. Since members of...

Someone did a comparison of the GIANT/Microsoft tool versus Spybot and at that point in time, the GIANT/Microsoft tool did detect a few more "hits." However, that's more of a...

Yes, you can use a certificate provided by your internal certificate server. However, both SQL Server and the clients will have to trust the root CA. Of course, this should...

Frank is spot on, as usual. Anyone mapped to dbo in a given database (such as the true database owner) ignores all permissions to include DENY within that database. Since...

Yup. Many configure their agent service to run as the local System account. Although truthfully there has always been an avenue to backup without the need for such rights (Backup...

You can specify a local account by \.

Since the service account will be a sysadmin role member, it will disregard any permissions you might set or revoke on the...

If you can, you always avoid accounts with full administrative rights. The local System account has that and more. Hence the reason it's generally advised against.

As far as that goes,...

At the DB level you can use sp_helprotect. Therefore, if you automate the tying of login to user, you should be able to script something to go through each database...

you can using ADSI as a linked server.

INFO: Performing a SQL Distributed Query by Using ADSI (299410)

Another solution is to extract the members of the...

Indexing Service, under NT 4.0, was bundled with IIS. Now, however, it can be installed separately as of Windows 2000 (as a matter of fact, it's what used to index...

They've clarified the position on processor licensing. If you're doing per processor and not per server, you can run as many instances as you want so long as the processors...