SQL Server 2008 Insert Stored Procedure Executes but the record does not stay.
1. Application calls the stored procedure, passing the data.
2. I see that the new record is created and is in the table.
3. Moved off of the page in the application.
4. The new record is gone.
ALTER PROCEDURE [dbo].[Procedure]
SET NOCOUNT ON;
INSERT INTO [dbo].[Tablename](Document, UploadDate, Label, PermitID)
VALUES(@Document, @UploadDate, @Label, @PermitID);