Forum Replies Created

Viewing 15 posts - 46 through 60 (of 83 total)

  • RE: How do I force a job step to wait???

    There are separte steps. It looks as though the alter database command to defrag the index is complete, but is still running in the background.

    The job that...

    August 28, 2008 at 8:52 am

    #864473

  • RE: question on blocking...

    SQL ORACLE (8/19/2008)

    What version and SP do you use? In SQL 2000/SP4, we can see self-blocks quite ofen. It is called self-latch. It is fixed with new hotfixes.

    We have SQL...

    August 19, 2008 at 11:45 am

    #860189

  • RE: failed logins ...

    Jack Corbett (8/12/2008)

    I don't know how to get IP addresses from SQL Server, but the AUDIT LOGIN, AUDIT LOGOUT, and AUDIT LOGIN FAILED events in SQL Trace all include the...

    August 12, 2008 at 2:03 pm

    #857024

  • RE: Perfmon returns null values...

    colin Leversuch-Roberts (7/29/2008)

    I'm not sure why you'd want to do this through perfmon, the dmvs are much better for this sort of thing.

    Colin, thanks for your response. So, would...

    July 29, 2008 at 9:28 am

    #849895

  • RE: perfmon returns null values

    SQL ORACLE (7/26/2008)

    Did you check permissions?

    I checked to ensure that the user for the Performance Logs and Alerts is a member of Performance Log Users.

    Are there other permissions I should...

    July 28, 2008 at 7:50 am

    #849194

  • RE: sp_createstatistics

    Thanks Carl! 🙂

    July 25, 2008 at 1:29 pm

    #848678

  • RE: Auditing

    I'm attaching code for a server side trace. It will grab any updates to the sysjobs table and anyone who runs sp_update_job (which is executed when you enable/disable a...

    July 22, 2008 at 5:03 pm

    #846745

  • RE: Developers kill a process...

    I think Processadmin might be exactly that I am looking for! What a handy built in server role...I guess I just forgot about it. 🙂

    Thanks!

    July 8, 2008 at 11:23 am

    #839672

  • RE: Veritas cluster failover ...

    andrewkane17 (5/29/2008)

    Give it a reboot, can't hurt.

    Thanks Andrew. We scheduled a reboot for tomorrow morning. I'm guessing that will do the trick. I will be sure to...

    May 29, 2008 at 3:25 pm

    #822024

  • RE: Veritas cluster failover ...

    andrewkane17 (5/29/2008)

    Was the lock pages in memory set on both nodes? I have set this up on many VERITAS clusters and have followed http://www.sqlservercentral.com/articles/Administering/aweadventures/960/ to do the steps,...

    May 29, 2008 at 3:06 pm

    #822019

  • RE: Veritas cluster failover ...

    andrewkane17 (5/29/2008)

    Where are the system databases on this cluster, are they on a shared drive that both sets of SQL services are set to use, or are they residing locally....

    May 29, 2008 at 2:55 pm

    #822017

  • RE: Called Microsoft

    You can check to see if awe is really enabled by executing sp_configure and looking at the "awe enabled" row. Look at both the config_value and run_value. What...

    May 29, 2008 at 8:10 am

    #821768

  • RE: AWE Memory Options

    My issue is that we have enabled AWE memory countless times and the settings have not stuck.

    The account running the sql server service (MSSQLSERVER) must the lock pages in memory...

    May 14, 2008 at 11:28 am

    #815438

  • RE: the infamous 1.7GB issue...

    jordonpilling (5/13/2008)

    hello there, its a 32bit system, with 4GB installed, windows has detected the full 4 GB in system information etc.

    sp_configure returns

    minimum: 0

    maximum: 1

    config_value: 1

    run_value: 0

    The run_value of 0...

    May 13, 2008 at 11:24 am

    #814689

  • RE: the infamous 1.7GB issue...

    Jordan,

    Are you running 32-bit or 64-bit?

    You mentioned that the server recognizes 4GB of RAM -- What does it actually have? Does it really have more than 4GB of RAM...

    May 13, 2008 at 10:53 am

    #814670

Viewing 15 posts - 46 through 60 (of 83 total)