| Home |
| Articles |
| Backup |
| Books |
| Certification |
| FAQ |
| Products |
| Replication |
| Scripts |
| Seminars |
| Training |
| TSQL |
|
| MSDN Fourms |
| Philippine SSUG |
| Fort Worth SSUG |
| Oklahoma City SSDG |
|
| Resume |
|
| MHS Enterprises |
| BlowFrog Software |
| FilAm Software |
| AcrylicAcetate.com |
| Bargain Humidors |
| Western Humidor |
|
|
What does -y<xxxx> mean
as a SQL Server start-up option?
It is set as a debug option, typically at the request of PSS support to track down certain
errors - e.g. 604, 3307. When SQL gets an error specified in the -y option(s) then it
takes a snap dump of memory at the time - much like when it intercepts a gpf problem. This
can be used to see how SQL Server got into the problem area. |