Is there a freeware utility that will scan the network for SQL servers to see if there are any SQL servers not properly licensed?
Thanks
Vishal
One tool I've found absolutely critical is the ability to format and write SQL - in other words - an editor.
The one I use is Context. It's free and provides color highlighting for SQL and many other languages. It's available from http://www.context.cx/
It's fast, and it works well, and I've written some scripts to help me load it quickly, passing the filename as a parameter. I've also associated the .SQL extension with it, so double-clicking on the file sends it to Context rather than to ISQL/OSQL/etc.
Tim
I ran SQLRecon. I get a scan result like the following sample:
how do you tell if the SQL server is licensed?
SQLServerToolKit is an amazing tool. Toad for SQL Server is also a useful tool. Thanks a million David for sharing these tools.
RSingh
Thanks for all the feed back on the article. I enjoyed reading about the additional free tools available and your comments on the article. I can't wait to give these other tools a try.
I did take a quick look at the open source tool KDiff3 mentioned by cowboy_k. The tool works great for scripts created by SQL Server 2005 Management Studio. Examdiff was unable to compare these scripts because it would treat them as binary files. KDiff3 has another nice feature. When it finds differences between files, only the differences are highlighted instead of the entire line.
Carlo, you should be able to access the link http://www.fullsun.net/. I am unaware of any alternative link.
