Forum Replies Created

Viewing 15 posts - 76 through 90 (of 233 total)

  • RE: SQL Agent not updating msdb..sysjobhistory

    more info

    I turned on some trace messages to appear in this log, and got the following after executing “test”:

     

  • RE: Urgent Help on Accidental Row Deletion

    My first reaction when I saw this thread still active was "geez!  he's been at this since last week... he should have just bought the Lumigent Log Explorer tool and been...

  • RE: Duplicate Records

    The answer is on this board, not sure which forum, probably the t-sql one... search for "removing duplicate records".  We had an "unusual" problem recently where the PK had a...

  • RE: Executing SSIS packages in order

    are you going to ask a question?

  • RE: High CPU usage after a backup

    verification perhaps?

  • RE: WMI error trying to install SQL2005

    I have not done an install since March of this year... and do not have one here to play with; but this error is familar.  I would recommend that you...

  • RE: Notification Services

    uhhhh, I thought this forum was FOR the site owners to respond

    Notification gets all sorts of admin entires... and things get answered there,...

  • RE: Replication or Log Shipping

    With SQL Server you must have a primary key.  A unique index does not substtitute, basically because nulls are allowed in a unique index.  Most DBs (SQL included) automatically build...

  • RE: How to replication a tabel with more than 255 field ?

    I do not know of one.  You also have a limiation of total width of the rows... and replication supposedly adds a column (with a particular name that I do...

  • RE: XP_CMDSHELL to delete external files

    yeah, that sounds so simple... it was tried about two weeks ago.  thanks for the idea; but it was not the solution.  Our IT people have been working on other...

  • RE: Servername on cluster?

    Thanks again for your response.  I do appreciate the chance to talk about this with someone.  The software being used is from EMC and it's an active/passive arrangment.  The passive...

  • RE: query governor cost limit option

    Much easier to implement a rule that developers DO NOT USE THE PRODUCTION DB for development.  They should use a development DB to do development.  You should crack down on...

  • RE: Servername on cluster?

    More info... technically we do not have a cluster, we are doing "volumn replication"...  Restarting the service cleared the problem enough to allow jobs to execute.  There is still no...

  • RE: Removing Server Registration

    right clicking and "remove resistration" is the way they are deleted.  Anything other than that is a mystery.

  • RE: Servername on cluster?

    Hello Colin,

    Thanks for responding.  I read your posts regularly and appreciate the feedback.  This cluster is created with third party software.  We are also running SS Standard Edition (and I...

Viewing 15 posts - 76 through 90 (of 233 total)