Forum Replies Created

Viewing 15 posts - 6,271 through 6,285 (of 9,707 total)

  • RE: Importing Data from access Database backup

    I'm asking because your reply confused me a bit. Did my response actually help you out / answer your question? Or do still need this answered?

    March 17, 2011 at 5:25 am

    #1299869

  • RE: LINKED Server does not return all records.

    kashif.nadeem (3/17/2011)

    2) Production database or dev database?

    Production databases both LINKED SERVER DB AND THE ONE WHERE I HAVE CREATED LINKED SERVER.

    Okay. I can understand the Linked Server DB being a...

    March 17, 2011 at 5:23 am

    #1299868

  • RE: Today's Random Word!

    Donut

    March 17, 2011 at 4:57 am

    #1299864

  • RE: How to monitor multiple sql servers by a script?

    Grant Fritchey (3/16/2011)

    Brandie Tarvin (3/16/2011)

    There are a lot third party tools for sale that will monitor multiple servers, also. I believe both Imceda and Red Gate have software, along with...

    March 17, 2011 at 4:56 am

    #1299863

  • RE: SQL Mail

    GSquared (3/16/2011)

    Brandie Tarvin (3/16/2011)

    I'm not sure what you mean by "and the end". Could you clarify?

    Notifications on jobs are not related to job steps and not configured by step. They...

    March 17, 2011 at 4:55 am

    #1299862

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/16/2011)

    Craig Farrell (3/16/2011)

    GilaMonster (3/16/2011)

    I object, I'm a model of good behaviour

    well, compared to others on that list anyway...

    Isn't that like saying you're a 'nice' barbarian because you only...

    March 17, 2011 at 4:51 am

    #1299858

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/16/2011)

    Buck has clothing problems.

    TMI! TMI!

    Someone get me the brain bleach!

    :sick:

    March 16, 2011 at 12:36 pm

    #1299582

  • RE: SQL Mail

    I'm not sure what you mean by "and the end". Could you clarify?

    Notifications on jobs are not related to job steps and not configured by step. They are a separate...

    March 16, 2011 at 12:35 pm

    #1299581

  • RE: How to script a remove 'IDENTITY(1,1)'

    edvard 19773 (3/15/2011)

    I have app. 150 tables in the DB, which i control and uses.

    The customer has two tables, which they use as their link to my db.

    And they claim...

    March 16, 2011 at 12:33 pm

    #1299579

  • RE: Identity column gernerating non unique value

    Just a thought. Identity_Insert could be set ON for that table and data coming from elsewhere is forcing duplicate values in.

    Or someone might have reseeded the table.

    March 16, 2011 at 12:29 pm

    #1299576

  • RE: Job appears to run successfully, but doesn't.

    I agree with Steve. It sounds like the code is missing something or deliberately excluding something.

    Do a search in the catalog views for a proc with that name, then...

    March 16, 2011 at 12:26 pm

    #1299574

  • RE: SQL Server Conditional Join

    You can also put a CASE statement in your ON clause, forcing the code to make up a number or default to a value that will keep the records that...

    March 16, 2011 at 12:24 pm

    #1299573

  • RE: Cpu usage is high

    One problem my workplace has with alerts and notifications. Email can be slow across the network (so can pages), which means we get notified of an event 2-10 minutes after...

    March 16, 2011 at 12:20 pm

    #1299569

  • RE: SQL Mail

    Why do you have notification set up in the plan? Why not set it up on the job as a "Notify Operator when job is completed?"

    You need an operator, but...

    March 16, 2011 at 12:17 pm

    #1299568

  • RE: backup taking long time

    Oracle_91 (3/16/2011)

    This is first time taking the backup. Basically it is a sharepoint search database and now we are getting log fulll error and so we want take a full...

    March 16, 2011 at 12:10 pm

    #1299562

Viewing 15 posts - 6,271 through 6,285 (of 9,707 total)