@@error & @bErrors variables from Index Tuning Wizard

The Index Tuning Wizard recommended these indexes:
CREATE NONCLUSTERED INDEX [pairs5] ON [dbo].[pairs] ([hit] A
SC ) IF( @.@.error
<> 0 ) SET @.bErrors = 1
CREATE NONCLUSTERED INDEX [pairs6] ON [dbo].[pairs] ([query]
ASC ) IF(
@.@.error <> 0 ) SET @.bErrors = 1
What are @.@.error and @.bErrors?
Thanks,
JimHi
@.@.ERROR is a system function and returns the error number of the last comman
d
http://msdn.microsoft.com/library/d...r />
_4hk5.asp
@.bError is a local variable and should be declared earlier in the script. It
seems to be used as a flag to indicate that something has failed somewhere!
John
"Jim" wrote:

> The Index Tuning Wizard recommended these indexes:
> CREATE NONCLUSTERED INDEX [pairs5] ON [dbo].[pairs] ([hit]
ASC ) IF( @.@.error
> <> 0 ) SET @.bErrors = 1
> CREATE NONCLUSTERED INDEX [pairs6] ON [dbo].[pairs] ([quer
y] ASC ) IF(
> @.@.error <> 0 ) SET @.bErrors = 1
> What are @.@.error and @.bErrors?
> Thanks,
> Jim
>
>|||Thanks, John!
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:9FDF1C1D-E05D-4224-9154-975D53979E5B@.microsoft.com...[vbcol=seagreen]
> Hi
> @.@.ERROR is a system function and returns the error number of the last
> command
> http://msdn.microsoft.com/library/d.../>
te_4hk5.asp
> @.bError is a local variable and should be declared earlier in the script.
> It
> seems to be used as a flag to indicate that something has failed
> somewhere!
> John
>
> "Jim" wrote:
>sql