InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 09:37:06 GMT20http://www.sqlservercentral.com/Forums/Topic592805-1358-1.aspxi was using this sql in prod environment.i also got the same error invalid length error in substring.i gave a try catch block inside the sp.why this error comes ?Wed, 01 Jul 2009 02:14:42 GMTvasanth-257691http://www.sqlservercentral.com/Forums/Topic592805-1358-1.aspxVery nice, now if i could just get everbody here to get off of sql 2000 i would be setTue, 28 Oct 2008 13:06:26 GMTdanschlhttp://www.sqlservercentral.com/Forums/Topic592805-1358-1.aspxNice script. While running this proc during a particular index rebuild, I get the following error:---Msg 536, Level 16, State 5, Procedure dba_WhatSQLIsExecuting, Line 17Invalid length parameter passed to the SUBSTRING function.---The sql I was running was:---USE [BI_DW]GO/****** Object: Index [idx_FXT_WHSE] Script Date: 10/28/2008 07:29:21 ******/IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[fact_Forecast]') AND name = N'idx_FXT_WHSE')DROP INDEX [idx_FXT_WHSE] ON [dbo].[fact_Forecast] WITH ( ONLINE = OFF )/****** Object: Index [idx_FXT_WHSE] Script Date: 10/28/2008 07:29:39 ******/CREATE NONCLUSTERED INDEX [idx_FXT_WHSE] ON [dbo].[fact_Forecast] ( [WAREHOUSE_KEY] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF) ON [PRIMARY]---If I comment out the column with the substring, the procedure runs again. Any ideas?Thanks.Tue, 28 Oct 2008 06:37:53 GMTDarren Lacy