Viewing 15 posts - 5,491 through 5,505 (of 6,400 total)
Daniel Bowlin (3/21/2012)
Put a filter on your weekly that is something like Datefield >= Dateadd("d",-7,Today()).
Put a filter on your monthly that...
March 21, 2012 at 12:40 pm
yeah will be do able, can do it in the t-sql for the data set or in the tablix properties as a filter expression.
i'm leaving the office for the day...
March 21, 2012 at 10:03 am
Lynn Pettis (3/21/2012)
Steve Jones - SSC Editor (3/21/2012)
Lynn Pettis (3/21/2012)
March 21, 2012 at 9:49 am
in terms of past week is it say, I run the report on a Friday so I want to see data from Friday to Friday (exact 7 days) or is...
March 21, 2012 at 9:47 am
as long as it doesnt use anything which is in the Differences Between Lower Compatibility Levels and Level 100 section of that article then yes
March 21, 2012 at 9:36 am
the compatiability level only affects certain things like DBCC CHECKDB etc which behave differently between 2000 and 2008
take a look here for the difference which are affected with the compatability...
March 21, 2012 at 9:29 am
as long as the differential backup taken from the primary is in sync with the full backup which initialised the secondary you should be ok. if you have done...
March 21, 2012 at 9:26 am
http://msdn.microsoft.com/en-us/library/bb326318.aspx
Possible Causes
Another database is already using the file name.
Are you sure that the files dont already exist?
How are you doing the restore via T-SQL script or the wizard?
March 21, 2012 at 4:19 am
take a look at the restore database commands in BOL or google it will detail how to use with move and replace etc
the problem is your trying to restore a...
March 21, 2012 at 4:12 am
far to much to detail on a forum, as Koen suggested a Google search will be the best way to go
March 21, 2012 at 4:09 am
its not true load balancing, you can spread out the reads but you cant spread out the writes.
March 21, 2012 at 2:14 am
no, its only a fail over cluster for the database engine, you can load balance SSRS but that is done via stand alone nodes using scaled out deployment, SSRS and...
March 21, 2012 at 1:59 am
the script i provided will also give you the information but for all reports which have subscriptions so your not having to load each report to view its individual subscriptions
March 21, 2012 at 1:55 am
your confusing the physical user with the actual user, its the user which is running the AOT which needs to be sysadmin or DB_Owner not the user sat in the...
March 21, 2012 at 1:54 am
Viewing 15 posts - 5,491 through 5,505 (of 6,400 total)