Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: Can we Create sql server instance through script?

    Still not clear that, is there any way to create it using scipt?

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    July 23, 2013 at 2:48 am

    #1634812

  • RE: Database mail sending fails with SP_Send_DBmail.

    Hi,

    The issue is solved.There was a authentication problem for ServerA/SQLAgent.

    I have mapped both the user; i.e user from ServerA and user from ServerB using

    following system SP. In my addlinkedserver @useself...

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    June 13, 2013 at 10:50 pm

    #1623952

  • RE: Database mail sending fails with SP_Send_DBmail.

    Hi JM,

    Thanks. I also Asume this is the issue of SQL server Agent Account. Error indicates the server/sqlAgent login failed. I need to check for the sql Agent Account on...

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    June 5, 2013 at 10:33 pm

    #1621587

  • RE: Database mail sending fails with SP_Send_DBmail.

    Hi Ness,

    Where can I check the account under which SQL Agent is running? How to grant permissions to the Agent Account if the permissions are not granted?

    Thanks.

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    June 5, 2013 at 12:35 am

    #1621191

  • RE: Which is Best to use, #Temp Table or @Table Variable?

    SQLCrazyCertified (7/20/2012)

    Jigneshal (7/20/2012)

    I usually use #table in y stored proc. Which is the best to use in SP, #table or @Table variable?

    Thanks

    If you are using this for small set of...

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    July 20, 2012 at 9:54 pm

    #1515816

  • RE: Where to View Job History??

    anthony.green (7/4/2012)

    The job history table is a cumulative table of all history from all jobs. By default it only stores around 1000 rows in the table, so if you...

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    July 4, 2012 at 5:18 am

    #1508713

  • RE: Database Design for Hospital Management

    MysteryJimbo (7/2/2012)

    Jigneshal (7/2/2012)

    Its an Uni project..

    Good guess on my part since its extremely unlikely that it'd be a professional question like that.

    Assuming you already know the basics of database design...

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    July 2, 2012 at 2:38 am

    #1507648

  • RE: Database Design for Hospital Management

    MysteryJimbo (7/2/2012)

    Jigneshal (7/2/2012)

    Hi,

    I want to create a database for hospital management system.

    but i dont have much idea to design db. Can anyone help creating db for hospital management.

    It will be...

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    July 2, 2012 at 2:20 am

    #1507640

  • RE: Database Design for Hospital Management

    Its an Uni project..

    Regards,
    Jigneshal
    " Stretch Your Limit Little Beyond Your Limit....! "
    😎

    July 2, 2012 at 2:16 am

    #1507638

Viewing 9 posts - 1 through 9 (of 9 total)