Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO Create PROCEDURE [dbo].[P_sp_SubmittedDateIRBUser] /* ( @parameter1 int = 5, @parameter2 datatype OUTPUT ) */ ID int, IRBSubmittedDate nvarchar(50) AS /* SET NOCOUNT ON */ UPDATE tbl_info SET IRBSubmittedDate = @IRBSubmittedDate WHERE ID = @ID RETURN Msg 102, Level 15, State 1, Procedure P_sp_SubmittedDateIRBUser, Line 9 Incorrect syntax near 'ID'. Msg 137, Level 15, State 2, Procedure P_sp_SubmittedDateIRBUser, Line 15 Must declare the scalar variable "@IRBSubmittedDate".
Join the community of 500,000 technology professionals and ask your questions.