One reason could be that the indexes are out of date.

run sp_updatestats on the database and check whether this makes any difference.

If this does not help then try reindexing the...

Please explain bit more about linking.

ie., do you want to define a simple relation ship between F1 and F2?

If so then you can use Foreign Key constraint.

If this relationship is...

Are you using Sql*Server 2000 SP3 ?

If so, you can use ::fn_get_sql(@handle) in the view to get the sql associated with spid.

Check out this site

http://www.databasejournal.com/features/mssql/article.php/2189761

Triggers can be disabled using following script

ALTER TABLE <tablename> DISABLE TRIGGER <triggername>

Remember to enable the trigger once update is completed.

Regarding your other query regarding updating invalid data, please put some...

Are you just looking at arithmetic difference between these two columns?

If so use Inner join between two tables to compute the value required

SELECT aaa.a1 - bbb.b1

FROM...

You are right. Looks like Microsoft recently updated this information in msdn online.

Check this out

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_de-dz_66w5.asp

which now contains,

A user-defined data type cannot be used as a column scalar data...

1. Trigger for tracking changes

Yes, you can use update trigger to track the changed column values.

The old and new values will be available in...

I had replied to a similar query earlier

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11640&FORUM_ID=8&CAT_ID=1&Topic_Title=hierarchies&Forum_Title=T%2DSQL%5B/url%5D

If you need more help let me know

As per BOL, xp_cmdshell uses the security context of SQLAgentCmdExec(when you are not logged in as sysadmin).

There might be permissions issues with this account and microsoft word.

One way to figure...

There is some information available in MSDN-KB on this error.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q307002&amp;

hope this helps.

One alternative is to use transactions and issue a SELECT with TABLOCKX within the transaction on the tables to be locked.

TABLOCKX holds exclusive lock on the table till...

One alternative is to use dynamic sql.

ie.,

1. Write a loop to extract parts of this column separated by comma.

say @m_expr = "250*0.03+100"

2. To evaluate...

Looks interesting.

Did you try

select * from table1 where descr_field IN ( dbo.ManipulateText('Some Text') )

One alternative is to use sysobjects

select OBJECT_NAME(parent_obj), name

from sysobjects

where xtype = 'F'

This gives the list of table name and associated foreign keys. You can declare a cursor to loop through...

Did you try looking at DTS package log to see the actual errors?

if so display some of those errors here. Some body might be able to help.