Differences

This shows you the differences between two versions of the page.

--- windows:sqlserver [2015/02/26 06:11] – [attach database file(mdf file)] admin
+++ windows:sqlserver [2022/10/29 16:15] (current) – external edit 127.0.0.1
@@ Line 39: / Line 39: @@
   * backup: right click **database name** and select **tasks->generate scripts**
 ==== attach database file(mdf file) ====
-===== query log in sql server =====
+===== debug in sql server =====
+==== query log in sql server ====
   * to view query log in sql server, we use sql server profiler
-  * and sql server express, we use expressprofiler(because in this version, the sql server profiler not exists): https://expressprofiler.codeplex.com/
+  * with sql server express, we use expressprofiler(because in this version, the sql server profiler not exists): https://expressprofiler.codeplex.com/
+==== The actual stored procedure line number from an error message ====
+Error line numbers may not match the number returned in the error always, this is because when **the SQL server executes a stored proc, it has its own compilation & execution methodology**, so the line numbers vary based on the execution order it takes
+==== Debug stored procedure with break point ====