Are you executing the query from the server itself? In other words, are you remoted in/logged in at the console of the server where SQL Server is installed and running...

Microsoft's recommendation in Books Online is that SQL Server Agent not be a member of the local Administrators group. However, it must be a member of the sysadmin fixed server...

That is correct. And if it's on a domain (which is a better security option than, in most cases), there are additional attack vectors. Here's a short write-up on them:

Blog...

Yes, but you will have to encrypt based on each column. Also, you won't want every column encrypted, for this will kill any performance because you will be indexing on...

Replace the portions of your code with the applicable portions of the code I posted and it will work. I tested before posting.

The key is to secure the server. If someone gains administrative control over the server, they have control of your SQL Server. You can't stop them. So I think you're...

What error are you getting? If it's the password complexity error, try a password of something like 4SQLAuthority! instead. If it's the string or binary data would be truncated, make...

Safer is to grant CONTROL SERVER. Here's why. CONTROL SERVER means an explicit DENY will be honored. CONTROL SERVER also means that any operation is undertaken with the identity of...

Bhuvnesh (4/25/2010)

---

you can opt for C2 auditing although it is resource consuming as it's capturing all the database activity hence need to use only when high security is concern.

Some...

Right, I commented on that thread. If you follow it through to the end, you'll see that SQL Server doesn't store this information. You have to audit it using other...

There isn't a query to show when any account was last used, even a SQL Server-based one. Can you post that? As far as when a Windows account last logged...

webrunner (4/23/2010)

---

K. Brian Kelley (4/22/2010)

---

It can't be done. Here's why...

If I have admin rights on a server, I have debugging rights. If I have debugging rights, I can see the...

Can you filter your network connections? In other words, are the computers that SHOULD be connecting to SQL Server coming from known IP addresses? If so, an IPSEC policy (OS...

It can't be done. Here's why...

If I have admin rights on a server, I have debugging rights. If I have debugging rights, I can see the memory and I can...

Is the account you're using to connect from Delphi the same account you're using when you run the stored procedure directly?