We get this error when we select * on one of our records in one table (using like where id = 12345). I can see all the dates and nulls...

I agree with Paul. Just look up the SUBSTRING function.

I experienced this problem after I installed a service pack. I opened the "configure report service" application on the server machine. In report manager virtual directory settings I checked the...

I know there are many possibilities but one thing I would consider is if the SSIS package runs while many client apps are connected to the server. Thus there would...

A good bet is to create the package as the very user whose credentials are used to run the package. The user should be a member of the role(s) needed...

Okay I guess I am not clear on your objective. Can I ask how you are inserting records? Without bulk load they are commited one at a time. Do you...

Bulk loads I am quite sure bypass triggers. To use the sp_send_dbmail procedure you have be an admin or the login should be given the securable DatabaseMailUserRole (a schema) pertaining...

In the Raw file properties dialogue set WriteOption to 'append' and ValidateExternalMetaData to false. This should still create the file on the first iteration. I found it to be inconsistent...

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...