Viewing 11 posts - 1,186 through 1,196 (of 1,196 total)
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...
May 13, 2009 at 1:00 pm
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...
May 7, 2009 at 1:04 pm
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...
May 7, 2009 at 12:54 pm
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)
May 4, 2009 at 3:54 pm
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...
March 26, 2009 at 2:25 pm
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...
July 17, 2008 at 11:50 am
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...
April 8, 2008 at 6:47 pm
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...
November 14, 2007 at 8:21 pm
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...
November 14, 2007 at 7:34 pm
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...
October 17, 2007 at 5:38 pm
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...
October 17, 2007 at 4:46 pm
Viewing 11 posts - 1,186 through 1,196 (of 1,196 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy