Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2004
    Posts
    4

    Question Unanswered: showing options that can be set

    How can I see the current settings of options that can be "set" such as textsize or clientname?

  2. #2
    Join Date
    Jun 2002
    Location
    Argentina
    Posts
    78

    Exclamation

    I dont understand exactly your questions. May be this help:

    sp_configure
    go

    or may be:

    select user_name(), suser_name(), db_name()
    go

    Bye bye

    Sebastian

  3. #3
    Join Date
    Feb 2004
    Posts
    28
    Quote Originally Posted by DogMan
    How can I see the current settings of options that can be "set" such as textsize or clientname?
    I do not think there is any command/proc in ASE that can show all the available "set" option. Your only hope is Sybase documentation.

  4. #4
    Join Date
    Jul 2004
    Posts
    4
    I thank both of you for your responses.

    Although sp_configure shows lots of server settings, it does not seem to show the session-dependent options.

    I was hopeful that user_name() or suser_name() might helpme with clientname but it did not.

    set clientname DogMan
    select user_name(), suser_name()
    go

    returned "dbo sa", not DogMan.

    I spent many hours searching through the Sybase documentation without success. Maybe it's time to give Sybase a call.

  5. #5
    Join Date
    Jun 2002
    Location
    Argentina
    Posts
    78

    Thumbs up

    You need this select to see the cliente name:

    set clientname DogMan
    go

    select clientname
    from master..sysprocesses
    where spid = @@spid
    go

    Or if you want to see all the information of all the processes:

    select *
    from master..sysprocesses
    go

    for your process:

    select *
    from master..sysprocesses
    where spid = @@spid
    go

    Bye bye

    Sebastian Isaac Velasco

  6. #6
    Join Date
    Jul 2004
    Posts
    4

    Thumbs up

    Great! That's exactly what I needed. Many thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •