To check used and free data space

select convert(char(16), db_name(d.dbid))
+ "|Data_Total_MB=" + convert(char(9), ceiling (sum(case when u.segmap != 4 then u.size/1048576.*@@maxpagesize end )))
+ "|Free_MB=" + convert(char(14), (convert(numeric(8,1),
           ((sum(case when u.segmap != 4 then u.size/1048576.*@@maxpagesize end ))) - (sum(case 

Below query can be used to check when was last update stats run on the database.

use DBNAME
go
select SUBSTRING(@@servername,1,20) 'Server_Name',db_name() 'DB_Name', SUBSTRING(object_name(id),1,30) 'table_name',statmoddate from systabstats where id=object_id('tablename') and indid=0

Sample output:

Below query can be used to check logins and associated server roles granted to them.

1select suser_name(suid) as 'login',role_name(srid) as 'role' from master..sysloginroles
2go

Below are the ways to know the list of tables which are marked for replication in Sybase ASE.

1. using sp_setreptable procedure

1use DB
2go
1sp_setreptable
2go

2. using below sql query

select object_name(id) as Name from … Read the rest