| Author |
Topic |
|
blahhhhhhhhhhhhhhh
Starting Member
6 Posts |
 Posted - 2010-10-06 : 00:56:00
|
| Hi all,I've been lumped with the task of getting a system working that someone else created years ago and there is no documentation, nor can i contact the original developer.I need to know how a table is getting populated. There don't seem to be any stored procedures or jobs that do it, and i don't know whre else to look. My experience with databases is little to none :)Can anybody help me? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blahhhhhhhhhhhhhhh
Starting Member
6 Posts |
Posted - 2010-10-07 : 18:27:08
|
| Thanks tkizer,I tried running a few 'traces' but the results didn't help me at all. I don't really know what i'm doing :)The problem is that a few weeks ago data stopped coming into the table in question. This table exists in another SQL server and the table in question (in the other database) has current data in it but i don't know what to look at to see how it gets there.The reason for all of this is that i have had to give this system its own database, where it was previously in another database shared with other systems and it was getting too big.Any help i can get is greatly appreciated. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blahhhhhhhhhhhhhhh
Starting Member
6 Posts |
Posted - 2010-10-07 : 20:15:32
|
quote:
Originally posted by tkizer
Well what did the traces show?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Unfortunately my boss won't let me post the traces.Is running a trace the only way of finding out where the data might be coming from? If so what am i looking for? In SQL server A (the one that's working) there are other databases that this data is probably coming from, but i don't know how to find out where or how. In SQL server B (where my non-updating table lives) these other databases don't exist.Thanks for replying to my post, too. :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blahhhhhhhhhhhhhhh
Starting Member
6 Posts |
Posted - 2010-10-07 : 20:47:22
|
| Trace details:user sa.Template name SQLProfilerStandardI tried with the default events, Data file auto grow, DTCTransaction,Data columns defaultFilters DatabaseName like the database name where the table livesThanks again |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blahhhhhhhhhhhhhhh
Starting Member
6 Posts |
Posted - 2010-10-07 : 21:37:29
|
| Awesome, there is a lot of stuff coming up, i will have to filter a lot of things out. hopefully i find what i am looking for! |
|
|
|
blahhhhhhhhhhhhhhh
Starting Member
6 Posts |
Posted - 2010-10-31 : 21:00:29
|
| i managed to get in contact with the creator of the system and the data was coming from another sql database on a different sql server. all sorted out now thanks for your help tkizer |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
where does the data come from?