Thanks Yelena. It's a domain account.

Zubeyir

It's done automatically.

Yeah. It'll keep eating until the limit is reached. But SQL 2005 can give you back the mem. resources the it allocated.

Zubeyir

If you're in a situation that you cannot stop the SQL engine, I suggest you to have ghost back-up.

SQL 2000 does not give back the memory that it got from the OS once. The mem. released only when you restart the instance.

For the first scenario SQL engine...

You're welcome

The reason that it runs automatically is "Auto Track Changes". This option seems to be on on your FT index. You can set a job to run during night.

Zubeyir

Initially there is no system job on any sql instance. But services like full text or log shipping can produce some jobs on the server. You can identify those by...

You sad you have just inserted some large data into the tables. Maybe full text catalogs are not yet populated. Are you manually updating the tables? Can you successfully select...

select * from dbo.sysjobsteps where job_id = 0xDA9A9D92A78C0E42A37EE96C7BEBB073 

Should just work.

Do you get any error? What kind of misfunctioning does it have?

What's inside this DTC package? T-SQL or anything?

As a best practise it's always better to keep user interactions out of the transaction scope. That way you may be able to keep transactions shorter and smaller. And they're...

If you rename the machine name of a sql instance that renames your sql instance too. But if you have a named instance you (as I know) need to uninstall/reinstall...

Maybe not directly related but why are you using "%" with the test query. You just give the actual query and let the sql produce the template.

Zubeyir