Hello Roy,

Thanks a lot. Your solution is what I was looking for. This makes my stored procedures work according to my requirement.

I have another concern here. An article in SQLServerCentral says there are some pitfalls with System Stored procedures.

The 2nd point in the article "http://www.sqlservercentral.com/articles/Administering/creatingasystemstoredprocedure/1358/" says

--------------------------------------------------------------------------------------------

2. You must keep a copy of the SP somewhere else because when the master database gets rebuilt your system stored procedures will be gone. This could also happen when applying a service pack and/or during an upgrade to a different version of SQL Server.

--------------------------------------------------------------------------------------------

Is this true? if so, how can I overcome this issue? I will be having more than 100 or nearly 200 SPs this way. Even if I keep a copy of the queries used in these SPs, it will be a tedious job to create so many SPs again in future .

Please suggest me a solution/ work around for this issue.

Thanks a lot in advance,

Tarish.