Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 2,647 total)

  • RE: Comparing Tables between MS Access and SQL Server

    I would create a linked server to Access: http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/589ca193-3541-4c5e-965c-4c515d6b476b

    Then compare tables through SQL Server.

    Jared
    CE - Microsoft

    January 16, 2012 at 9:03 am

    #1434122

  • RE: find diference between two fields

    HINT: Look at the data types for the columns you are doing the difference of. Are you sure that the difference can be negative based on those data types?...

    Jared
    CE - Microsoft

    January 16, 2012 at 8:53 am

    #1434117

  • RE: convert column with numbers to a specific date format

    mic.con87 (1/16/2012)

    I think I have found the problem. There are 64 dates that have a problem. These can be defaulted to null. The leading zero disappears when you create the...

    Jared
    CE - Microsoft

    January 16, 2012 at 8:32 am

    #1434101

  • RE: convert column with numbers to a specific date format

    I think you need to fix your sample data as this values are certainly not integers, which means any solution we give is going to be incorrect. What is the...

    Jared
    CE - Microsoft

    January 16, 2012 at 8:23 am

    #1434099

  • RE: Timestamp column

    You could cast the column into another data type if you needed to preserve it, but I would question the use. If there is no need for the column...

    Jared
    CE - Microsoft

    January 12, 2012 at 12:43 pm

    #1432845

  • RE: Timestamp column

    GilaMonster (1/12/2012)

    SQLKnowItAll (1/12/2012)

    In SQL Server, a timestamp IS a datetime data type. So, the column you are importing into for that must be datetime data type. Does that...

    Jared
    CE - Microsoft

    January 12, 2012 at 11:36 am

    #1432816

  • RE: Timestamp column

    svakka (1/12/2012)

    I'm trying to export data using Import/Export Wizard. I'm getting error when importing into timestamp column. What is the work around?

    Just read this again... Are you exporting or importing...

    Jared
    CE - Microsoft

    January 12, 2012 at 11:24 am

    #1432808

  • RE: Timestamp column

    svakka (1/12/2012)

    Thank you all .My source column has timestamp data type, should I create rowversion, date time data type to hold the same value as in source

    I don't think You...

    Jared
    CE - Microsoft

    January 12, 2012 at 11:19 am

    #1432804

  • RE: Access to SQL Server

    In this OPs case, since we know nothing from them yet really, I would venture to say that the errors occurred because the service was already started. OP cannot...

    Jared
    CE - Microsoft

    January 12, 2012 at 10:26 am

    #1432756

  • RE: Access to SQL Server

    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 up...

    Jared
    CE - Microsoft

    January 12, 2012 at 9:44 am

    #1432703

  • RE: Access to SQL Server

    Brandie Tarvin (1/12/2012)

    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...

    Jared
    CE - Microsoft

    January 12, 2012 at 9:35 am

    #1432686

  • RE: Access to SQL Server

    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 you....

    Jared
    CE - Microsoft

    January 12, 2012 at 7:58 am

    #1432532

  • RE: Access to SQL Server

    Brandie Tarvin (1/12/2012)

    Suresh B. (1/12/2012)

    Knowledge Hunter (1/12/2012)

    Hi All,

    We have a SQL Server 2008 R2 hosted on a server having OS Windows Server 2008 R2.

    I am added to Windows, Admin group...

    Jared
    CE - Microsoft

    January 12, 2012 at 6:38 am

    #1432437

  • RE: Sql agent job step - tsql command

    DeanORenO (1/11/2012)

    I didn't explain what the whole job is about and I don't need to since the raiserror solved my problem, if the query returns rows then the job is...

    Jared
    CE - Microsoft

    January 11, 2012 at 3:44 pm

    #1432184

  • RE: Sql agent job step - tsql command

    DeanORenO (1/11/2012)

    The job failure triggers an email sent to an operator which is done

    I don't see the reason for this. You want your job to complete, but send an email....

    Jared
    CE - Microsoft

    January 11, 2012 at 1:59 pm

    #1432115

Viewing 15 posts - 1,966 through 1,980 (of 2,647 total)