What version of sql server

Mike

Same line of thought.Had a situation where a report was run every couple of minutes.

Fortunately I knew who ran it without running any kind of trace.On looking closely you...

as-salam 'aleykum

If you run dbcc showcontig often ,know which third party the database is for,what the database is used for and by whom it may be easy to see that...

Go to the control panel and click on the licensing.Hopefully that should get you going

Mike

From my experience it is possible to run a job with sql server agent being a local admin

Do you have the necessary permissions?

I normally use a domain account for my...

It looks like it has to do with trust

Check this out http://dbforums.com/arch/175/2003/5/758301

Mike

Long link but may have what you need

http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&threadm=3fb0119b%240%24193%2475868355%40news.frii.net&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26group%3Dcomp.databases.ms-sqlserver

Mike

Have you checked into quest software tools?

Quset Central is pretty nifty (no sales man)

Mike

I have never used one but depending on where you are there is a good chance you will have dba online service around.

Type DBA online and do a search...

Ever given a thought about an extra pair of eyes in your workplace

Mike

Is a black box trace should be stopped by running

sp_trace_status to 0?

Then

Mike

Except I am missing something are you saying that if you run 100 queries there will be 500M of trace (from the answer)

Produce 5MB trace files with each query run...

Sql server 2000 Performance Tuning

By Whalen Garcia Deluca Thompson Helped me out on that

Mike

Sqldiag.exe tool found .../binn/ will give you the last 100 procedures run .That is about the closest in sql server known to me

May be some one has more on this.....

Mike

...

I think BOL has specifications on this

Win 2k Enterprise Edition supports up to 4G of RAM

Mike