Home Forums Article Discussions Article Discussions by Author Discuss content posted by Divya Agrawal Problem with scripting objects through query RE: Problem with scripting objects through query

  • October 31, 2009 at 1:01 am

    #1073478

    ankitwaitshere (10/30/2009)

    .. All fine... but Why do I need OBJECT_DEFINITION(1234567) there...?? Is this to create the stored proc back?

    If so, it may not be possible as the function OBJECT_DEFINITION(1234567) returns only first few hundred chars I think...

    Thoughts??

    According to BOL, OBJECT_DEFINITION returns nvarchar(max) in both SQL2005 and SQL2008 so it should be fine.