SQL Logging "Rule" field (Full Version)

All Forums >> [ISA 2006 Firewall] >> Logging and Reporting



Message


mmcnabb -> SQL Logging "Rule" field (18.Dec.2010 12:15:14 AM)

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?




mmcnabb -> RE: SQL Logging "Rule" field (18.Dec.2010 12:35:51 AM)

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




paulo.oliveira -> RE: SQL Logging "Rule" field (18.Dec.2010 7:51:14 AM)

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.




Page: [1]