Thank you all for your reponses. I have been able to get a better picture but lets just hope I dont confuse the next time I read some other article...

Why do you want to save it as hyperlink. you can save it as normal text and when retrieving it in ur excel you can define you excel column as...

I used Teradata SQL Assistant client to execute some procedures in SQL Server. Since these had Print statements they failed...Sps without print were successfully executed.. I faced problem only due...

Please do not use print statement in your Sp. If some one trys to execute that sp from any other client apart from SSMS it will fail since Print Statement...

thanks...

Thanks..

I will be using Shell scripting..

I am trying to do this connection through script and not through any application.. Can anyone point me in right direction..

Can someone tell me how should deployments ideally happen ?? I dont need any out of the box techniques..

Hi Divya,

even through SQl cmd I will have to connect to database for which Use dn_name ; go will be needed...

No.. not at all..

Nothing has changed on the server also..

Its a simple etl.. takes few records from SQL server and put them on a text file

new project, need to instal it first before trying

No there is soem syntax problem in the create procedure .. i dint try it before posting.. Anyways what id the calling application is a separate group that does not...

what will @rc and @param return in your code??