Forum Replies Created

Viewing 15 posts - 166 through 180 (of 193 total)

  • RE: SQL agent configured to call a SP

    wolfkillj (6/10/2013)


    I would start by checking the values in your @EMAILID and @BCC variables at run time. I would consider adding a line of code that writes those values to...

  • RE: Creatin of role & assign users

    Assuming these are Windows authenticated logins rather than SQL autenticated wouldn't it be better to add them all to a security group in AD and just add the security group...

  • RE: DB permissions on basis of application

    I would suggest you set the user's permissions based upon the access they require when connecting via SSMS.

    When they connect via some other application you can have that application connect...

  • RE: Stored Procedures Execute Permissions

    opc.three (4/22/2013)


    crmitchell (4/22/2013)


    Eric M Russell (4/18/2013)


    Dree Vasquez (4/18/2013)


    Hi All

    If you're a member of sysadmin, then you can grant or deny whatever privillages you know are really required. You can even...

  • RE: Stored Procedures Execute Permissions

    Eric M Russell (4/18/2013)


    Dree Vasquez (4/18/2013)


    Hi All

    Thanks so much for all the suggestions. I really appreciate it.

    I asked the Global developer and they said their procedures cannot be changed. And...

  • RE: Strange datetime conversion issue

    Does using

    TOP 100 PERCENT

    work?

  • RE: Strange datetime conversion issue

    Well without knowing anything about the query, data or even the error message anything you get will be very general.

    You will need to break down the query and understand in...

  • RE: ORDER BY = Bubble Sort ? Quick Sort ? Insertion Sort ?

    Matt Miller (#4) (3/8/2013)


    Besides - all of those sorts methods you mentioned presume a flat list structure. The internals for how tables are structured are anything but flat.

    In short...

  • RE: Basic Date Function

    sipas (2/15/2013)


    crmitchell (2/15/2013)


    L' Eomot Inversé (2/15/2013)


    What worries me there is that - even with the very appropriate emoticon - the person to whom you replied may be insufficiently awake to...

  • RE: Basic Date Function

    L' Eomot Inversé (2/15/2013)


    sipas (2/15/2013)


    crmitchell (2/15/2013)


    L' Eomot Inversé (2/14/2013)


    Koen Verbeeck (2/13/2013)


    This question could've been better if the question asker realized there are more than one countries in the world.

    Actually, all...

  • RE: Basic Date Function

    L' Eomot Inversé (2/14/2013)


    Koen Verbeeck (2/13/2013)


    This question could've been better if the question asker realized there are more than one countries in the world.

    Actually, all we need to know is...

  • RE: Basic Date Function

    Toreador (2/13/2013)


    Dineshbabu (2/13/2013)


    I got it correct, Not because i'm staying in India. As Hugo and others said, In the given options SYSUTCDATETIME ( ) is the only option which will...

  • RE: Basic Date Function

    Because the question requires the user to make assuptions about how the end user's systems are configured which are defined in the question.

    In this case we don't know and have...

  • RE: Basic Date Function

    If my computer was displaying that as the system date and time I'd be complaining that GP had messed up the language /country settings. Wrong time and a non existant...

  • RE: Adding comma separator to INT datatype

    johnnycash (1/30/2013)


    Hello to all gurus here!

    Please excuse the dumbness of this question, but if I have an INT value of 999999 and want to display it formatted with the thousand...

Viewing 15 posts - 166 through 180 (of 193 total)