locked
Missing stored procedure? RRS feed

  • Question

  • User-785518903 posted
    Hi!

    I want to get start with ASP.net 2.0 with the TimeTracker Starter Kit.
    Now I'm trying to install it and to run it. But after many hours I now get this error messages:
    Could not find stored procedure 'aspnet_starterkits_GetAllProjects'.
    Can somebody please to get it run on my local system?
    Is there any documentation of how to install this Starter Kit and how to get it running?

    CU
    Jens

    Sorry for my bad English!
    Sunday, February 5, 2006 1:41 PM

All replies

  • User1433868715 posted
    Did you resolve this? I am having the same problem!
    Thursday, December 14, 2006 9:15 AM
  • User-1963844416 posted

    Here is the source:

    ****** Object:  Stored Procedure dbo.aspnet_starterkits_GetAllProjects    Script Date: 11/8/2004 9:21:35 PM ******/

    CREATE      PROCEDURE aspnet_starterkits_GetAllProjects
    AS
    SELECT
     
     aspnet_starterkits_Projects.*,
     Managers.UserName ProjectManagerDisplayName,
     Creators.UserName ProjectCreatorDisplayName,
     sum (TimeEntryDuration) as ProjectActualDuration
    FROM
     aspnet_starterkits_Projects
     INNER JOIN aspnet_users AS Managers ON Managers.UserId = aspnet_starterkits_Projects.ProjectManagerId 
     INNER JOIN aspnet_users AS Creators ON Creators.UserId = aspnet_starterkits_Projects.ProjectCreatorId 
     LEFT JOIN aspnet_starterkits_Projectcategories AS cat ON aspnet_starterkits_Projects.ProjectId= cat.ProjectId
     left JOIN aspnet_starterkits_TimeEntry as timeEntry  ON cat.CategoryId = timeEntry.CategoryId
    WHERE
     ProjectDisabled = 0
    group by
     aspnet_starterkits_Projects.ProjectId,
     aspnet_starterkits_Projects.ProjectName,
     aspnet_starterkits_Projects.ProjectDescription,
     aspnet_starterkits_Projects.ProjectCreationDate,
     aspnet_starterkits_Projects.ProjectDisabled,
     aspnet_starterkits_Projects.ProjectEstimateDuration,
     aspnet_starterkits_Projects.ProjectCompletionDate,
     aspnet_starterkits_Projects.ProjectCreatorId,
     aspnet_starterkits_Projects.ProjectManagerId,
     Managers.UserName,
     Creators.UserName

    ORDER BY
     ProjectName ASC

    =============================

    I ran the scripts in app_data to create a local (2000) db, hence I have the source

    Wednesday, December 27, 2006 3:09 PM
  • User555306248 posted
    Have u check whether there is TimeTracker.mdf or not ?
    Tuesday, April 24, 2007 11:51 PM