Differences

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

--- windows:sqlserver [2015/01/14 03:52] – [install sql server 2012 with Manage studio tools] admin
+++ windows:sqlserver [2015/03/11 15:35] – [The actual stored procedure line number from an error message] admin
@@ 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(data config, log config...) ====
+  * step1: select database as below image:
+{{:windows:database-config.png|}}
+  * step2: right-click the database and click **properties** to see the database settings as below image:
+{{:windows:database-setting.png|}}
 ==== reset password ====
 ===== Backup and restore =====
 ==== backup and restore bak file ====
+  * to restore: right click **databases** and select restore database
+  * to backup:  right click **database name** and select **tasks -> backup**
+==== backup and restore sql scripts ====
+  * 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 ====