which one should I use newline or \r? Or can I test for both?

Also, how would I have to change my code to include this?

How can i check that?

I am just baffled as the system was able to connect just fine to the db, but then over the weekend security patches were installed. ...

It's not my brilliant idea. Interesting though that why would MS provide the registry solution if increasing beyond 99 doesn't work? why would they publish this fix?

Andy,

Did you check the error log?

yeah, i can confirm that it is ignoring the registry stuff. Ok - hopefully MS will have an answer to all of this.

Thanks for the info. i'll take a look. I'm using SQL Server 2005, 9.0.2050

I'm on SQL Server 2005, the solution for greater than 99 is to edit the registry (MS solution)...I'm not understanding your comment reg. recycling and it set back to 99...how...

I did run EXEC sp_cycle_errorlog; again so that it would force a new error log but it still shows the active one and then logs numbered 1 through 6 (total...

SSCrazy,

You do have to do it in the registry if you want more than 99...can't do it in Enterprise Mgr.

I am in the process of convincing them of this (backing up old ones) but they want to consult MS, so I said in the meanwhile I'd do my research....

I guess it didn't show me that, that means my registry change did not take effect...now I need to figure out somehow why it didn't.....yeah tell me about it. ...

I did and got this message:

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

it doesn't give me the info I need....