asp.net 2 role and membership and other tables

[sagey]

Hello,

i've just started writing an asp.net 2 application that will require users to login
etc etc.

I was going to have a look at using the built sql server role and membership providers. My question is this:

I have other tables that need to be related to users. for example in my app
a "member" may have many projects, so there will need to be a (prefereably ri) relationship between the 2 tables.

But can i/should i put my tables into the same database or do i have to keep them separate? also i presume there is a primary key in the member table?

[davebat]

I keep them in the same database, there is nothing special about the asp member/role tables as far as SQL server is concerned

[mendhak]

Of course in the same database. You only need to link them using foreign keys.