will have to run the script from my server (local box)

Update from my local box ( SSS) to Development box (RRR).

--

do you mean that if the servers are linked only...

I think i need to Create a linked database ..but dont know how to do it?

sr

How can you tell if a Server is Linked or Remote Server?

I think its Remote server but not sure

Thanks SR

Its Ok .. i found the soultion .. i had Alias in the stored procedure and i had not pointed them to the right place. For ex:

Select Fname AS (First...

thanks for replying adam,i really appriciate it.

yes you got me right. i am tring to do both.

First i want to delete the reports in the reporting services.This is were...

I am new to reporting services ... how do i find out i am sysadmin or user?

Thanks adam,

Your suggestions did set me in the right direction. I was having trouble with the instances, the frist time i installes SQL RS 2005 (did not name a instance)...