Forum Replies Created

Viewing 15 posts - 16 through 30 (of 782 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...

  • RE: User group in Delhi,NCR INDIA

    hey guys,

    Do let me know also.

    RegarDS,

    Skybvi

  • 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

  • RE: need sample resume for MS SQL DBA

    GilaMonster (11/20/2009)


    Why do you want a sample resume?

    🙂

    😀

    😛

    😎

    :hehe:

  • 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

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

  • 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

  • RE: Add user with Admin Access

    What all privileges he they should get /

    What all data they can read/edit?

    Regards,

    Skybvi

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

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

  • 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)

    ...

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

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

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

  • 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,

    ...

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