• RSS
  • Twitter
  • FaceBook

Welcome to ISAserver.org

Forums | Register | Login | My Profile | Inbox | RSS RSS icon | My Subscription | My Forums | Address Book | Member List | Search | FAQ | Ticket List | Log Out

SQL Logging "Rule" field

Users viewing this topic: none

Logged in as: Guest
  Printable Version
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> SQL Logging "Rule" field Page: [1]
Login
Message << Older Topic   Newer Topic >>
SQL Logging "Rule" field - 18.Dec.2010 12:15:14 AM   
mmcnabb

 

Posts: 2
Joined: 18.Dec.2010
Status: offline
I have ISA Server 2006 at home in a lab environment and am logging to SQL Server 2005. When I try to include the "rule" field in any of my queries I get a SQL syntax error. I have even tried using a fully qualified reference (firewalllog.rule) but I get the same result. I assume this is because RULE is a reserved keyword but I thought using firewalllog.rule would get around that. Has anyone else had this problem?
Post #: 1
RE: SQL Logging "Rule" field - 18.Dec.2010 12:35:51 AM   
mmcnabb

 

Posts: 2
Joined: 18.Dec.2010
Status: offline
Sorry please disregard this. I just found the answer and man is it simple. Square brackets saved the day. Duh!

(in reply to mmcnabb)
Post #: 2
RE: SQL Logging "Rule" field - 18.Dec.2010 7:51:14 AM   
paulo.oliveira

 

Posts: 3472
Joined: 3.Jan.2008
From: Amazon, Brazil
Status: offline
quote:

ORIGINAL: mmcnabb

Sorry please disregard this. I just found the answer and man is it simple. Square brackets saved the day. Duh!

Great! Thanks for sharing the solution.

Regards,
Paulo Oliveira.

_____________________________

Microsoft Premier Field Engineer (PFE)
Blog: http://poliveirasilva.wordpress.com/
Twitter: https://twitter.com/poliveirasilva

(in reply to mmcnabb)
Post #: 3

Page:   [1] << Older Topic    Newer Topic >>
All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> SQL Logging "Rule" field Page: [1]
Jump to:

New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts