Thanks for your reply. While using SQLNS for creatng new stored procedure, the window that comes up is the same window what you see when you create a new SP

using Enterpise Manager. What I am trying to say here, I have no control on the contents of the Editor.. so a find/replace is not possible.

All we could do is make the window appear.

Here is the piece of code..

****************

Case SPAction.NewStoredProcedure

hItem = NSLIB.GetRootItem()

hItem = NSLIB.GetFirstChildItem(hItem, , "DBObject Stored Procedures")

nsObj = NSLIB.GetSQLNamespaceObject(hItem)

nsObj.ExecuteCommandByID(SQLNS.SQLNSCommandID.SQLNS_CmdID_NEW_STORED_PROCEDURE)

****************

I would be happy if you answer this question also..The Enterpise Manager has the option of saving the strucutre as a template. When we click "Save template", it prompts for "overwrite"?. where is this template information saved, in the system db or machine as a file?.

Regards,

Ganesh