Are you using a Multiserver environment where your local server is the Master server and the box in Tokyo is the target server? Do you have the ability to...

You can run sp_helpdb to get all the options that are enabled and interpret what the values mean.

HTH,

Mark

The only other things I can think of to check would be

1. Automated Jobs and their code

2. DTS Packages

3. Linked servers and any processes they may be running against your...

Since you've indicated you created a trigger to track this down, my suspicion is you have a trigger else where that is doing this from a different table. The...

When you create the table on the Subscriber, use of this clause for the Identity column is required: NOT FOR REPLICATION

Indicates that the IDENTITY property should not be enforced when...

Here's something you could try:

1. Partition the table based on a date element, year is a common one or month if the table is archived regularly. You can...

I've had good success with Embarcadero's ERStudio.

Mark

From BOL:

How to place an existing table on a different filegroup (Enterprise Manager)

To place an existing table on a different filegroup

Expand a server group, and then expand a server.

Expand...

What advice would you like?

Mark

I don't think so; I checked the Fixed Server Roles in BOL and it doesn't appear it's possible 2K. What if you did this:

1. You create a job that...

Don't forget any DTS packages you may have on the original servers; as well as any necessary modifications.

Best of luck,

Mark

What account was used to register the server in EM? Make sure it's the one with Process Administrator rights. Maybe that's the issue.

HTH,

Mark

Check out Embarcadero's DBArtisian.

Mark

Try looking at the execution plan for both scenarios, with and without the variables. Maybe with the variables SQL Server is having a hard time determining whether or not...

I have figured this one out, when the Agent services are stopped it writes to the SQLAgent.out. When they are stopped, a new SQLAgent.out is written and the previous...