Well, they are really different even though they are both creating DB2 from DB1.

The first question was: how to create DB2 so that that DB2 will be a duplicate (copy)...

To all responders:

Thanks very much for the suggestions. I chose to use the one suggested by Leo (using Restore Wizard) since it is the easiest.

Grant Fritchey: Yes, you did respond...

Thank you very much DNA and Grant Fritchey for the quick responses! Yes, I was able to use Copy Database to duplicate my DB. I found out that on the...

Lenny, thanks for the suggestions. Solution # 1 suits my application. Thanks again.

sg2000

Lenny:

Thanks for the quick response. Yes, I just specified the input parameters for SP2 and it works OK, with the exception of the Return value. It seems that the return...

Thank you very much, ALZDBA, for the revised solution. Both of you are really great.

sg2000

zdravko , what a great solution! Yes, it does work (though I use the DISTINCT phrase on the last Select to eliminate some duplications). Thanks very very much for you...

ALZDBA, thanks for the response. However, the UNION as you and I used will not return multiple entries for the same person.

As I mentioned before, I have two tables:

FactoryEmply Tab....

GSquared, thank you very much for the suggestion. Yes, it works perfectly now.

sg2000

Steve and John:

Thanks both of you for the quick response, and also to John for the nice solution which works good enough for me.

However, I am still trying to...

jsheldon:

Thanks for the reply. However, I still think that when you click Modify on a SP, your main intention is to modify the existing SP; so why doesn't SQL Server...

I found both methods will catch null as well as single or multiple space; however, I'll use Jeremy's method as it is shorter. Thanks to all.

sg2000.

Thanks jeremy for the suggestion. Following your suggestion, I used

IF (@Name IS NULL OR @Name = '')

and found it working well.

sg2000

Thank you very much, Gail for the suggestion.

Steve, if that Gail's suggested is costly, do you recommend that we use two similar SQL statements?

Thanks all,

sg2000

Thanks Matt for the insight.

sg2000