Viewing 15 posts - 8,686 through 8,700 (of 9,715 total)
Delete or rename the .dll on the server where it's not working. Then add a copy from the server that is working and re-register it. It could be that...
September 4, 2008 at 4:17 am
I wasn't exactly sure what you meant by your previous post, but this last one clarifies what you're actually looking for.
The other solutions would be to:
1) break up your...
September 3, 2008 at 4:03 am
Carl, I appreciate your response, but your explanation doesn't give many details.
What type of user role (ie, what permissions or roles were assigned) did you use for your...
September 2, 2008 at 10:39 am
You can actually do this, it just requires a little bit of experimentation.
Set a parameter up in the subreport that populates 1 if you have tables returned and 0 if...
September 2, 2008 at 10:35 am
In which case, I would add the borderlines outside the subreport object in the main report rather than adding them inside the subreport itself.
See if that draws them all the...
September 2, 2008 at 4:38 am
Sorry, Doug. I was out for the weekend so didn't see your replies.
Hmm. BOL says that it includes database fixed roles or user-defined roles. And in testing myself added to...
September 2, 2008 at 4:33 am
Well that's seriously disappointing. I wonder why some people are able to have it installed from scratch and others aren't? There's got to be some setting or something that...
August 30, 2008 at 7:33 am
Is Admin_role a database role or an application role?
August 29, 2008 at 3:10 am
I got it to work for me when checking a database role of db_Owner.
It looks like it checks the current user against a Windows Domain account or checks the database...
August 28, 2008 at 5:20 pm
When you say "lines" do you mean border lines?
August 28, 2008 at 8:22 am
Yeah. I know, Carl. But when I said it was easy, I meant that it's hard to make the result of a Year function unconvertible to a datetime. I knew...
August 28, 2008 at 4:21 am
The speed of SSIS is supposed to be much better in SQL 2008. Apparently MS learned from the 2005 implementation and have added some "umph" to the engine. @=)
August 28, 2008 at 4:09 am
Small example.
In your dataflow, you have the following:
OLE DB Source1 -> Stage_DDA_Rev_Adj
OLE DB Source2 -> CIS_ACCount
--NOTE: Both sources have to be sorted. Advanced Editor, go to last tab, click on...
August 27, 2008 at 12:44 pm
Oh, believe me. I know that pain. I have approximately 150 nested formulas I had to redo from an excel workbook report so I could automate the report.
Nested upon nested...
August 27, 2008 at 10:55 am
Actually, looking back at your example, I'm not even seeing the reason you need to use variables at all. Why not just do your Select statements without them?
Going with...
August 27, 2008 at 10:34 am
Viewing 15 posts - 8,686 through 8,700 (of 9,715 total)