SQL Server passwords are not case-sensitive, and I don't think you can change that. 

If you wanted to make sure SQL Server passwords had a minimum length or some other...

To get this information, you'll need to either physically watch the server or run some kind of monitoring / diagnostic software, right?  Either that, or work from log files.  Why...

Sounds like a future QOD...

Funny.  If he would've gotten picked, I think that SQLBill was on his way to becoming the Cowboy Neal of SQLServerCentral.

Oh admit it.  Some...

So are we ever going to get back to descriptive "titles" again?  I miss being a Forum Guru, though I didn't deserve it.  Right now, I'd settle for Grasshopper (as...

Hi Ian,

You know, after writing a mountain of code like that, I don't think you can consider yourself a newbie to SQL Server anymore.  I'm glad you posted this!

Chris

Hi Everdyn,

The short answer is that the DCS procedure should have call runtime..procname or runtime.procowner.procname, where procowner is the owner of the procedure, and procname is the name of the...

P Rajanikanth:

The connection string you are using is a DSN-less style string, so you don't need the "dsn=" at the end.  So I'm assuming that the following connection string will...

Hi cm,

What you want to do is create aliases on the alias tab of the Client Network Utility.  For example, if the instance at port 12345 is running on a...

Maybe this should go in the Suggestions forum?  But fwiw, I posted a similar suggestion on a thread here a little while back, and Brian *might* have said he was...

Wel ... maybe you can't. 

I had thought that if the originator of a thread went back and edited the first post, then they...

My favorite teaching example of a useless comment follows:

Useless comment:

/* Divide @nh by @nab, storing result in @bav: */

SELECT @bav =...

Whoops!  Sorry for that last post - I read the last post on the first page and responded to that.  Told you I'm not quite all here today!  I noticed...

Sorry for such a basic suggestion, but did you restart SQL Server and SQL Server Agent?  I know we suggested that earlier, but sometimes it matters.  The fact that you...

As long as the developers are members of db_ddladmin, they can force their objects to be owned by dbo.

For example, to create a new table:

create table dbo.t1...

I think you should definitely be able to do the memory locking using the fixed memory settings.

Also, is the box going to be licensed per-processor?  If so, you can install...