Chris Kempster (who used to be a frequent poster here) has an eBook out titled SQL Server 2000 for the Oracle DBA. I have heard it's good, but I'm a...

Most encryption mechanisms will result in character codes you wouldn't normally find in a text stream. What encyption algorithms have you tried and how have you tried to read to/write...

I'm sure I can whip up a quick Perl script using LWP to look for any new post that comes into being and automatically insert a post from me saying,...

I'm an idgit for forgetting this, but that's how it goes. When we first started having problems with our Win2k3 cluster and distributed transactions, MS directed us to do some...

It may be a session expiration issue. I don't use the WYSWIG editor but instead use the plain text box and I get the behavior. Of course, it's always a...

The saying comes from the US Air Force. Of course, when you go in 30 days later, you get the same response. Meaning the person saying it can get their...

Your VMWare administrator can tweak the VM to have higher access to processors, memory, etc. but you're right, on identical hardware, you are losing something for the abstraction. You said...

Correct. Regardless of application, when a user logs in those rights will be granted.

If you need to grant permissions differently per application, look at application roles. Those really only...

Or to go with a standard phrase from my military days:

"Request denied. Resubmit in 30 days."

Like in Windows NTFS permissions, SQL Server will aggregate the permissions for he user. So if user A has SELECT permissions on table A explicitly assigned to the user and...

This is what we do. Our Change Control folks receive the logins from either the DBAs or our security team and alter the connection string (which is encrypted) accordingly. As...

sswords

Now where's my shirt?

I hope you're wearing it, otherwise your co-workers are probably looking at you funny. Okay, okay, bad joke!

When writing your script, do the following:

1) Check to see if the servers are online. You can use Win32_PingStatus to do so.

2) Check to see if the process of...

Because it gives you a choice of where the bulk of the files go. However, the way the SQL Server package is built, some files will go to the system...

A Google search pulls up some errors on the Novell support side but to get to the actual docs requires username/password. So there does seem to be some issue with...