Viewing 15 posts - 106 through 120 (of 1,220 total)
You may also need to restore ReportServerDB. You will need to backup and restore the encryption key from the 2005 instance to the 2008 R2 instance.
Yes it should...
March 16, 2015 at 8:51 pm
If you cannot use a FUNCTION in your CHECK constraint, then you cannot reference another table in the CHECK constraint. Using a FUNCTION is the only way to achieve...
March 12, 2015 at 9:32 pm
I would recommend that you create hierarchies and relationships between attributes where there is actually a relationship between the attributes. This allows SSAS to utilise the aggregations for each...
March 12, 2015 at 9:31 pm
lebraix (3/12/2015)
At the end of a MS Access process, we call a stored procedure that starts the job that calls...
March 12, 2015 at 9:22 pm
Each series has a Visibility property. You should be able to use this to conditionally show each series.
March 12, 2015 at 9:17 pm
You can't do this. SSMS will show databases that the user has access to. You need to make your user a member of (at least) one of the...
March 11, 2015 at 9:08 pm
Try something like
select
Field1
, Field2
, DENSE_RANK () OVER (ORDER BY Field1) AS SeqNo
FROM YourTable
March 5, 2015 at 8:01 pm
If you are not hung up on needed a stored proc to do this, you can very easily script the content of a database table as a set of INSERT...
March 1, 2015 at 7:53 pm
Restore both of the reportserver databases to the new instance. Some back I tried just the ReportServer database and got an error that I can't remember - restore both...
February 23, 2015 at 8:03 pm
Enter the values with a separator (e.g. a comma or a semi colon) in the report. When using the parameter with SQL, use a function to split it...
February 23, 2015 at 7:58 pm
You will need do run another full backup after you have switched to full recovery
February 23, 2015 at 7:41 pm
Not sure about SSRS 2005 but in SSRS 2012 - the Direction property can be an expression. In SSRS 2012, I would include information about the direction of the...
February 17, 2015 at 8:06 pm
If you are using Transactional Replication, there is no requirement for the table definitions to be the same. It is much easier if the tables are the same at...
February 17, 2015 at 7:58 pm
Why not just use the out of the box package logging ? It is real easy to get it to write to a database table. You can configure...
February 11, 2015 at 7:52 pm
Try http://dellwin/Reports instead. This is the URL you would normally use to view reports.
February 8, 2015 at 7:55 pm
Viewing 15 posts - 106 through 120 (of 1,220 total)