I have a need and don't know if its possible, and if so, how.
We have an NT server with SQL 6.5.
At present, I am using the data databases for development purposes. Our testing department needs access to same data source but needs to change while we need the data intact.
Since the referencing to the database/table would be the same, How would I go about creating this other area.
Ex:
SQL65 (server)
LiveArea
Database1
Database2
Database3
TestArea
Database1
Database2
Database3
TIA