Forum Replies Created

Viewing 15 posts - 301 through 315 (of 471 total)

  • RE: Server Audit

    It certainly looks that way.
    I've got domain admin access and I can run this script on every other server (this is the only server I've come across so far...

    January 30, 2017 at 8:51 am

    #1925616

  • RE: Server Audit

    Yeah, if I change the script to read:-
    EXEC xp_regenumvalues
    N'HKEY_LOCAL_MACHINE',
    N'SOFTWARE\Microsoft\Microsoft SQL Server\';
    I get two records returned.  These are:-
    Record 1
    Value
    InstalledInstances - Item #1
    Data

    January 30, 2017 at 8:43 am

    #1925612

  • RE: Server Audit

    John Mitchell-245523 - Monday, January 30, 2017 7:02 AM

    Have you tried making the change that you think you need to make?...

    January 30, 2017 at 7:10 am

    #1925590

  • RE: Date dimension showing times

    Thanks Jeff, I'll have a look at that little lot.

    There will be a couple of columns I can't make deterministic due to their nature (i.e. the "Is" flags) but I...

    December 21, 2016 at 2:11 am

    #1919096

  • RE: Date dimension showing times

    Hi Jeff

    Unless the computed columns in the table are defined as "PERSISTED", then this table is as bad or worse than using a view to create the same thing.

    None of...

    December 20, 2016 at 9:35 am

    #1918960

  • RE: DIM tables need to be case sensitive

    Another oddity, on the date dimension it's failing on a date columns that contains (funnily enough) a date.

    It's a computed column in the SQL table but the cube processing...

    December 16, 2016 at 6:41 am

    #1918376

  • RE: DIM tables need to be case sensitive

    Hi Thom

    I'm referring to Cube Dimensions.

    December 16, 2016 at 5:58 am

    #1918369

  • RE: Report not rendering correctly in Chrome

    No problem, thank you.

    October 12, 2016 at 6:14 am

    #1906086

  • RE: Report not rendering correctly in Chrome

    Thanks for the links, I'll go through them in details later.

    We're running Visual Studio 2012 and deploying it onto a SQL 2012 box.

    October 12, 2016 at 6:01 am

    #1906081

  • RE: DBA Support

    Apparently I'm the in-house DBA for 5 servers (out of a total of 88 instances). Biggest database is around 300GB (so far) and growing.

    There isn't an "official" DBA in...

    October 7, 2016 at 1:57 am

    #1905320

  • RE: Replication and sp_rename

    I had to remove replication completely from the publisher side and I haven't had a chance to put it back.

    Apparently, according to the 3rd-party supplier, if their software sees replication...

    September 14, 2016 at 1:36 am

    #1900732

  • RE: Replication and sp_rename

    Hi John

    I didn't have a chance as we had to remove replication last week as the 3rd-party couldn't make their changes. The supplier hasn't supplied the error message and...

    September 12, 2016 at 8:13 am

    #1900325

  • RE: Replication and sp_rename

    Hi John

    It's set up for transaction replication and the command was run on the publisher.

    September 12, 2016 at 7:56 am

    #1900318

  • RE: Replication and sp_rename

    Thanks John

    It should have been (I don't remember specifying not to anywhere).

    I'll double-check the scripts I've got and see if I can find anything obvious.

    ::edit::

    I've just checked the scripts that...

    September 12, 2016 at 5:52 am

    #1900287

  • RE: Stop time for loop not recognising time correctly

    Solved it!!

    I cheated slightly and just used the hour portion of both Now and dtStopTime as my comparitors.

    It seems to be working the morning (the final file hasn't been downloaded...

    August 24, 2016 at 5:42 am

    #1897142

Viewing 15 posts - 301 through 315 (of 471 total)