There is a reporting services call "SQL Server 2000 Reporting Services".

http://www.microsoft.com/sql/reporting/default.asp

Is this call Microsoft Reporting Services as well?

Sorry, i'm totaly new to SQL Server. Thanks.

Dear Kenneth's and David's,

Many thanks for the advise. It's worked. thanks a lots for the help. Now i learn when i should use join statement. Again...Thanks. 

Hi Kenneth,

Thanks for the reply. The problem i have is, there will be a multiple contact nos selected from the input parameter. All the contact nos will use in the WHERE clause to select...

Hi Trigger, Tal Mcmahon,

Thanks for the help. I will start from here. Thanks.

Hi HappyCat59,

Thanks for the help. Manage to make it work after added the subscribing server. Thanks.

Hi Happycat,

Thanks for the reply. i'm using SQL server login(as sysadmin) & yes, the login ID is added into publication access list. I able to connect to the publisher from another...

Hi All,

Thanks for all the advice. Thank you very much.

Hi All,

Thanks for all. I'm new in SQL Server world. As what i understand, we can perform transaction log, file & filegroups backup in MS SQL server backup &...