windows:sqlserver
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
windows:sqlserver [2015/01/14 04:04] – [backup and restore bak file] admin | windows:sqlserver [2022/10/29 16:15] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 26: | Line 26: | ||
</ | </ | ||
* Step2: Using SQL Server Configuration Tool, go to **SQL Server Network Configuration**-> | * Step2: Using SQL Server Configuration Tool, go to **SQL Server Network Configuration**-> | ||
+ | ==== view database config(data config, log config...) ==== | ||
+ | * step1: select database as below image: | ||
+ | {{: | ||
+ | * step2: right-click the database and click **properties** to see the database settings as below image: | ||
+ | {{: | ||
==== reset password ==== | ==== reset password ==== | ||
===== Backup and restore ===== | ===== Backup and restore ===== | ||
Line 34: | Line 39: | ||
* backup: right click **database name** and select **tasks-> | * backup: right click **database name** and select **tasks-> | ||
==== attach database file(mdf file) ==== | ==== 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:// | ||
+ | ==== 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**, | ||
+ | ==== Debug stored procedure with break point ==== |
windows/sqlserver.1421208261.txt.gz · Last modified: 2022/10/29 16:15 (external edit)