Don't forget that your calculations will just give you the distance as the crow flies, not the surface travel distance.  The two can be significantly different where a river estuary...

There are some problems with dynamic disks that can hit any machine, not just SQL Server ones.  The problems appear to stem from the (Windows) database that holds details about...

I once detached tempdb to see what happens, and how to get things working again.  As far as I can remember, this is what I did...

1) Start SQL with the...

I would go with the approach of C70070540 (Are you related to R2D2?), with a few tweaks.

First build the new server with a different name, connect it to the SAN, and...

The advice I have heard from SQL Server MVPs who have been involved with SQL2005 DTS since alpha-test days is that it is best to re-engineer your DTS, and not...

It is quite easy to save a database diagram as a .pdf document. 

This is done by printing the document to a virtual printer that outputs the results as a...

It sounds like what you want to do is to have a template of security permissions that will be automatically applied to an object when it is created. 

This is...

Lots of things are not supported or stop working when running in Fiber mode.  A KB search for "Fiber mode" shows some of the issues.

My suggestion is to turn off Fiber mode...

What justification do the Network people have for needing SA rights?

If they act as a backup to the DBAs, then SA might be justified.  In our shop, there are enough...

C2 audit mode is based in the C2 definition in the US DOD 5200.28 standard.  This standard is now obsolete and has been replaced be a security evaluation system called...

My experience is that there are 2 most likely possibilities:

1) The W2003 DB server is very badly tuned and is running slowly.  This is unlikely, unless your site has done...

If you use SQLBackTrack backup/recovery software from BMC, this can be done.  With standard SQL Server backup/recovery the answer is no.

Apart from anything else, your clause '@LearnID IN (puTOP_SECTIONID)' is the wrong way round.  The IN clause works like 'needle IN haystack'.  Try rewriting it as 'puTOP_SECTIONID IN...

To get PSS support, phone your local Microsoft office.  If that is not the right number they will give it to you.  When you get to PSS, you will either...

If you use W2003, you do not have any choice about using MDAC 2.8 - it is the version shipped with W2003.