Forum Replies Created

Viewing 15 posts - 16 through 30 (of 783 total)

  • RE: Answers to these questions

    anthony.green (5/30/2012)


    All three of the answers to them can be found on google.

    Copy your questions, place them into google and you will get the answer. I have...

    Regards
    Sushant Kumar

  • RE: User group in Delhi,NCR INDIA

    hey guys,

    Do let me know also.

    RegarDS,

    Skybvi

    Regards
    Sushant Kumar

  • RE: Answers to these questions

    GilaMonster (5/25/2012)


    Tried google? I know the answers to at least 2 of those can be easily found.

    i need to know 1st and 3rd answer

    Regards,

    Skybvi

    Regards
    Sushant Kumar

  • RE: need sample resume for MS SQL DBA

    GilaMonster (11/20/2009)


    Why do you want a sample resume?

    🙂

    😀

    😛

    😎

    :hehe:

    Regards
    Sushant Kumar

  • RE: Seeking a SQL Server job

    Hi,

    I am sql server dba/dev with 3 yrs experience.

    I am looking for a job.

    Anybody knows how to contact or apply to get a job.

    Regards,

    Skybvi

    Regards
    Sushant Kumar

  • RE: London Job Market

    pef (2/27/2012)


    Hi all.

    After working in Seattle USA for the last 15 years, due to family commitments, I need to move back to the UK and would like to find contracting...

    Regards
    Sushant Kumar

  • RE: Add user with Admin Access

    create a sql login ( thru security)

    in user mapping, select the database, whcih u want him to access everythign and give him

    db_owner permissions.

    Regards,

    Skybvi

    Regards
    Sushant Kumar

  • RE: Add user with Admin Access

    What all privileges he they should get /

    What all data they can read/edit?

    Regards,

    Skybvi

    Regards
    Sushant Kumar

  • RE: Maintenance plan created but lost after one week

    Divine Flame (4/2/2012)


    halifaxdal (4/2/2012)


    Can't believe this happened to me:

    On Mar 26, I can still see the maintenance plan, I even created a screenshot for my document. The plan is scheduled...

    Regards
    Sushant Kumar

  • RE: Get a latest record from a table with Identity

    ravinderm2003 (3/29/2012)


    You are right Jason, the TOP clause would not give me the right results.

    OK, maybe iam wrong, but

    you should always provide DDL and some sample data ...

    So that...

    Regards
    Sushant Kumar

  • RE: Get a latest record from a table with Identity

    ravinderm2003 (3/28/2012)


    Hi, I found the solution myself. and here it is. AccountId has the Identity on it.

    SELECT AccountID = MAX(AccountID)

    ...

    Regards
    Sushant Kumar

  • RE: How to run a file on a server thru SSIS

    opc.three (3/28/2012)


    SKYBVI (3/28/2012)


    opc.three (3/28/2012)


    Oh no, it does not work that way. The executable will always run in the context of the operating from which you call it, not on which...

    Regards
    Sushant Kumar

  • RE: How to run a file on a server thru SSIS

    HI,

    When I running from SSMS, query analzer

    :-

    EXEC master.dbo.xp_cmdshell 'C:\ePLUM\bin\ImportAll.bat';

    GO

    Then I am getting 3 rows affected

    'Proxy.exe' is not recognized as an internal or external command,

    operable program or...

    Regards
    Sushant Kumar

  • RE: How to run a file on a server thru SSIS

    opc.three (3/28/2012)


    Oh no, it does not work that way. The executable will always run in the context of the operating from which you call it, not on which you call...

    Regards
    Sushant Kumar

  • RE: How to run a file on a server thru SSIS

    opc.three (3/27/2012)


    In the Process Tab:

    1. Instead of setting Executable to C:\ePLUM\bin\ImportAll.bat, set it to fully qualified path to cmd.exe (e.g. C:\WINDOWS\system32\cmd.exe on my workstation).

    2. Set Arguments to /C "C:\ePLUM\bin\ImportAll.bat"

    Hi,

    ...

    Regards
    Sushant Kumar

Viewing 15 posts - 16 through 30 (of 783 total)