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 ««12345»»»

Free Tools for the SQL Server DBA Expand / Collapse
Author
Message
Posted Thursday, May 24, 2007 11:14 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, October 28, 2008 8:32 AM
Points: 38, Visits: 6
I'm not sure how it compares to ExamDiff, but I like KDiff3 - http://kdiff3.sourceforge.net/
Post #368751
Posted Thursday, May 24, 2007 11:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, May 12, 2014 12:57 PM
Points: 2,281, Visits: 4,225
Be carefull when using the sysinternals handle executable as part of a SQL Server Job. For more details see:
http://forum.sysinternals.com/forum_posts.asp?TID=9912&KW=sql+server&PID=43231#43231
Formum post but noone has replied:

SQL Server 2000 has an Agent service that can run jobs that can perform file manipulation and a frequent problem is that the file is open by another process. An example is a job to perform database backups which also deletes prior backups that are older than a specified criteria. I have set up a SQL Server jobs that runs handle.exe when the database backup job step fails.

Handle version 3.02 works fine but handle v3.20 cause the SQL Server job to hang, that is, the SQL Server Job status is executing and it never finishes. This hang does not occur when handle is run as a windows scheduled task.



SQL = Scarcely Qualifies as a Language
Post #368762
Posted Thursday, May 24, 2007 12:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2008 11:16 AM
Points: 2, Visits: 5

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

Post #368781
Posted Thursday, May 24, 2007 12:55 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, December 12, 2013 11:40 AM
Points: 516, Visits: 74

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




Timothy J. Bruce
Post #368786
Posted Thursday, May 24, 2007 12:55 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:01 AM
Points: 315, Visits: 1,115
SQLRecon - see my earlier post It will display the versions of sql it found on your network


Post #368787
Posted Thursday, May 24, 2007 1:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 3, 2008 11:16 AM
Points: 2, Visits: 5

I ran SQLRecon.  I get a scan result like the following sample:

how do you tell if the SQL server is licensed? 

Thanks

Post #368793
Posted Thursday, May 24, 2007 2:30 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 7:01 AM
Points: 315, Visits: 1,115
The product will show the version number. Nothing will tell you if it's registered to you
or you company



Post #368823
Posted Thursday, May 24, 2007 2:46 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 12:28 AM
Points: 116, Visits: 184

SQLServerToolKit is an amazing tool. Toad for SQL Server is also a useful tool. Thanks a million David for sharing these tools.

RSingh

Post #368827
Posted Friday, May 25, 2007 3:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 7:42 AM
Points: 217, Visits: 533
SQLSpy from HybridX (http://www.hybridx.com/SqlSpy.Aspx)
Post #368942
Posted Friday, May 25, 2007 8:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 10:06 AM
Points: 184, Visits: 1,018

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.



David Bird

My PC Quick Reference Guide
Post #369046
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse