ASPNETDB ASP.Net Membership Problem with Custom Table

• Brenna Duncan-211418

  Right there with Babe

  Points: 777

  More actions

  April 5, 2008 at 11:55 am

  #184809

  Hello,

  I am use the standard membership functionality for a Visual Studio 2005 Web solution. I created a custom table named aspnet_UserInfo to store user information (FirstName, LastName) that is not part of the standard table structure. I am trying to connect to the ASPNETDB.MDF file from another database (which is why I am using the database name, owner and table name in my query). I do not have a problem connecting to any other table in the ASPNETDB.MDF database,for example aspnet_Users, except the custom aspnet_UserInfo table.

  SELECT UI.FirstName + ' ' + UI.LastName FROM

  [C:\DOCUMENTS AND SETTINGS\BRENNA DUNCAN\MY DOCUMENTS\VISUAL STUDIO 2005\WEBSITES\SDAMC\APP_DATA\ASPNETDB.MDF].dbo.aspnet_Users U

  INNER JOIN [C:\DOCUMENTS AND SETTINGS\BRENNA DUNCAN\MY DOCUMENTS\VISUAL STUDIO 2005\WEBSITES\SDAMC\APP_DATA\ASPNETDB.MDF].dbo.aspnet_UserInfo UI

  ON U.UserID = UI.UserID

  I can see my aspnet_UserInfo table from the Server Explorer in Visual Studio 2005 but I cannot see the table in MS SQL Server Management Studio Express.

  Has anyone encountered this before?

  Please let me know if I can provide any additional information.

  Thank you!

  Brenna