1
Vote

Many stored procedures have hard-coded syntax pointing to a local directory

description

I can't run this project because many of your stored procedures have hard-coded paths to C:\Users\Lorraine\Documents\Visual Studio 2008\Projects\jaws\WebApp\App_Data\jaws.mdf
Look at DeleteExpiredSessions for example:
 
ALTER PROCEDURE dbo.DeleteExpiredSessions
    AS
        DECLARE @now datetime
        SET @now = GETUTCDATE()
 
        DELETE [C:\Users\Lorraine\Documents\Visual Studio 2008\Projects\jaws\WebApp\App_Data\jaws.mdf].dbo.ASPStateTempSessions
        WHERE Expires < @now
 
        RETURN 0

comments