my question is how come the client did connect to my server when the Force encryption is off and the certificate isn't installed...???

you cannot set the FORCE...

• Enable the Force Protocol Encryption option on the server, OR on the client.
• If you enable Force Protocol Encryption on the server, you must install a certificate on the server....

http://msdn2.microsoft.com/en-us/library/ms181048(VS.80).aspx

http://msdn2.microsoft.com/en-us/library/ms998208.aspx

equally applicable

http://www.ericsink.com/scm/source_control.html

http://www.codeplex.com/VSTSGuidance/Wiki/View.aspx?title=Source%20Control%20Practices%20at%20a%20Glance&referringTitle=Home

mm.. actually you don't need to.

you can check out this link on the ms website

http://support.microsoft.com/kb/276553/ but its for sql 2000 ( it should be useful for 2005 as well)

and this...

did you associate your login with the certificate?

yes you can have employeeid as identity. being an identity column does not automatically mean that it becomes a primary key.

people usually use an identity column as the primary key, because...

no not really, its just a nice to have. i would probably think that your machine will cope.

actually why don't you get a fully functional app from the redgate site...

oh and you can use sql query execution plan to see where your query is taking time

select

txns.*, last_name as last_Name_from,

last_name as last_Name_to,

first_name as first_Name_from

yes you can. just make sure your machine has enough ram

i live for challenges, if its no big issue please post the code

i have used erwin and redgate(some). and to compare the two will be a bit difficult because i think erwin has more bias to logical design of a db whereas the...

is it possible to let us know the different course of action in case someone has a similar problem

what is the maximum size of the characters you get when you do a select on a single person. you might be bursting the limit

do a select sum(count()) on your...

yea just post the table ddl and some sample code, as long as it not confidential