I understand about callbacks.  I also understand that you will (likely) never have callbacks from SQL server, especially to a web application.  From a web application, all queries to SQL...

MDAC version is important, but don't forget to check the IE version, also.  MSDE requires IE 5.01sp1 or greater.

Also, add the /L*v option to write verbose logging, and check the...

I have to disagree with this answer, and with the MSKB article 250367 referenced.  You only have to do the registry entries on the MSDTC server machine, not on the...

Thanks, Mark.  Forgot about that.  That's what I get for posting quickly on a late Fri afternoon. 

And thanks for one Mark picking up another.

Christy;

Best solution would be to normalize the data and put the surnames fields in a (sub-)table.  Then you only have to search the subtable.

But if a database redesign is not...

Serious DBAs will only use SQL ddl scripts to update the dev box (no changes done in enterprise manager), keep and track the scripts (in vss or just a staging...

How about using VMWare or VirtualPC to create an NT3.51 virtual server, and install SQL6.0 there?  Then you can access it from your host Windows 2000 machine.

As noeld said, your WSxx accounts will never get authenticated.  Tom was able to signon because he had some other service that did logon the JCC domain (probably a server...

Since you are using a local path during your test, I would suspect that the SQL Service running under local Admin account would work OK (unless that account had its...

Sorry Avi, I had misinterpreted your question.  I did not realize you were trying to access SQL Server over the internet.

While you can have a direct connection to SQL Server...

Contig uses same builtin defrag service in Windows 2000/XP/2003, but does it for one named file.  So instead of waiting for thousands of files to be checked and defragged, you...

Does the SQLServer account have the rights to write that file?  You start off saying you are trying to backup to a remote server, but your example shows writing to...

Slightly easier to bibucket49's method, but basically the same idea. 

On the workstation, create a new text file and name it with a .udl extension.  Then double-click on the file,...

This is probably heresy on a DBA board, but the correct answer is somewhere in between using all inline or all stored procedures.

I found the best approach is to use...

In my travels among different clients, I often see this.  The problem most often is fragmentation of the data (mdf) file(s).  Check the specific file fragmentation by using a tool...