Is there a way to stop this message from appearing in the
error log?  We have a process that runs once per minute
that runs this command and it's filling the error log.

Thanks.

[ Post a follow-up to this message ]

Hi Rob,
Try running the following and check for a while:

DBCC TRACEOFF (2505)

Thanks,
Chandan Dutta


"Rob" wrote:

> Is there a way to stop this message from appearing in the
> error log?  We have a process that runs once per minute
> that runs this command and it's filling the error log.
>
> Thanks.
>

[ Post a follow-up to this message ]

What does that flag do?  I don't want to turn something
off that I don't know what it does.  
THanks!


>-----Original Message-----
>Hi Rob,
>   Try running the following and check for a while:
>
>DBCC TRACEOFF (2505)
>
>Thanks,
>Chandan Dutta
>
>
>"Rob" wrote:
> 
the[vbcol=seagreen] 
>.
>

[ Post a follow-up to this message ]

More detail in
http://www.devasp.net/net/articles/randy/traceflags.asp

Thanks.

"Rob" wrote:

> What does that flag do?  I don't want to turn something
> off that I don't know what it does.  
> THanks!
>
> 
> the 
>

[ Post a follow-up to this message ]

Please note that this list is not up to date. Some of the trace flags listed
are for SQL 6.5 and earlier and have no meaning in later versions, and some
were dropped in SQL 2000.
Be very careful trusting a one-line description on someone's web site to
tell you whether a traceflag is useful or not...thoroughly test any flags
before you use them in production.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


"Chandan Dutta" <ChandanDutta@discussions.microsoft.com> wrote in message
news:39803BB5-3075-490E-BE0D-2988A98BF686@microsoft.com...[vbcol=seagreen]
> More detail in
> http://www.devasp.net/net/articles/randy/traceflags.asp
>
> Thanks.
>
> "Rob" wrote:
> 

[ Post a follow-up to this message ]