Built in monitoring tools.

I am looking for a utility that will give the names of the tables (or the sql strings will do as well) that had data inserted, updated or deleted.
Is there anything like that built into SQL Server?Originally posted by access_dude
I am looking for a utility that will give the names of the tables (or the sql strings will do as well) that had data inserted, updated or deleted.

Is there anything like that built into SQL Server?

u can use sql profiler

Build datbase from xsd/xml ?

Hello all. I have an .xsd file and a .xml file that goes with it. Are there any tools available that will build a database structure in SQL Server from either of these two files? I can't see the .xml file being of much use for building the structure, but how about the .xsd file?
Nope - this requires good old analysis and database design the old fashioned way!

Brad