I get this wonderful error:

Server Error in '/MCP' Application.

---

The resource cannot be found.

Description: HTTP 404. The resource you...

This worked great - it turns out I was missing MSVCP71.dll.  Put that into the directory and bingo.

Now one last question - Can I pipe...

I followed the steps you had said (I only have one instance of SQL Server running) and I had uninstalled everything based on your uninstall script.  I added the xp...

Max,

I feel very sorry for you if the only way you can get ahead in your company is to behave unethically.  If I felt that my company was forcing me...

Oops - I didn't read Phill's first post close enough, he did do the left outer join, I'm not used to reading queries where the joins are on the same line...

This is the way I do it.  It seems to work better than doing the WHERE NOT EXISTS type selects.

select t1.*

from t1

left outer join t2 on t2.custno = t1.custno and...

I was at the Chicago event a few weeks ago and we had an attendance of 4000 (yes four thousand!) people.  Most of the breakout sessions were worth watching and...

I for one am not happy that Quest bought out Imceda.  I finally found a tool that was worth it's weight in gold (Speed SQL IDE) and they are going...

The function I use was based on a feature that Clipper/dBase had.  There were two functions called PADL and PADR for "pad left and pad right".  Basically you passed in...

This happened to me over and over again - I got to the point where every few days the standby server was worthless and I couldn't continue with log shipping...

Hey Maurice,

I think this article might be what you are looking for.

http://www.aspheute.com/english/20000809.asp

There is another one on "The Code Project", but I think it's more on implementing counters in your...

I think that one of the things to do when setting up SQL Server as a security precaution is to change the default port to something else.  Someone internally at...

I can vouch for Litespeed based on my own experience.  I have a relatively small database (3gb) but I use Log Shipping to keep my standby server in synch.  The...

Another thing to try is to set the output to be Tab delimited (Tools | Options | Results) and then set "Default results to target:" to be "Results to Text"...