Forum Replies Created

Viewing 14 posts - 76 through 90 (of 90 total)

  • RE: Event ID 825- error reading pageID

    Warning: The average disk queue length is 6. The disk may be at its maximum transfer capacity due to throughput and disk seeks

    I assume this is related to the...

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Event ID 825- error reading pageID

    I set up a data collector on the Reliability & Performance Monitor last week. I didn't know what I was doing, but I do get results indicating low memory....

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Event ID 825- error reading pageID

    I ran DBCC CheckDB(SFIData) WITH No_INFOMSGS, ALL_ERRORMSGS

    and got 'Command(s) Completed Successfully'. Don't that beat all?

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Event ID 825- error reading pageID

    On Fri 1/14 we got the Event 824 message. We renamed the most current full backup so it wouldn't get copied over and ran a new full backup. ...

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: [364] the messenger service has not been started

    We're running SQl 2008 R2 on a virtual server (WIN server 2008) and I dont' see the "Messenger" service under services. If someone found it using this scenario I...

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Reuse of Identity column values

    Outstanding! I'll research the trace and play with it. I just started this job 4 months ago and found there is a lot of stuff broken. ...

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Reuse of Identity column values

    I'm not familiar with setting up a trace file. Will it reveal records (or gaps) which have been deleted via SSMS (or Enterprise Mgr)?

    I know I could have our...

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Reuse of Identity column values

    Your second sentence just sunk in with me. I think I had a "duh-huh" moment. Talk about over-complicating things. You're right. This is probably the simplest,...

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Reuse of Identity column values

    Yes, my first attempt was on a temp table of sequential numbers comparing to the live table.

    The only reason it matters is because I'm trying find out if a...

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Reuse of Identity column values

    Thank You very much! My code is obviously errant and I'll have to fix it.

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: Check for table EXISTence in SQL '08

    I appreciate all the responses. I used WayneS's suggestion and added 'dbo.' prefix to any mention of a table (or procedure) and that did the trick. I will...

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: CE 2.0 RDA on one server talking to SQL 2008 on another

    This has been resolved. We changed the actual server name to it's IP address and added the relevant login info.

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: CE 2.0 RDA on one server talking to SQL 2008 on another

    I installed CE 2.0 on the new server, but it tells me IIS is not started, but it is. Any thoughts?

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • RE: parse a value from a field with commas

    Jack, Thanx for the reply. I"ll try to work with this, but I won't know what the values of the variables are. I'm reading them from a table.

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

Viewing 14 posts - 76 through 90 (of 90 total)