The operating system will open up ports for listening, just like you can open up multiple ports for say IIS. The various instances know to listen on those particular...

Here's the FAQ on the MCSD. They deal specifically with the question about recertifying:

http://www.microsoft.com/traincert/mcp/mcsd/faq.asp

I'm glad they came to their senses!

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

There are quite a few possibilities, here's a sampling.

You could use string fields for both. The drawback to that is if you're trying to retrieve all the records between...

Here's Microsoft's FAQ on SQL Server 2000 setup.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257716

One thing that stood out is the possiblity of an issue of MDAC install failure. If MDAC 2.6 didn't install...

We do like Antares suggests. If, during the week, there is a large enough update where stats should automatically refresh, they need to. However, as Antares has cited,...

They may be changing their ways. There was so much flak over MCSEs being decertified that Microsoft decided to add the version to it. Looking at the MCSD,...

I still like the idea of a lab exam for a premier certification or at least a top level certification with a lab exam if the rest don't. Model...

DBCC DROPCLEANBUFFERS is not recommended in a production environment as Antares indicates. It, however, only frees up the Buffer Cache Pool, which corresponds to data. DBCC FREEPROCCACHE removes...

This corresponds to a message back from the OS...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q186549

What, if anything was going on with the server at the time? As Antares has asked, what do the Event...

Since it's not defined as an INSTEAD OF trigger (not available prior to SQL 2000), that means the data operation has occurred. As a result, a ROLLBACK TRAN needs...

We've seen issues where our developers didn't set transaction state in COM+ properly. As a result, even though there weren't explicit BEGIN TRAN and COMMIT TRAN within SQL Server,...

Andy, don't feel bad.

Because of my previous experience as a systems administrator, I've been transitioned to an "Enterprise Systems Architect," which basically means I'm the one who gets...

Competent database developers should be allowed to develop unfettered. Key word is develop. I agree with Steve about moving to QA or Production. How you define competent...

How is the front-end application configured? Are you using MTS or COM+?

K. Brian Kelley

bkelley@sqlservercentral.com

http://www.sqlservercentral.com/columnists/bkelley/

You may want to explicitly set the ANSI_NULLs on with respect to the Internet app. Perhaps they are being set to OFF and that's causing the recompiles?

I'll be honest...