Categories
C# Notes

Steps to add model for MFI UI project which is same as API Request Model

Add Common Models to MFI_API_MODEL Project Build project and make error free Change Nuget Package Version in MFI_API_MODEL.nuspec file Generate Nuget Package from CMD using command: nuget pack mfi_api_model.nuspec -prop configuration=release Host Nuget Package to accessible server location in Ants or local computer Open Own UI project, Update Package version

Categories
MSSQL

MSSQL Check Running Queries

SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext