Your IIS configuration will matter. Does the IIS pass through authentication requests to the user? You can manage users/pwds in SQL Server for the web users, but you'll need to...

http://www.sqlservercentral.com/scripts/Administration/64602/

Matt, you are correct, but security is a series of hurdles. If you lose the laptop, there's an x% chance that someone will get the data if you have TDE...

the pipe isn't open, as shown in the error. Does the SQL Server error log on startup show listening on the port/pipe you're using? Are you on the same machine...

I've never tried other languages, but I would guess that the product keys are not language specific. You would just have to try one and see.

I believe that you are correct in that a processor license is needed for SQL. How are the users connecting to the server? Through the web?

Express could work, but it...

Also, are you local or remote to the SQL server?

With those servers and thinking DR and switchover, clustering will work, but it requires hardware to make work. I'm not sure if you could do a 6 node cluster, either.

I...

You don't need to drop the column and add it back. Reseed it instead, it does the same thing. Just set your seed at a place it won't conflict with...

By default, all of your processors will be used. You can use less if you configure the affinity mask.

Lots of adds and deletes can do it. Our AV program would add in 10k+ every time, and I think it trimmed out values older than a week once a...

What does this mean? "if I want to you only 2 what can i do"

Do you mean only use two processors for SQL Server? You can use the affinity mask...

There are two things to understand about identity.

1. It involves the "next" assigned value for a column.

2. It has nothing to do with existing values. It doesn't ensure uniqueness, it...

They can have Damon, as long as he doesn't go back to Boston. He's getting older, not sure about his defense, but he had some good hits in the post...

Eichpeel,

You can't win that one. If they gave differing amounts to people, new hires feel less important, though they might understand. However how do you quantify who did what? Some...