Are you trying to ensure that a privId that you are about to associate with a roleID is not used by a different roleID? To do so you could do...

I have sorted the problem! When I changed the file type from ANSI to OEM everything was fine. What is the OEM format? Why were the imports working fine until now?

Cheers,

Olja

Brain, The IE browser is in active mode when I managed to access the ftp so so I don't think it is to do with the ftp mode (I suspected it might...

Thank you for your replies. I tried pinging the ftp address, but got the "host unknown" error. Does this mean that IE & WS Pro have a different method of...

Thank you for your help. After working through the suggestions you gave I concluded that the stored procedure wasn't seeing any data in the table! When I looked at the...

I was expecting a complex script that scans sys objects table - instead this was really simple and worked great! Cheers!

We finally solved our problem! All that needed to be done was to install the latest version of MDAC on the IIS server.

Thank you for your help.

Thank you very much for your replies. Specifying the port number with a comma did the trick when connecting from an IIS server on the same domain.

Unfortunately I still have...

This is an anwer that I got elsewhere:

What you may be seeing is the connection pooling

trying to maximize connection availablity and instead of creating/destroying

connections constantly it creates several connections that...

This might do the trick:SELECT * FROM calendar AS cWHERE c.eventID NOT IN (SELECT TOP 10 eventid FROM calendar AS nc WHERE nc.categoryID=c.categoryID ORDER BY eventDate)Is there a way that...

Thank you for your reply. What you have proposed could prove to be a more elegant solution, however the front end users want to have a clear distinction between the...

If I was you I would double check to ensure that the string is truncated when it is stored rather than when it is displayed. Try doing

Select len(comments) from testtable

Aside...

It is possible that your database compatibility was set to sql server 65 which I believe has a limit of 255 on the varchar fields. You can use sp_dbcmptlevel to...

Hi,

How are you inserting and retrieving this value. Is it directly through the query analyser or from your program? Some programing languages have a limit of 255 characters on the...

You can find information on sending HTML mail from sql using CDO on

http://support.microsoft.com/view/tn.asp?kb=312839