Leon has some experience with it - I'll get him to post some comments.

Andy

If you're running SQL2000 just right click and select shrink database in EM.

Andy

Im guessing you're using TCPIP for your primary network protocol - you need to remove Named Pipes (or set it lower in the protocol order) on both machines, you want...

For the example you cited, Im not sure what would be better. In what way are they getting it wrong? Without knowing that, my first though is that you're mired...

You might try ODBCPing (in the BINN folder I think). If that fails, I'd get your router guy to check ports 1433 and 1434 on the router.

Andy

Hi Thorsten,

Sorry for the delay, been on a short vacation. What version of SQL and what service pack are you running? I found this on MSDN that relates to SQL7:

http://support.microsoft.com/support/kb/articles/Q224/3/29.ASP

If...

Ones that no one will say good things about?

Could you give some background on what you're going to do with the data?

Andy

Does it work ok with other files? Also, have you looked at the actual connections to your machine to see what is open?

Andy

Obviously the trick is getting the data out of Exchange. If you're running Win2K, here is one possibility:

http://support.microsoft.com/support/kb/articles/Q241/4/74.ASP

This shows how to export them:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q278154

There is also an OLEDB provider (have not...

In my opinion (!) this is not a great solution. If you're going to run all that code each time, why not juse execute the string and return the results....

Disconnect your recordset/use a static cursor.

Andy

You will also see this if you have an trigger that is modifying the same rows you just modified (to set a datestamp is a good example).

Andy

I don't think there would be much difference. Using sp's requires no client side support, with DMO you do have to have the supporting libraries on the client. You're not...

Returns nothing. Why would you have an object (c.name) that was null??

Andy