Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunnykj
Starting Member
29 Posts |
 Posted - 2005-10-31 : 21:13:12
|
| I want to know who had created the new tables,How can I achieve it?Can I know it by using the sysobjects table? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-10-31 : 21:25:15
|
| The guy you gave permissions toDamian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-10-31 : 21:32:46
|
We use Profiler and record ALL CREATE and ALTER statements. But, we're one of those financial companies that have auditors crawling out of the woodwork.  MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-01 : 00:57:37
|
| The Date/Time is available in the sysobjects table ("crdate" I think), using that you could check your Transaction Log backups around that time.Kristen |
|
|
|
sunnykj
Starting Member
29 Posts |
Posted - 2005-11-01 : 02:33:51
|
| Merkin,derrickleggett,Kristen Thank you for your advice.But How Can I get the information by using Transaction Log.Orelse Can I collect it into the specific table? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-01 : 03:26:14
|
| There are SQL Log Readers - from companies like Luminent Technologies and Red-GateKristen |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-11-01 : 11:02:27
|
| You can collect it into specific tables using Profiler. You can also use one ofthe products like Lumigent Log Explorer or Log PI, as Kristen mentioned.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-11-01 : 11:11:40
|
quote:
Originally posted by Kristen
There are SQL Log Readers - from companies like Luminent Technologies and Red-GateKristen
lumigent.com, apexsql.com and logpi.com all have products that you can use to look through the transaction logs. All 3 companies allow free downloadable eval versions too.-ec |
|
|
|
|
|
|
HELP:I want to know who had created the new tables