As you said, you need to create separate triggers on those tow tables. The trigger on the table Account can't capture changes on other tables

First check if the old server is used in any linked server. If it's not, run sp_helplogins to see if you have any logins in the format of oldservername\Login. Asp.net has a predefined...

Check your recovery model. Are you in SIMPLE model?  In this case, the backup "transaction log" and "file and group" are disabled.

Alan "I do not think that would work because you would still have to wait for the job to complete before the control of execution would return to the...

If you need detail data and aggregated data at the same time, you can use COMPUTE.

COMPUTE generates multiple record sets. Your client side app need to have the capability to...

I do not know it's possible or not. It's upto the code of the xp.

Waht about to schedule a job that runs immediately in your trigger?. Let the job do whatever you want.

If you do not have a partition column, i.e. the view is not a partitioned view, sql needs to load all data from the linked server into your local server....

Are you using double quotes in isnull function, like isnull(Departments.Department, " ") ?

osql uses ODBC connects to SQL server and QUOTED_IDENTIFIER is set ON by default.

Change them...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=219533

Just checked my jobs. I am using isqlw.

Checked BOL,

"All DB-Library applications, such as isql, work as SQL Server 6.5–level clients when connected to SQL Server 2000. They do not...

I don't know why sql angent add [SQLSTATE 01000] to the log.

But for isql, it should work. I have lots of jobs using this to generate scripts and are...

SET XACT_ABORT ON.

Set it in run time

On the Key 7:1700253162:6,

SPID 114 has Range_S_S lock (shared serializable range scan), and intents to acquire Range_S_U (shared serializable update scan)

SPID 98 has Range_S_U lock, and intents to acquire X lock.

However...

Here is the original MS link: http://support.microsoft.com/kb/291988

Caution Microsoft supports using the /3GB switch in Windows Server 2003, Standard Edition in a production environment for use by Active Directory. For...

sql 2000 standard edition can only support 2GB mem. You need to use enterprse edtion to use more than 2GB of ram.

Though windows 2003 SE support /3GB, it's not officially...