Wingenious ...  ingenious utility software solutions for Windows 95/98/Me/NT/2000/XP, Office 97/2000, SQL Server 7/2000
Introduction    Applications    Solutions    Wingenious

SQL Server Tools Solutions
Typical requests from a database administrator or developer...
I want to know details about users connected to my SQL Server box, including the database they are hitting.
I want to know which SQL Agent jobs have recently ended with failure.
Then try SQL Server Tools WT1 today!
Typical requests from a database administrator or developer...
I want to know if there are any structural differences between my development and production databases.
I want to know if any views, stored procedures, or functions have changed in my development database as compared to my production database.
Then try SQL Server Tools WT2 today!
Typical requests from a database administrator or developer...
I want to find a particular word/phrase/string within the SQL code of the objects in my development database.
I want to generate documentation for my development database, including table structure details and accurate information about dependencies between objects.
Then try SQL Server Tools WT3 today!
Typical requests from a database administrator or developer...
I want to archive/restore selected tables or truncate selected tables.
I want to export data from selected tables as a SQL script that can be applied to a different database.
Then try SQL Server Tools WT4 today!
Typical requests from a database administrator or developer...
I want to find a particular word/phrase/string within any character field of any table.
I want to locate and resolve duplicate record issues within my tables.
Then try SQL Server Tools WT5 today!
Typical requests from a database administrator or developer...
I want to capture all data changes in selected tables no matter how they are made.
I want to restore selected records from audit trails into their original tables, inserting or updating as necessary to revert back to their previous states.
Then try SQL Server Tools WT6 today!
Typical requests from a database administrator or developer...
I want to compare and synchronize data in corresponding tables in different databases.
I want to copy/refresh/delete a subset of my relational data as a unit, usually reading from my production database and writing into my development database.
Then try SQL Server Tools WT7 today!
Typical requests from a database administrator or developer...
I want to generate a robust set of CRUD (Create, Read/Retrieve, Update, Delete) stored procedures.
I want to generate the primary key constraints, foreign key constraints, and foreign key indexes for my database.
Then try SQL Server Tools WT8 today!