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!
|