Routine_Definition - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Routine_Definition

Author

Topic

tmaiden
Yak Posting Veteran

86 Posts

Posted - 2010-06-25 : 10:34:59

In SQL 2005 the Routine_Definition field within INFORMATION_SCHEMA.ROUTINES is a VARCHAR(4000). Is there anyway to change this field to NVARCHAR(MAX).

Thanks

Sachin.Nand

2937 Posts

Posted - 2010-06-25 : 10:45:16

I dont think you can do that.

Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

tmaiden
Yak Posting Veteran

86 Posts

Posted - 2010-06-25 : 10:50:32

Is there anyway that I can script the backup of a stored procedure? I want to copy a stored procedure from one db to another without having to manually run the create script.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-25 : 11:00:15

Use

select object_definition(object_id('procedure'))

Madhivanan

Failing to plan is Planning to fail

tmaiden
Yak Posting Veteran

86 Posts

Posted - 2010-06-25 : 11:12:49

quote:
Originally posted by madhivanan

Use

select object_definition(object_id('procedure'))

Madhivanan

Failing to plan is Planning to fail

Thank you. Is it possible for me to also do this?
SELECT OBJECT_DEFINITION(OBJECT_ID(SPECIFIC_NAME))
FROM INFORMATION_SCHEMA.ROUTINES

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-06-25 : 11:19:07

quote:
Originally posted by tmaiden

quote:
Originally posted by madhivanan

Use

select object_definition(object_id('procedure'))

Madhivanan

Failing to plan is Planning to fail

Thank you. Is it possible for me to also do this?
SELECT OBJECT_DEFINITION(OBJECT_ID(SPECIFIC_NAME))
FROM INFORMATION_SCHEMA.ROUTINES