Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Junk/SPAM Posts Overwhelming Expand / Collapse
Posted Thursday, June 19, 2014 9:40 AM



Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 13,067, Visits: 11,903
Thanks Melanie. I imagine it is painful when this amount of spam infiltrates.


Need help? Help us help you.

Read the article at for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1583924
Posted Thursday, June 19, 2014 10:05 AM

SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 8:36 AM
Points: 4,319, Visits: 6,112
, we aren’t going to stop people from signing up to the site and the forums,

Then you are trying to solve this problem with one of the most effective and simple solutions available. No matter how complex the logic you build to prevent/automatically delete unwanted spam posts you are essentially GUARANTEED to a) miss some fraction of unwanted posts and b) delete some fraction of false-positive valid posts.

I wish you all the luck with whatever approach(es) you wind up taking, but it seems to me that you are constraining yourselves to REACTING instead of being PROACTIVE. Putting a simple, easy verification in front of each new user is a TRIVIAL amount of effort for each new user to take care of while providing benefits for ALL of us, including your staff that currently have to wade through the posts each day to remove unwanted ones. It seems intuitive that such systems are effective given how many sites have moved to implement such initiatives.

UPDATE: I read the post to say "not going to stop UNWANTED people from signing up" - i.e. a better form of new-user verification than is currently being used.


Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1583945
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse