The dbcreator fixed server role will allow database creation. It does not, give any particular access to an already existing database. Of course, if a given user creates a database,...

You may have "non-keyed media" with respect to the serial number meaning you wouldn't enter one. Do the CDs have any language like "SELECT" or anything of that sort on...

Pros and Cons:

SQL Server Security: Pros and Cons of Application Roles

udp/1434 is a listener service. If you don't know what port to talk to, you go and talk to it. Therefore it has to be statically configured. I can draw...

True, but it's not the exact same interface. If you run Server Network Utility as a stand-alone program, you only get the option to alter interfaces on the local system....

True, "easiest" is up for grabs as far as a definition. Some thoughts...

Server Network Utility - The choice, obviously. However, one of the issues is you have to run it...

If you're moving to a MySQL database that's on-line, you can use the MySQL ODBC driver and then use DTS to migrate the data instead of relying on a 3rd...

Are they members of any other group that would have been denied access?

If you take a close look at the sysusers table, the hasdbaccess column actually determines if the guest account is active. The row for the guest account should be in...

Then a tool like stacenic described makes the job really easy if that's possible. We're in a side-by-side and having to do a lot of conversions by hand. It's not...

If Sunday is defined as the start of the week, something like this works:

SELECT DATEADD(dd, -1 * (select datepart(dw, GETDATE()) -1), GETDATE())

You can use CONVERT() to get it into the...

Are you setting up a side-by-side NT 4.0 and AD or are you upgrading the existing AD environment?

There are approved SAN configurations for use with Windows clusters in general. When we had MS in here a while back (pre Windows 2000 SP3) we had to verify ours...

Our developers tend to use the Crypto provided with .NET and do it in the application, but there are some options from 3rd party vendors. Here are some:

Interesting... changes to tempdb might result in concurrency issues, but apparently this appeared before SP3. So I'm not sure it's even applicable to your situation. The article cites mostly the...