Forum Replies Created

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

  • RE: Inserting DBCC Results into a table

    kevaburg - Tuesday, January 31, 2017 4:54 AM

    I am considering a solution using xp_readerrorlog to extract what I Need...

    January 31, 2017 at 5:00 am

    #1925816

  • RE: Alter table permission

    I imagine so, yes, but why don't you try it, just to make sure?

    John

    January 31, 2017 at 4:50 am

    #1925813

  • RE: Inserting DBCC Results into a table

    Phil Parkin - Tuesday, January 31, 2017 4:36 AM

    As suggested here, you may be able to grab this info...

    January 31, 2017 at 4:45 am

    #1925811

  • RE: Need help with bcp

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

    John Mitchell-245523 - Tuesday, January 31, 2017 4:17 AM

    January 31, 2017 at 4:29 am

    #1925807

  • 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

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