Sybase information

To see the database sever version;

1>select @@version

2>go

To see the current user

1>sp_displaylogin

2>go

To check role of current user

1> select show_role()

2> go

To get information on objects,user,group and roles

1>sp_helprotect

2>go

To get information on all active roles

1>sp_activeroles

2>go

To get information on all roles granted to another role or user.

1>sp_displayroles

2> go

To get the information about all the database running on the instance

1>sp_helpdb

2>go

To get detailed information about a particular database

1>sp_helpdb <database_name>

2>go

To get the information about all the devices

1>sp_helpdevice

2>go

To get detailed information about a particular device

1>sp_helpdevice <device_name>

2>go

To get detailed information about an object

1>sp_help <object_name>

2>go

To get information about various server configured with the current dataserver instance

1>sp_helpserver

2>go

To get all the Initialization Parameters.

To Check the current configuration values the server uses and dump to a file

1>sp_configure "configuration file", 0, "write", "server.conf"

2>go