Agree with G squared --

Part of one of my triggers failed ( the send_dbmail block) yet the code after it successfully wrote to an auditing table I use to create...

Just something I noticed in your code

IF EXISTS (SELECT * FROM inserted a WHERE a.ValueB > a.ValueA AND a.WOR_ORDER_TYPE = 'WJ')

Even of another totally unrelated field gets altered in the...

one of the interesting things about 90 is that it can treat bit fields as true, false, or NULL (rather than just true or false)

I know this is a late reply but I recently encountered this issue after upgrading SQL SERVER 2005 to sp2.

What finally solved it was the reporting services configuration manager...

Hello,

I havent actually tested this but my belief is that a trigger can still fire even if the same value is re-entered into the field.

I usually do something...

Hi, that's like asking what will you be asked to build with C, the programming language, if you were being asked to learn it. I cant answer that but SSIS...

I had a similar problem with dynamic naming. I got around it by using an execute process task to run a batch file that copies the fixed file and names...

Sorry if I am a little naive here, but if both of the databases are on different networks could you not create a VPN from the "copy from" network to...

Sometimes, especially in a VM env, the firewall can cause these problems. In the firewall on the server allow it to open port 1433, what SQL SErver uses to listen...

Here is the basic Syntax:

update table1

SET serverowner = (

select serverOwner

from table2

where table1.servername = table2.servername

)

where servername in (select servername from table2)

GO

Sorry for the late reply, I overlooked some older emails...