Differences

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

--- windows:sqlserver [2015/02/26 02:31] – [view database config] admin
+++ windows:sqlserver [2022/10/29 16:15] (current) – external edit 127.0.0.1
@@ Line 26: / Line 26: @@
 </code>
   * Step2: Using SQL Server Configuration Tool, go to **SQL Server Network Configuration**->**Protocols for MSSQLServer**->**TCP/IP**{{:windows:sqlserver-ipconfig.png|}}
-==== view database config ====
+==== view database config(data config, log config...) ====
   * step1: select database as below image:
 {{:windows:database-config.png|}}
@@ Line 39: / Line 39: @@
   * backup: right click **database name** and select **tasks->generate scripts**
 ==== attach database file(mdf file) ====
+===== debug in sql server =====
+==== query log in sql server ====
+  * to view query log in sql server, we use sql server profiler
+  * 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 ====