yousefshokati wrote: This produces me me a big problem Increasing session timeout so you can track users is unlikely to ever be a good idea. As one example exactly what do you think is going to happen to your system if a 'user' goes on vacation for two weeks but that user remains logged in? Also it appears that you are attempting to manage permissions by user rather than role. And that is going to become a problem with more than a couple of users.

yes an SQL login can be mapped to more than one DB user. Picture an SQL login as an access to a building while a DB user provides specific access to rooms in the building. No access to the building (Login) then no access to the rooms (DB user).

The easiest option would be to open the instance up in SQL Server 2005 from your last working backup. If this is not an option for you. you might want to read this[^] article. Warning! Anything you do here is at your own risk - if you don't have backups to go back to, you could be well and truly stuffed. *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

You set the default collation of SQL server to a different value than was in your previous installation. Change the default collation for your SQL server to the value which you explicitly set for the column which results in the error shown.

You're rather presumptuous. Although there are situations in which products and category have a many to many relationship, there are many real world situations in which a product belows to one category.

yousefshokati wrote: Hi And tanks for your answer You're welcome :) yousefshokati wrote: You say that When we design our database , we should design in a way that we do not have any closed path ? Am I right? I'm saying that you should normalize the design; that will eliminate all weird stuff from the design and give you something you can work with. I know that it's a bit of an investment in terms of time, but it repays itself rather quickly. yousefshokati wrote: We have MembersTable Which represents the members of teams and we have TeamsTable That represents the Team Entity Now We have to relations between these 2 . The First relation is "Plays For" which means that "Member Plays for team A for example " and the second is "Captain Of" which stands for "Members x is captain of team A" . Now if we update one of these FK s that are in tables for creating the relationships then we will get an error , won't be? Yes, you will. Normalization would state that you don't need the second entity. MembersTable MemberId MemberName IsCaptain Best wishes for the year to come :) Bastard Programmer from Hell :suss:

And the following doesn't do it? select PersonelCode , MyFunction(PersonelCode), ... from PersonnelTable

How about SELECT PersonelCode ,MyFunction(PersonelCode), ... FROM PersonnelTable

googling for Failed to open malformed assembly with HRESULT 0x80070008 turned up this[^]. Check your disk! :) Luc Pattyn [My Articles] Nil Volentibus Arduum

If I may ask, what inserts records in table_B; is it a stored procedure? If so, I would use the same stored procedure to call the web service immediately after it inserts data. I don't know if ordinary stored procedures can call web services so I would suggest an extended stored procedure i.e. a CLR dll. I haven't done anthing like it; so I am really just guessing.

THE TRIGGER WON'T HAVE PARAMETERS.

yousefshokati wrote: and with foreign keys that i am sure are needed Based on what you posted I am sure that some are are not needed. I seriously doubt that there is any reason for Properites to have HardwareTypeID. That is just an enumeration which can stand on its own. You tie the enumeration to something else via Values and that is sufficient.

Just start with the basics. Here[^] is a good article on Word Automation to start you off. When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

http://www.amazon.co.uk/Programming-WCF-Services-Mastering-AppFabric/dp/0596805489/ref=sr_1_2?s=books&ie=UTF8&qid=1322686035&sr=1-2[^] I recently got this book it is great, one of the best presented tech books i've ever read. get it and you will know what WCF is all about good luck

You have already posted this in the WCF and Visual Basic forums; please selct one forum only for your questions. Unrequited desire is character building. OriginalGriff I'm sitting here giving you a standing ovation - Len Goodman

If the service is defined in the current solution, try building the solution and adding the service reference again.

I love u so Much . Thanks a million for your guides . At first i could not get what you mean . for That accept my apologies . I had changed the type of every one of my variables but i had problem only on the return type of the Function . It must have been BigInt too . Thank you so much You helped me a lot Bye the way My Name is "Yousef" . It is same as "Josef" thanks and have a nice day