Eric,
Well, I hope you have no pitfalls... we are running many servers, and maintain a constant watch with various firewall protections and Symantic. With SQL2000, the only 'pitfall' we have is insuring any new security leaks are identified promptly - to praise the big bear : Microsoft has been pretty good about identifying those leaks. A good article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_datapump.aspRic
>I was wondering how anti-virus software would affect an sql server performance, particularly, would it be worth it to install realtime protection? Does anyone else have virus software on their sql servers? What are the pitfalls youve expierenced, if any?
>
>Eric