Tag Archives: server

Batch Script – Reading parameter file into variables

Hi folks, quick tip on how to easily read a parameter file from a batch script. This is an idea I had to make the life easier when trying to troubleshoot connection issues from client to server and I had … Continue reading

Posted in Scripts | Tagged , , , , , , , , , , , | Leave a comment

Analyzing developer traces

When you see errors in SM50, where can you go to further analyze the problem? The answer is: Developer traces. Developer traces will help you identify most problems of the system concerning rfc, s.o, dispatcher, workprocess, database and so on.

Posted in SAP Basis | Tagged , , , , , , , , , | Leave a comment

Identify MSSQL Database ID

To identify the DB ID of the current database run the command: select db_id() go To identify the DB IDs of all your databases, run the command: use master select dbid,name from sysdatabases order by dbid asc go

Posted in SQL Server | Tagged , , , , , , , , , , , | Leave a comment

SQL Server tip – Calling .SQL scripts from osql

This is quite simple and handy; You can call it with some parameters.

Posted in SQL Server | Tagged , , , , , , , , | Leave a comment

Shrink and truncate the log file

If the transaction log of a certain database is using too much disk space on the server, you might want to revisit your transaction log backups and set them to run with a higher frequency. You can always reclaim some … Continue reading

Posted in Scripts | Tagged , , , , , , , , , , , | Leave a comment