HI.. I have multiple databases . In a procedure I want to send Database name as parameter . Then I want to connect that database and execute some queries . Should any one know best solution without using dynamic sql. Thanks In Advance .........

You have to issue a USE statement or quantify the object names in the queries with the database name. Neither method supports using a parameter which is why all you'll see for this type of operation is dynamic SQL.