Reputation
373
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 11
Impact
~18k people reached

Jan
30
comment Is there a way to call sp_spaceused in a WHILE loop?
You can just grab the pertinent parts of sp_spaceused, and include the logic in your batch job.
Jan
24
comment Can I log which stored procedure issued a delete statement?
In our implementation we keep track of this with a column that shows the source of the insert/change/delete. If you can add a column to your base table, you could alter the trigger to put the name of the procedure into that new column.
Jan
7
awarded  Peer Pressure
Oct
17
answered how to change sybase sql default port
Oct
17
comment how to change sybase sql default port
You should probably include more details in your question, such as DB product (Saying it's a Sybase database does not narrow down options), OS, etc...But since you are talking about running SAP..I'll assume you mean Sybase ASE.
Sep
30
awarded  Explainer
Sep
24
awarded  Autobiographer
Jul
29
comment Performance tuning in Sybase
optdiag and monitoring tables are the tools to monitor performance.
Jul
29
answered Getting database usage of all the database at once in Sybase
May
29
answered advantage database server current database name
May
29
comment Sybase Replication rs_subcmp can ignore length?
May want to try this over at the SAP community network. Some of the RS engineers frequent there scn.sap.com/community/sap-replication-server
Mar
28
comment How to get list of tables, views etc. a users has rights to on Sybase IQ?
infocenter.sybase.com/help/index.jsp?topic=/… <---Lists all the system views, as what you are looking for is going to require joining multiple views together (sysprocperm, systableperm, etc. etc.)
Mar
25
revised Sybase ASE 12 question
added 212 characters in body
Mar
25
revised What's the best way to get data for sampling points within a timeframe
Added Sybase IQ tag.
Mar
25
answered Sybase ASE 12 question
Mar
25
revised Sybase ASE 12 question
Formatted code
Mar
25
suggested approved edit on Sybase ASE 12 question
Mar
25
suggested approved edit on What's the best way to get data for sampling points within a timeframe
Feb
18
comment How to know spid which is filling tempdb from temp table name in sybase
Sybase uses a different system table structure than SQLServer, so I don't think it's a duplicate.
Sep
10
awarded  Organizer