this is the script i execute and i get that return

declare @char varchar(1000)

execute @char = dbo.createInsertSP 'autosp','tblspmatic'

select @char

the function return this one

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[autosp].[inserttblspmatic]') AND type in (N'P', N'PC')) DROP PROCEDURE [autosp].[inserttblspmatic]||CREATE PROC [autosp].[inserttblspmatic] ( ) AS -- Author:...

CREATE TABLE [dbo].[tblautosp](

[idprimary] [int] IDENTITY(1,1) NOT NULL,

[desc] [nchar](10) NULL,

CONSTRAINT [PK_tblautosp] PRIMARY KEY CLUSTERED

(

[idprimary] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,...

Hey hey hey

when i execute the function

Msg 537, Level 16, State 5, Procedure createInsertSP, Line 78

Invalid length parameter passed to the LEFT or SUBSTRING function.

Msg 537, Level 16, State...

hello there

your script execute successfully but,it doesnt create stored procedure ,canb you post an example.

thanks