i have installed time.vsi and executing the same,but while creating new user it is showing that "Could not find stored procedure'dbo.aspnet_CheckSchemaVersion' and could you please tell me the use of that SP.and clearly explain the
aspnet_Users table. what columns that table contained?
anilgopathi
Member
1 Points
2 Posts
Stored procedure and table
Dec 28, 2007 08:36 AM|LINK
HI,
i have installed time.vsi and executing the same,but while creating new user it is showing that "Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion' and could you please tell me the use of that SP.and clearly explain the aspnet_Users table. what columns that table contained?
Thanks in Advance,
Anil
gopalanmani
Star
7826 Points
1320 Posts
Re: Stored procedure and table
Dec 28, 2007 11:20 AM|LINK
check this urls,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=435748&SiteID=1
http://p2p.wrox.com/topic.asp?TOPIC_ID=36846
Gopalan Mani
My Tech blog
gurpreet sn
Member
6 Points
4 Posts
Re: Stored procedure and table
Dec 28, 2007 11:32 AM|LINK
Hi,
When you create a new user then the system assigns a default schema for that user. try to check for the schema assigned to the new user
-GSN
chetan.sarod...
All-Star
65839 Points
11163 Posts
Re: Stored procedure and table
Dec 31, 2007 02:35 AM|LINK
In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..
You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt
aspnet_regsql, it will open one window, where you have to configure DB. So that necessary table, SP will be automatically included in your DB
Hope it will help you, let me know.
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
anilgopathi
Member
1 Points
2 Posts
Re: Stored procedure and table
Dec 31, 2007 04:34 AM|LINK
Thanks it is working....
Anil
chetan.sarod...
All-Star
65839 Points
11163 Posts
Re: Stored procedure and table
Jan 02, 2008 02:31 AM|LINK
Please mark it as answer, So it is helpful to other people
So the thead will be mark as solve
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.