High Folks,

My timeout was not a sql timeout apparently. It was an application timeout. The default ADO execution timeout is 30 seconds which was why I was getting errors.

thanks

thanks Grant.. would it make a difference if I ran the create function definition/statement before running the extended property statement because that is what I did.

thanks Steve.. I want to know if is necessary though

if you don't want to use a domain account here are instruction to use certificate for local accounts. Unfortunately I have no experience with doing it like this

I feel quite embarassed as it seems that the client was actually trusting the server certificate.

It seems as long as you have any certificate in the clients computer trusted ca...

I think I got it sorted.. cliconfig is for SQL 2000 dbs.. My certificate trust issue is sorted and not related.

yes that does make sense.. thank you Barry.

I think you can use mirroring if you use certificates

http://msdn.microsoft.com/en-us/library/ms191477.aspx

thanks Edward .. you have been a big help!

I can see the text in a tds.blob frame.

How can I filter this further so that I only show the frame

that has...

seemes to be working now to some degree

It seems no matter whether I have Force Encryption On or Off I am getting SSL packets in Microsoft Network Monitor when I...

thank you Jacob... its great to get some help on this cos I really struggling. I am relieved that it does not use 443 (which I though it would) because...

After deleting the encryption content .. I have a problem with report manager now.

An internal error occurred on the report server. See the error log for more details. (rsInternalError)...

If I connect to a named instance via ODBC don't I have to specify the port?

From my understanding transactions are dynamic and different transactions effect different table... so how can you know what table a future transaction can effect?

I have backups of the databases before I deleted the encrypted content.. is that helpful?