Thank you very much for your reply.

I have two questions about your reply.

The first one is:

this is my connection string inside my vb 6.0 app.

Provider=SQLNCLI;Server=fscg41;Database=SGCT;Uid=teste;Pwd=teste;Encrypt=yes;"

You say that i don't...

Suppose this:

I want to select all the names and addresses of people who have their name in table1 and table2. i can achieve this, for instance, with...

Thank you very much for the tip

Even if the inner join as to return millions of rows?

Your link resolved my problem, but i have dificulty in undestand something.

what are this users:

##MS_AgentSigningCertificate##

##MS_SQLAuthenticatorCertificate##

##MS_SQLReplicationSigningCertificate##

##MS_SQLResourceSigningCertificate##

Do they exist in all SQL Server 2005?

Thank you

Thank you , my problem was solved with your help.

How can i connect throught SSMS in single user mode?

yeph , i know but we have some specifyc situations in the company where we need to use this.

Thank you very much.

P.s - the connection to the server with SQL...

http://www.sqlskills.com/blogs/paul/2007/10/02/CHECKDBFromEveryAngleEMERGENCYModeRepairTheVeryVeryLastResort.aspx

Thank you very mutch.

My database problem is solved!

In step 8

(In the Certificates snap-in, expand Certificates, expand Personal, and then right-click Certificates, point to All Tasks, and then click Import.) of the link : http://msdn.microsoft.com/en-us/library/ms191192.aspx

This what i...

It's this, what i have to do?

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

If yes, i'm having dificulties in this step:

8) In the Certificates snap-in, expand Certificates, expand Personal, and then right-click Certificates, point to All Tasks,...

It's this, what i have to do?

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

If yes, i'm having dificulties in this step:

8) In the Certificates snap-in, expand Certificates, expand Personal, and then right-click Certificates, point to All Tasks,...

Other think that i have noticed is that when i changed the value of the force protcol encryptation to yes, when i restart my SQL Server Agent service it rases...

Ok that's what i will do (encrypt).

I was trying to do this (throught configutarion manager) and changed the value force protocol encryptation from NO, to yes.

Then i tested the connection,...

Thank you very mutch.

A direct question is: will data not be seen if i use profiler? or a sniffer? after encrypting?