What is the error?

This is true of Windows 2000 Server and Windows Server 2003. However, you do have the option of "downgrading" a license if you still need Windows 2000. This is true...

That's one way. Another way is someone went into services and accidentally shut it down that way if they possess admin rights. Unless SQL Server Agent was also running they'd...

So far, without building a dynamic SQL query, I haven't found a way. I wish I could execute a subquery in the parentheses but every method I've tried has failed.

Sweet. I'll have to mark down the forums.

How do you tell the difference between users and groups?

Without going to another layer, there's no stopping another member of the sysadmin role from accessing the keys. So if you're not going through, say, an application layer which the...

Can you post your data definition language (DDL)? From that we can help you build the recursive query properly. Also, is this for SQL Server 2000 or SQL Server 2005?...

Well, the comments on the review has kind of turned into the forum for it.

Have you taken a look at the following:

A backup of a Windows NT or a Windows 2000 computer fails with Event ID 1450: Insufficient system resources...

Unfortunately, if they control the MSDE install, they're going to be able to control access to it. Without resorting to encrypting the data in the application, there's not a whole...

If the application is logging in as the log an as the local system account, That's seen as NT AUTHORITY\SYSTEM by SQL Server. If you don't have BUILTIN\Administrators with access...

EM isn't going to contain this information. One of the things you can do is profile activity filtered to restrict only to a database you don't believe is still in...

In this case you're going to probably want to call Microsoft support. The obvious points of failure aren't the cause.

It probably is. I know from an interview Brian Knight with SQL PASS they are considering such things. You might drop a note to him or Steve Jones about it....