Find Indexes on columns

SELECT OBJECT_NAME(sys.sysindexes.id) AS [object name], INDEX_COL(OBJECT_NAME(sys.sysindexes.id), sys.sysindexes.indid, 1) AS [column]

FROM sys.sysindexes
INNER JOIN

sys.sysobjects
ON sys.sysobjects.id = sys.sysindexes.id

WHERE (sys.sysobjects.xtype
IN ('u', 'v')) AND (sys.sysindexes.status
= 0) AND (INDEX_COL(OBJECT_NAME(sys.sysindexes.id), sys.sysindexes.indid, 1) IS NOT NULL)

ORDER BY [object name]

Membership database permissions.

sp_help 'aspnet_CheckSchemaVersion'
-- if the website has an error lke
-- EXECUTE permission denied on object 'aspnet_CheckSchemaVersion'...
-- look inside your database to decide who gets permissions.
sp_addrolemember 'aspnet_Membership_FullAccess', 'username'


note: if you don't know anything about asp.net memberships and have the SQL server management studio, search for the application on your computer called aspnet_regsql.exe.

That will pop up a wizard and will install the membership database you will neeed for membership on your asp.net website.

background: I stumbled upon this when I installed asp.net's default personal webpage template.