Forum Replies Created

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

  • RE: Server Audit

    I've just tried the following (with outputs):-
    xp_cmdshell 'reg query HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names'
    xp_cmdshell is not recognised as an internal or external command, operable program or batch file

  • 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...

  • 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
  • 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?...

  • 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...

  • 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...

  • 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...

  • RE: DIM tables need to be case sensitive

    Hi Thom

    I'm referring to Cube Dimensions.

  • RE: Report not rendering correctly in Chrome

    No problem, thank you.

  • 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.

  • 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...

  • 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...

  • 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...

  • RE: Replication and sp_rename

    Hi John

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

  • 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...

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