CODEWITHSUNDEEP
asp.net-membership
John
John

Reputation: 1499

Creating aspnet_membership table, need script please

Does anyone out there have a create script for aspnet_membership table?

I found a data structure for it on MS site but cannot find a script to create it anywhere on the web.

Many thanks in advance

J

Upvotes: 1

Views: 1539

Answers (2)

Sky Sanders
Sky Sanders

Reputation: 37084

aspnet_regsql can emit the script for you using the correct options.

a basic example:

C:\Windows\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe -S server -d database -E -ed

The advantage to generating the script is that you can specify things like the schema to use and the features that you need and it will customize and compile a single script.

No need to cobble one together and the inherent risks involved.

Run it with /? to get a usage listing.

Upvotes: 2

edosoft
edosoft

Reputation: 17271

The script is installed with the .NET framework. Look for it here:

C:\Windows\Microsoft.NET\Framework\v2.0.50727\InstallMembership.sql

Note that this script asumes that InstallCommon.sql (found in the same dir) was run first.

Upvotes: 1

Related Questions