Forum Replies Created

Viewing 15 posts - 1 through 15 (of 32 total)

  • RE: Profiler Temp files

    I have thried to open then in note pad but it shows up as mostly garbage. Could be a binary file.

  • RE: Replay Profiler Trace Truncates Procedures

    Turns out it wasn't being truncated, it was pointing to the wrong database id due to quoted identifiers being set off, set them on and all is good. Thanks

    ...

  • RE: Parallelism in SQLserver 7

    Hi, We were using parallelism on all our SQL 7.0 servers until we were live for about a year. I think (and this is only my own opinion) that...

  • RE: Relating views as tables

    Hi, not sure if this will help or really be what you are looking for but have you thought about creating a 'Common' database to house tables that are referenced...

  • RE: I/O error on DBREINDEX

    Hi, This is an odd error, just my thoughts but it sounds like the error is occurring when the reindex job is re-writing the data pages to the data file...

  • RE: MDAC 2.5 SQL 7.0 to SQL 2000 upgrade

    Thanks jpipes. Did you go to MDAC 2.7 when you upgraded your environment?

  • RE: Performing Compltion Action

    What actions do you have selected in the Job step, advanced tab? the ones I mean are the "upon success action" and "upon failure action".

  • RE: Re-indexing and Stats

    Yeah, that is what I thought too. But I have dropped and re created indexes thinking that the auto stats would take care of it. What happened was...

  • RE: Transaction Statistics

    I'm using a SQL 7.0 cluster and profiler does not work properly when attempting to run against the cluster, it causes a fail over. I do monitor the processors...

  • RE: Transaction Statistics

    Thanks.

  • RE: Transaction Statistics

    Thanks, do you know if there is a way that I can log the stats also?

    Thanks

    E...

  • RE: Error 8650 after installing SP4 on 7.0

    When we had it turned on we were on Sp3, It worked somtimes and then other times it didn't, I would guess it sounds like it may have got...

  • RE: Error 8650 after installing SP4 on 7.0

    I can't really answer all of the questions but I may be able to provide some insight. Using the MaxDop1 hint in your query forces SQL Server to use...

  • RE: Pad Index

    Thanks, I understand now.

  • RE: Stored Procedure Modified Date

    Thanks folks, I do require that any proc changes get updated in the header but you know how it goes, some times people are in a hurry and they no...

Viewing 15 posts - 1 through 15 (of 32 total)