Forum Replies Created

Viewing 15 posts - 4,861 through 4,875 (of 9,707 total)

  • RE: Normalize a SQL backend with Access 2007 front end

    kwoznica (1/12/2012)

    So what is the best way to enforce referential integrity? Should I add a constraint to the CaseData table?

    You should be able to create a regular Foreign Key Constraint...

    January 13, 2012 at 6:04 am

    #1433173

  • RE: Transaction Log

    Let's go back to your original question.

    What happened? Why do you need to read data from your log file?

    And do you just want to read it or are you...

    January 13, 2012 at 5:59 am

    #1433172

  • RE: I want update records from table1 to table 2 on Weekly basis

    You can create a SQL Server job with a Transact SQL job step that runs your update code on a weekly schedule.

    If you want more information, please post more details,...

    January 13, 2012 at 5:53 am

    #1433169

  • RE: search query as per selected checkboxes

    I refer you back to my last response.

    Use IN instead of = on the stored procedure and concatenate the values together. You can expand my single parameter query to...

    January 13, 2012 at 5:51 am

    #1433167

  • RE: varaible in ssis

    sql Anand (1/13/2012)

    i am creating project in ssis..by using variable (ie,:@dbconn) can i change environment -provider for that project(like sql server to oracle)

    is there any way to do this in...

    January 13, 2012 at 5:14 am

    #1433153

  • RE: search query as per selected checkboxes

    This can be translated down to a T-SQL "IN" clause. You can have 1 or multiple values in an IN clause (as opposed to an equals "=" query).

    The key would...

    January 13, 2012 at 5:05 am

    #1433151

  • RE: SQL Instance

    So far as I know, and I may be working off of old knowledge, instances cannot be renamed. They have to be installed brand new with a new name.

    January 13, 2012 at 4:58 am

    #1433146

  • RE: Access to SQL Server

    Knowledge Hunter (1/13/2012)

    My understanding is that I will ahve to get access for the SQL Server from someone who already has access to the SQL Server.

    Yes, you will. Is there...

    January 13, 2012 at 4:57 am

    #1433145

  • RE: SQL Agent Job succeeds even though step should fail

    Evil Kraig F (1/12/2012)

    This is more a linked server than a job issue. The proc itself won't error, so the job is clueless there was a problem.

    When you put...

    January 13, 2012 at 4:49 am

    #1433140

  • RE: SQL Agent Job succeeds even though step should fail

    Evil Kraig F (1/12/2012)

    Successful completion of a failure, but that's primarily because the proc doesn't actually fail, which is just... wierd. Try/Catch is also useless, as it's not an...

    January 13, 2012 at 4:45 am

    #1433136

  • RE: 2012 RC0 Failure

    Yeah, when all else fails, talk to the vendor. Maybe they can shed some light into the issues.

    January 13, 2012 at 4:43 am

    #1433135

  • RE: Access to SQL Server

    SQLKnowItAll (1/12/2012)

    Brandie Tarvin (1/12/2012)

    SQLKnowItAll (1/12/2012)

    I'm just saying that if this is a new install and you are the DBA you may HAVE to use sa at least once to set...

    January 12, 2012 at 10:02 am

    #1432729

  • RE: Access to SQL Server

    SQLKnowItAll (1/12/2012)

    I'm just saying that if this is a new install and you are the DBA you may HAVE to use sa at least once to set up domain logins...

    January 12, 2012 at 9:39 am

    #1432692

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (1/12/2012)

    I don't have the time I'd like to answer more questions, so I tend to answer in batches, but I learn every time I do.

    That's me. Too...

    January 12, 2012 at 9:36 am

    #1432689

  • RE: Access to SQL Server

    SQLKnowItAll (1/12/2012)

    Brandie Tarvin (1/12/2012)

    SQLKnowItAll (1/12/2012)

    Your domain account needs to be added to SQL Server as a user. You should log in as sa or have someone do that and add...

    January 12, 2012 at 9:30 am

    #1432678

Viewing 15 posts - 4,861 through 4,875 (of 9,707 total)