How to find the path? - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to find the path?

Author

Topic

srivenu
Starting Member

4 Posts

Posted - 2009-06-04 : 14:43:01

Hi,
I am new to SQL server.

I need to find out how the tables got loaded and the path where the data is coming to these tables.

Here is my problem:

When I see the tables in the SQL Server Enterprise Manager,

There are two tables with creat date 5/14/09.

I need to find out how these tables got created or loaded with the data. Because since that date, the data is not loaded into these tables and i need to load the current data into them.

First of all, I need to know how these tables got created or loaded, Is there anyway to find out the path from which server these got loaded or which process/job ran to load the data into these tables. Please help ! I am struggling to find out since 2 days.

Thanks,

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-04 : 15:03:32

Oh I think that is not possible. The table/the sql server is not recording when and from where data is coming.

You can do it only by yourself!

Each row in a table can have some columns to tell you when and from where it was inserted but you have to store this information.
Or you can build table(s) to store information about "data traffic". Each relevant process then must be coded to store those information...
Or you can...

Or did I misunderstood?

No, you're never too old to Yak'n'Roll if you're too young to die.

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-06-04 : 15:03:50

Other than the create date property, sql server does not track these things (out of the box). The process that loads your tables would need to have some logging built into it for you determine those details. The other consideration is that only a select few administrators should even have sufficient privs to create tables so it sounds like you've got some security work to do as well.

If it was a sql job that loads it you may be able to see some details in Job History (right click the job | View History)

Be One with the Optimizer
TG

srivenu
Starting Member

4 Posts

Posted - 2009-06-04 : 15:17:18

Thank you guys.

TG,
Where can I see these SQL JObs?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-06-04 : 15:24:59

From Object Explorer navigate to your Server, expand "SQL Server Agent" and you'll see "jobs" and "Job Activity Monitor"

Be One with the Optimizer
TG

srivenu
Starting Member

4 Posts

Posted - 2009-06-04 : 15:36:08

Too bad i have to ask you everything since i have no clue about this SQL server.
:(

Where is this object explorer.

All I can see the tools in SQl server:

Query Analyzer
Analysis manager
Enterprise manager
Service Manager

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-06-04 : 15:40:26

Ah - I didn't realize you were in sql 2000.

Open Enterpirse Manager. I haven't seen EM in a while so I don't remember exactly but the entire Enterpise Manager application is similar to Object Explorer. You should be able to find it in there in a similar manor as I described above.

Be One with the Optimizer
TG

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-04 : 15:49:51

In Enterprise Manager
expand your server
expand Management
expand Sql Server Agent
point to jobs
on the right side the jobs are listed
right click on a job and see the history

hope that helps
Webfred

No, you're never too old to Yak'n'Roll if you're too young to die.

srivenu
Starting Member

4 Posts

Posted - 2009-06-04 : 15:56:17

Got it. Thanks !
:)

I checked the SQL server agent and Jobs. But there are no Jobs in the SQL server agent.

Then i saw the management --> Current Activity -->Process Info

There i can see the database and the status and the last TSQL command used.

I see some object locks information too. Do i have to do anything about these?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-06-04 : 16:15:12

Based on what I've heard so far you don't need to worry about anything in Process INfo. One thing about jobs - if you are not an admin on the box (and not in the sql server role sysadmin) then you won't be able to see any jobs owned by SA.

Be One with the Optimizer
TG

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-06-04 : 16:18:14

And of course it is possible that jobs are running on a different server with data connection to your server.

No, you're never too old to Yak'n'Roll if you're too young to die.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources