Ok it worked!

By the way, why do we have entrees in the Catalog table where the content field is null

I noticed that the table ExcutionLog only holds info for the last 3 months.

I may be wrong here. But let me know your thoughts on this

I believe when something is deleted it goes to the transaction log.

So if we had a tool to get the deleted info we could restore it back. Don't you think...

Sorry, I take that back!

Please disregard the previous reply.

The query did manage to split out the entire stored procedure.

So let me give it a try and let you know the...

Reply to Craig:

Ok, hers is what I am saying: I ran the following SQl in the SQL server management studio:

select [definition] AS ProcDef, LEN([definition]) as 'len'

from

...

Sorry,

It did not work.

Reason: My stored proc is very long. So when it outputs it puts only the code to a certain length. After that I don't see the...

I like the idea of using a variable ?

Ahh but you are sayng to load that variable I will have to use some special sql that will output the definition...

So all that I have to do then is run this at the c:> prompt ?

C:> runsql "Dev"

The actual file is runsql.bat sitting in the C:\ root drive.

Interesting

I wonder whether if you could throw some sample code on how the batch file should look like.

Also how do you plan to place the stored proc on 6 servers...

What is a SMOServer connection and how different is it from a OLEDB Connection ?

I kind of expected that someone would help me how to use the

"Trasnfer SQl Server Objects Task" component.

This might be the best way to get around the issue.

The only...

Sir

We have 6 servers and I have to deploy many stored procs in each of these servers. Doing them manually is a pain. Besides I run into situations where I...

Not clear what you are saying ?

Are you telling me a variable can handle more lines of code ?

1.)So then put the stored proc inside the variable ?

2.)Asign the variable...

Sorry the [name] appears only inside a sub report.

And also in my situation the "Sub Report" is inside a Group.

What is happeneing is, I am passing a ID ( from...

I guess I didn't explain this correctly.

The new text field sits in the main report. There is also a sub report.

The plan is to get a value from the sub...