I am very new to SQL. I am trying to run a SQL on a table to see what changes were made to the system.
Can I use one that's on my system in a folder entitled SQL Scripts? or do I need to create one.
I am using MSSQL Server 2000 and I Query Analyzer and received error message, table already created.
I am trying to find if any changes were made to the table. In this instance a Table was deleted and need to know who deleted it.
There is an SQL Files in a Scripts Folder where looks like a query is written that asks it to create a table, but what I am wanting to do is create a log of any changes on that particular table.
Hope this makes sense.
Again, thank you for your help and patience with helping me to understand
How do I get results of the query?
Thank you for your help.