Forum Replies Created

Viewing 15 posts - 16 through 30 (of 224 total)

  • RE: Do you have DBA syndrome?

    Like most workplace communication issues, this is a management issue. Most of the time, the people are hardworking and competent, but the incentives are wrong.

    A DBA (and most other non-developer...

  • RE: CONCATENATE in DAX

    I Googled this and answered correctly, but I have no idea what this is. Work is using Excel 2010 and at home I have Excel 2011 for Mac. Someday...

  • RE: Homework...Enron data set

    There are embedded single quotes and embedded double quotes. Switching the QUOTED_IDENTIFIER setting will fix the single quote issue, but the embedded double quotes will then be just as much...

  • RE: Case when then dateadd getdate question

    Case expressions are short-circuit evaluated. The first expression that meets the criteria will be used.

    This one assumes that birth dates in the future and NULL birth dates should return...

  • RE: SQL Agent CmdExec fails with no message

    I had this problem occur again on a different server. This time, I found the error message. The message is in the Application Error Log in Windows Event Viewer. I...

  • RE: Re-raise error without the throw statement

    I did find the "hidden" transient error. It's in the SQL Server error log and occurs three times at the exact same second as the other error was logged.

    [298] SQLServer...

  • RE: SQL Agent CmdExec fails with no message

    Just to close this thread... the return code is void (.NET programs can return void from main). I don't know what's actually returned in that case, but it doesn't matter....

  • RE: IIS Configuration and Report Server

    IIS is not involved at all with SSRS (except in much older versions, but that's not what you are doing). There is no need to do anything with it for...

  • RE: IIS Configuration and Report Server

    I've had terrible results modifying the configiration xml directly. Different versions of SSRS have different requirements in terms of which tags are required and valid values. Many sites, including Microsoft...

  • RE: IIS Configuration and Report Server

    I think the following lines from the error log are most relevant. Open Reporting Services Configuration Manager and make sure the URLs are set. There is a URL for Reports...

  • RE: Proper Storage and Handling of Personal Names

    I would settle for having my last name properly spelled. There's some low-hanging fruit.

  • RE: Reporting Services 2016 503 error on attempting to fix authentication

    It's working!!

    I decided to delete the encryption keys AGAIN because I've changed the service account so many times already...

    After doing that, I could at least connect to the report...

  • RE: Reporting Services 2016 503 error on attempting to fix authentication

    I believe that I discovered the original issue. I was using instructions for configuring authentication that only applied to SSRS 2008, not R2 and later versions (this is 2016). I...

  • RE: Passwords Under Pressure

    I would like the ability to turn off password masking, maybe not all the time, but with a key to hold down to see what's been typed. I've attempted to...

  • RE: Lots of inserts? Part I

    tom.w.brannon (7/27/2016)


    I expected the answer to be that there was an error because tbl did not exist. Since that wasn't an option, I did some experimenting around the open...

Viewing 15 posts - 16 through 30 (of 224 total)