Thank you. They worked!

We got an .aspx page that gets called so many times a second. for some reason the SQL server holds the connection even though the connection is explicitly closed. We,...

Here is the error message from isqlw

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'FUNCTION'.

Server: Msg 137, Level 15, State 1, Line 8

Must declare the...

CREATE FUNCTION CubicVolume

-- Input dimensions in centimeters

(@CubeLength decimal(4,1), @CubeWidth decimal(4,1),

@CubeHeight decimal(4,1) )

RETURNS decimal(12,3) -- Cubic Centimeters.

AS

BEGIN

RETURN ( @CubeLength * @CubeWidth...