I agree with Karl.  Check the client config utility on a machine whose connection is fast and configure a slower machine that way.  Make sure, though, that the network library...

The KEYS of the Kingdom

Alias (ok, so it's a TV title)

Crash (everyone's nightmare)

You are welcome.  That's what's so much fun about a community.

Don

<smacking forehead>  I just realized what you were saying with cc_pkg.exe.  Sorry.  That's the Component Checker and I was about to ask if you had tried running it.  Boy, would...

Hi, Jim.  I'm not sure you can remove MDAC on an XP OS.  If what I've read is correct, it is an integral part of the OS.  Do you receive...

Here is a link to a KB article regarding the event log warning:  http://www.support.microsoft.com/?id=303411.  This newsgroup entry indicates that it may not be a problem:  http://groups.google.com/group/microsoft.public.sqlserver.setup/browse_thread/thread/f9eaec9890177911/735c864af5c16782?lnk=st&q=SuperSocket+SpnRegister+Error+1355&rnum=9&hl=en#735c864af5c16782

Per the SQL...

Actually that log information is useful because it shows that the SQL Server is not listening on TCP/IP.  I see this sometimes in troubleshooting problems for clients.  Try this:

1.  stop...

Have you checked the errorlog for that instance, per Remi's suggestion?  Make sure that the system is actually listening on both TCP/IP and Named Pipes.  I have seen many instances...

If you downloaded MSDE Release A from Microsoft and used the default folder when you unzipped the files you can run the following command line to perform a basic install...

Don't know if you have solved this yet.  If no client machine can connect look for svrnetcn.exe on the server running SQL (usually under Program Files\Microsoft SQL Server\80\Tools\Binn).  Run it...

Hi, Chris, thanks for the info.  You may be right about the OS I am using.  I will check the newsgroups.

Don

If going the third party route is not an option you could create backup files from SQL Server then zip them and password protect the zip file.  A poor man's...

If you wanted to completely eliminate alpha characters, including the leading one, you could use the SUBSTRING function:

SELECT substring(account_k, 2, 4) AS Code, Count(*) AS Records

FROM dbo.YourTable

[WHERE substring(account_k, 2,...

I third the recommendation for the Transcender exams.  They help by simulating what you will see when you sit the real exam, not only the way the questions are phrased...