Is their a possibility that i can create stored prodedures on users database automatically by writing a script. Because i have many users of this system may be 100 i cannot create stored procedures on their databases separately. <BR><BR>may be in the script I can write <BR>CREATE PROCEDURE ---- bla bla<BR>CREATE PROCEDURE -----bla bla<BR>and it might create this stored procedure on the database.<BR><BR>Note: This is my thought. Want to know if this possible ?? What other ways can be used ??