Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 7,187 total)

  • RE: Need help with bcp

    NineIron - Tuesday, January 31, 2017 4:12 AM

    Jeff Moden - Monday, January 30, 2017 1:03 PM

    January 31, 2017 at 4:17 am

    #1925802

  • RE: SQL Server Setup Failure

    jayoub - Monday, January 30, 2017 9:33 AM

    We are using SQL Server 2014 and I am getting the error
    "SQL Server Setup...

    January 30, 2017 at 9:44 am

    #1925637

  • RE: Server Audit

    Looks like 2000 has a value called InstalledInstances in the Microsoft SQL Server key, then.  You'll need to interrogate that.  Not sure what happens if you have more...

    January 30, 2017 at 9:41 am

    #1925635

  • RE: Server Audit

    richardmgreen1 - Monday, January 30, 2017 8:51 AM

    It certainly looks that way.
    I've got domain admin access and I can run this script...

    January 30, 2017 at 9:06 am

    #1925623

  • RE: help with SQL Query

    This should help.

    John

    January 30, 2017 at 8:50 am

    #1925615

  • RE: Server Audit

    richardmgreen1 - Monday, January 30, 2017 8:43 AM

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

    January 30, 2017 at 8:48 am

    #1925614

  • RE: Cost threshold for parallelism

    george.p - Monday, January 30, 2017 7:29 AM

    What effect would I see on a system not under pressure if I changed...

    January 30, 2017 at 7:35 am

    #1925597

  • RE: Server Audit

    You mean you changed the path in the script?  Strange that you still get an error if the registry path is correct.  Try stripping off one key at...

    January 30, 2017 at 7:22 am

    #1925593

  • RE: Server Audit

    Have you tried making the change that you think you need to make?  What happens if you run the code directly against a SQL Server 2000 server - you...

    January 30, 2017 at 7:02 am

    #1925588

  • RE: TempDB Log File Growing Exponentially But Remains 99% Empty?

    Log file auto growths are recorded in the default trace, so if this didn't happen too long ago, you can see when the growths occurred.  That might...

    January 30, 2017 at 5:01 am

    #1925573

  • RE: Need help with bcp

    I notice that your code has an unclosed double quote, a comma that looks as if it doesn't belong, and a repeated "-t" (albeit in upper case).  Could that be...

    January 30, 2017 at 4:54 am

    #1925571

  • RE: Execution plan estimates Join hint spilling.

    Please will you post the query and execution plan(s)?  How about eliminating the temp tables and working directly from the source tables?  Not always possible and/or desirable, but worth...

    January 27, 2017 at 9:26 am

    #1925384

  • RE: SSRS 2016 Error

    PJ_SQL - Friday, January 27, 2017 8:54 AM

    Yes , I can.
    I don't get the error all the time, it is sporadic.

    Are...

    January 27, 2017 at 9:00 am

    #1925378

  • RE: Adding datafiles to Tempdb

    Without knowing anything about your environment, I'd say it would be more likely to have a positive effect than negative.  But don't go adding too many!  Have a read...

    January 27, 2017 at 8:53 am

    #1925371

  • RE: SSRS 2016 Error

    PJ_SQL - Friday, January 27, 2017 8:37 AM

    When I try to access SSRS URL externally or from any other server it gives...

    January 27, 2017 at 8:49 am

    #1925368

Viewing 15 posts - 1,906 through 1,920 (of 7,187 total)