SQL Server: Debug – Why can’t I find a stored procedure by SQL Profiler?
Because that stored procedure is executed inside a stored procedure. Stored procedure executed inside a stored procedure is not hit by SQL profiler (?) Because that […]
SQL Server: Debug – How to check temporary table created by INSERT INTO?
Get the table structure by [sql]exec tempdb..sp_help ‘#tempTableName'[/sql]
React Native: How to store data into the local storage of the application?
Use Realm How to see Realm database Install Realm Browser How to know my Realm file path [js] let YourRealmDB = new Realm({schema: [YourSchema]}); console.log(‘YourRealmDB […]
ASP.NET: C# – How to re-arrange rows in a DataTable?
[c] … DataView view = dataTable.DefaultView; // dataTable has [Column 1], [Column 2], [Column X], [Column Y] view.Sort = “[Column 1] DESC, [Column 2] DESC”; […]
SQL Server: How to trace down database activities?
Create trigger to log activities Record actions happening on CREATE/ALTER/DELETE stored proc Create table to save actions happening [sql] CREATE TABLE dbo.ProcedureChanges ( EventDate DATETIME […]
ASP.NET: How does ASP.NET Ajax work?
SYS namespace SYS namespace represents the root namespace for the Microsoft Ajax Library. Sys is not a server side namespace. ASP.NET Ajax registers its clientside […]
SQL Server: How to use SQL Server Profile
How to trace which stored procedures are called Open “Trace Properties” window Select “Event Selection” tab Check “Show all events”, “Show all columns” tab Check […]
Windows Service – Error: “Service on Local Computer started and then stopped”
Error message meaning [html] This means code is throwing an unhandled exception. [/html] Debug Event Viewer -> Windows Logs -> Application [html]Login failed for user […]
React Native & iOS & Android
How to convert iOS app to Android app?