Error when executing the procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ian Stirk » Error when executing the procedure

Error when executing the procedure

Rate Topic

Display Mode

Topic Options

Author

Message

Darren Lacy

Posted Tuesday, October 28, 2008 6:37 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 12:13 PM
Points: 33, Visits: 44

Nice 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 17
Invalid 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.

Post #592805

danschl

Posted Tuesday, October 28, 2008 1:06 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:37 AM
Points: 1,382, Visits: 641

Very nice, now if i could just get everbody here to get off of sql 2000 i would be set

Post #593190

vasanth-257691

Posted Wednesday, July 01, 2009 2:14 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, September 12, 2011 10:03 AM
Points: 13, Visits: 73

i 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 ?

Post #745160

« Prev Topic | Next Topic »

Permissions