InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 05:05:18 GMT20http://www.sqlservercentral.com/Forums/Topic679253-391-1.aspxThank you man!:-PThu, 19 Mar 2009 20:33:15 GMTSimon Suhttp://www.sqlservercentral.com/Forums/Topic679253-391-1.aspx[quote]An error is appearI found the max length of the @ssql is 4000.[/quote]Hi, The issue is, eventhough you have set the @ssql variable as varchar(8000), it will take only 4000 characters. And the error you are getting is because of the dynamic query what you are constructing is having more than 4000 characters. Hence, I suggest you to use NVarchar(max) for @ssql variable. Hope this will solve the issue.Regards,Ashok SThu, 19 Mar 2009 05:02:52 GMTAshok.Shttp://www.sqlservercentral.com/Forums/Topic679253-391-1.aspxsys.objects.name is NVARCHAR[code]SELECT @ssql = @ssql + 'Drop procedure ' + CAST(name AS VARCHAR(128)) + ' '[/code]Thu, 19 Mar 2009 04:19:07 GMTMark-101232http://www.sqlservercentral.com/Forums/Topic679253-391-1.aspxI want to delete all the stored procedure I created in the database. I write the following statements:DECLARE @ssql varchar(8000)SET @ssql = ''SELECT @ssql = @ssql + 'Drop procedure ' + name + ' 'FROM sys.objects WHERE type = 'p'SELECT LEN(@ssql)EXECUTE ( @ssql )An error is appearI found the max length of the @ssql is 4000.ThanksThu, 19 Mar 2009 03:48:45 GMTSimon Su