Brad,

You've got it a little backwards. The dbo role is a predefined database role for each individual db that CANNOT be removed. The role maps to the db_owner rights. If...

You will probably need to change the identity that the Reporting Services service runs under to a domain account, and then create a login in SQL Server for that account...

You're going to need to write a VB macro or put a button on your sheet, something like that. The users would fill out specific cells with the values that...

The other solution would be to write a custom aggregate using CLR code and then you could just select your aggregate function with a group by country. By doing this,...

Try this:

SELECT

SubsTrans.PubCode

, SubsTrans.[Update]

,sum(CASE when SubsTrans

The catalog will only list DB's for the user that is trying to query the linked server, so you may very well have a permissions issue. Make sure that the...

I assume that gf.periodo is a datetime field, yet you are only supplying a year / month construct. Could this be a part of the issue?

Jo - gf is defined...

You need to query the underlying table to retrieve the year and populate the listbox. So you create parameter, and then set its datasource to be the query SELECT DISTINCT...

Thanks for the help everyone. Jeff Gray was correct. It ended up being a version issue. Applied SP4 (which we thought we already had) and issue was resolved.

Database is only partially replicated, so it can't be completely empty. The tables being replicated are being dropped and recreated. There are actually 4 articles, 3 of which are working...