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

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

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

  • RE: help with SQL Query

    This should help.

    John

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

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

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

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

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