November 20, 2002 at 10:04 am
Q: Why this kind of messages appears so frecuently in SQl Logs? Are generated by the MSSQL Service? What are its effects?
November 20, 2002 at 11:50 am
What numbers are appearing?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
November 20, 2002 at 6:47 pm
Did you turn any trace flasg on in SQL Server startup?
November 21, 2002 at 9:37 am
bkelley, this is the exact message:
DBCC TRACEON 208, server process ID (SPID) 19.
I don't turn any flag
November 21, 2002 at 10:06 am
Here's the KB article that describes what you are seeing:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q243352
There is a trace flag you can set to prevent these messages. Basically, when ever MSQuery connects, it issues a SET QUOTED IDENTIFIER ON. For MSQuery, SQL Server apparently registers the trace flag.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
November 21, 2002 at 10:55 am
Thanks Brian and Antares686 !
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply