StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>OK, this seems to be a pretty serious problem with the scope provisioning functionality. If I go to my source database that has been provisioned, and look at the data in the config_data column of the scope_config table, I see, in the xml, that the aspnet_Users table is described in an incorrect manner:</p> <pre><code> <Adapter Name="[aspnet_Users]" GlobalName="[aspnet_Users]" TrackingTable="[aspnet_Users_tracking]" SelChngProc="[aspnet_Users_selectchanges]" SelRowProc="[aspnet_Users_selectrow]" InsProc="[aspnet_Users_insert]" UpdProc="[aspnet_Users_update]" DelProc="[aspnet_Users_delete]" InsMetaProc="[aspnet_Users_insertmetadata]" UpdMetaProc="[aspnet_Users_updatemetadata]" DelMetaProc="[aspnet_Users_deletemetadata]" BulkTableType="[aspnet_Users_BulkType]" BulkInsProc="[aspnet_Users_bulkinsert]" BulkUpdProc="[aspnet_Users_bulkupdate]" BulkDelProc="[aspnet_Users_bulkdelete]" InsTrig="[aspnet_Users_insert_trigger]" UpdTrig="[aspnet_Users_update_trigger]" DelTrig="[aspnet_Users_delete_trigger]"> <Col name="ApplicationId" type="uniqueidentifier" param="@P_1" pk="true" /> <Col name="UserId" type="uniqueidentifier" param="@P_2" /> <Col name="UserName" type="nvarchar" size="256" param="@P_3" /> <Col name="LoweredUserName" type="nvarchar" size="256" param="@P_4" pk="true" /> <Col name="MobileAlias" type="nvarchar" size="16" null="true" param="@P_5" /> <Col name="IsAnonymous" type="bit" param="@P_6" /> <Col name="LastActivityDate" type="datetime" param="@P_7" /> </code></pre> <p></p> <p>You can see that the ApplicationId and the LoweredUserName columns are marked as pks, when they are not. And, the UserId column is not marked as a pk, when it should be. This incorrect data causes the tracking table that is created for the aspnet_Users table to be structured incorrectly so, simply fixing the xml in the scope_config table is not enough to fix the problem. So, it would appear that I have stumbled upon a pretty large problem that will take some work to correct. I don't think I am doing anything to create this error, as I am not setting any parameters when performing the server configuration. </p> <p>I have not been able to find a description of this problem anywhere else, which I find really strange but, I will keep looking.</p> <p>Ugh!</p> <p>I will include an image from the explorer in my SQL Server Management Studio.</p> <p>Thank you, JuneT, for your willingness to help.</p> <p><img src="https://i.stack.imgur.com/6OMUl.png" alt="enter image description here"></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload