I have noticed that the repository database is being updated but having issues with the reports not being in synch with the database..

I have been to microsoft and there really...

What I am needing to do is a "hot" backup of the reporting services database..  Would I do this as I would any other database? In our environment we are using...

I am using stored procedures in the 'data' tab to pull multiple datasets.  This seems to work well.

example:  (name of dataset) land, land1, etc...  exec <name of proc> then you...

okay this is what I have found!!  use

exec sp_helplogins

this will give you server logins, database users, and permissions! 

I am also having this problem I need to know all users for server logins as well as database users and roles.  I did see the article on 7 scripts...

In our environment we simply use

grant exec on <sproc> to [User/user group(we use groups)]

revoke exec on <sproc>to public

hope this helps.

Good morning, this site has a webinar on it called:

Microsoft SQL Server Reporting Services Technical Overview—Demo 3: Managing Reports at:

http://www.microsoft.com/seminar/mmcfeed/mmcdisplay.asp?lang=en&pf=100501

I am fairly...

thank you very much and the only thing that seems to be not working now is after I converted to float it did give me a decimal, however it cut...

I was thinking to do a convert as the 'acres' is a smallint and I need the decimal placement.

select 'Unincorporated'

select distinct b.sizegroup, count(b.acres) 'Number Of Parcels', sum(b.acres) 'Total Acreage'

 from 

  ...

Okay I understand

2. The style of case you used only supports simple constant equality comparisons. You are trying to use a shorthand boolean comparison. You need to convert it...

Thank you for the help. 

Sheila