Thanks for the information. It does seem like a lot of work. I think I will try scheduling the following query to run every couple of hours instead...

What exactly do you mean by this: "if you really need to know exactly how many queries are run against the database, you need to set that up ahead...

I figured it out. When creating the synonym I needed two dots after linked server name:

CREATE SYNONYM FISVEND

FOR DOA_FANS..FIS.VENDORS_V

GO

However...running the query from openquery took 39 seconds to return 215,848...

Yes, they need access to the data source as they are going to be creating ad-hoc reports on their own.

I tried Browser only right and they cannot see the data source in SSRS, but they also cannot see the data source with Report Builder. I gave the group...

Thanks guys - you are lifesavers! I have a dev box that does nothing so I will definitely run it on there.

That was my fear. If you already have code that will do this that would be great!!!! FYI-they don't want to delete/drop anything. They are working with...

So replication will allow me to take one database with only 1 login and apply that to another database with multiple logins with wiping out said multiple logins?

You can also use the "Copy Database" function.

Can I use the Copy Database wizard?

Thanks for the quick reply Lynn. Having no experience with multiple instances, could you possibly point me to some good reference material (other than books on line of course)....

I see on the Microssoft KB site that "SQL Server 2008 R2 SP2 contains the hotfixes that were included in Cumulative Update 1 through Cumulative Update 5 for SQL Server...

I figured mine out. Someone had gone into the local security policies and removed the network service from the log on as a service assignment. Once I added...

Did you figure it out? I am having the same problem.