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/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-> | * backup: right click **database name** and select **tasks-> | ||
==== attach database file(mdf file) ==== | ==== 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 | * 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:// | + | * 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.1424931062.txt.gz · Last modified: 2022/10/29 16:15 (external edit)