This script obtains role member information, but not permissions of a role.

Try these for 2005:

SQL Server: Listing all the database roles for a given database user

SQL Server: Showing permissions for...

Out of the box? No. You'll either need to go with a monitoring tool capable of connecting with SQL Server, looking at the state of services on the server, or...

C2 Auditing? No. Trying to do too much with a server trace? Yes.

The name being used to connect must match the name of the certificate. One thing that may work better is to make an entry in the hosts file that matches...

Same idea. On your computer, run cliconfg.exe. This is the client network utility. You can force it on there.

You looking to track the server or the SQL Server itself? Also, what sort of agents/tools do you have in your environment?

That's not 100% true of Microsoft's support policy with regards to Microsoft applications on non-Microsoft virtualization. That policy is stated here:

Support policy for Microsoft software running in non-Microsoft hardware virtualization...

Did you import the certificate into the computer account (not the logged on user)?

What happens if you try to force encryption from say, QA?

With C2, just about everything is turned on. As a result, you do suffer a performance hit. I've seen it estimated as up to 20% percent. Realize that C2 mode...

An easy way is to open the log file, select all, copy, and then open up notepad on the host, paste.

If the application is doing the encryption and passing the encrypted hash to the database, then likely you just need a column that is varbinary format.

schumi (4/1/2008)

---

well after reading all the posts, i think a good conclusion (in my opinion) would be:

1) you need a BS to get a ticket to the HR office. But...

Think about the operation that would...

Jeff Moden (3/31/2008)

---

Thanks, Brian...

Just so everyone knows, sp_track_db_growth does not even come close to what the OP asked for. Rather, it tracks what size the backup files are. ...

Likely then you'll have to go with the Microsoft min. recommendations. Because these are CTP builds, Microsoft likely hasn't removed all of the debugging, meaning the CTPs aren't reflective of...