I'm with Allen in looking at whether or not the SQL Server is set up for case sensitivity. Many third party products require it, though in SQL Server 2000 you...

Not through the URL, no. Most of it happens behind the scenes. Here's what basically happens...

1) web client requests a web page

2) Web server send back a response saying authentication...

The security community has basically (finally) adopted deny all by default as a best practice. Quite a few were screaming the firewall deny all to start with, and the user...

Yup. Same reason for users into groups. No one-to-one relationship, so a group is recommended. Another example that could come up in even a single domain is you have two...

I guess in order to put in all the provisos: really this depends on the size of your organization, the amount of change that occurs, and the likelihood of B2B...

Best practice is still to create roles. You never know when you might suddenly need two groups that need that access instead of one. Been there, done that. Recommendation from...

There are some third party products that do this sort of thing (the names escape me... only 2 hours sleep last night). But I don't know if they parse or...

In your code you're actually looking for two distinct recordsets, right? Not both results returned in a single recordset. Basically using the NextRecordset method...

NextRecordset Example

I don't use sysdepends. Sysdepends is notoriously inaccurate. Unfortunately, shorting of parsing each stored procedure's code I don't know of a viable alternative.

From a security perspective this philosophy has changed greatly. Even those of us who used to recommend running as a full-blown administrator do not any longer. Too many issues you...

Yes. When the stored procedure was originally created, it referenced the other 20 or so stored procedures but those stored procedures hadn't been created yet. This doesn't stop the stored...

No, not in SQL Server 2000 (there is help on the way in SQL Server 2005). When you run dynamic SQL in SQL Server 2000, it executes that code in...

DB Owner:

1) Create login.

2) Database Access tab - Put a check beside the database in the top section and then put a check beside db_owner in the bottom section. You'll...

This should be of some help.

Microsoft KB 263556 - INF: How to Configure SQL Mail

It has instructions below the section for Exchange for what needs to...

The owner is the database user. A Windows group is technically a login to the SQL Server. That gets mapped into the database as a single database user.