Viewing 15 posts - 181 through 195 (of 335 total)
Well then, how far have you gone looking into if DTC is configured properly? The setup, checking the log(s), tracing, etc.
April 25, 2005 at 10:01 am
One does not typically try to capture @@error for the select statement contained within the IF EXISTS.
In the case of an assignment select, result set select, or a create...
April 25, 2005 at 9:58 am
RPC means many different things to different people, you might want to show the code in your "SendMail" proc. (like specifically, by RPC do you mean a stored proc on another...
April 25, 2005 at 9:06 am
You're a young wippersnapper... I go back to 300 baud with the hand set cradles. Back in the days when televisions were still propane powered...
April 25, 2005 at 8:55 am
My only question: Why did you have to spend any time researching to find your answer?
Did you think that a mass of people can't all jump on the bad idea...
April 22, 2005 at 4:21 pm
That's the spirit! Every little bit counts. Now, the next step is dots and dashes. Morse was a genius!
April 22, 2005 at 3:56 pm
Are you tracing at the statement level within the procedure? That is, default level is just one entry for EXEC storedprocname... start at/end at. Detail allows the trace to show...
April 22, 2005 at 3:49 pm
I'm just thinking to save the responders time: RTFFAQ is quicker to type.
April 21, 2005 at 1:04 pm
The answer is yes, it is easy to do. (Assuming you're SA and are going to run it as SA)
Write a TSQL select statement that creates/formats a 147 BCP...
April 21, 2005 at 1:00 pm
The real stump the SQL Server guru question is to ask him the correct syntax for a cursor...
OK, I have to stop now, starting to sound like a broken record.
April 20, 2005 at 7:03 pm
I don't have sql on this box so can't verify but I think Sql 2k allows you to sort by something not displayed. i.e. select convert(datecol...) ... order by datecol
Otherwise,...
April 20, 2005 at 6:56 pm
if not exists (...) begin
begin tran
get your totals
insert the row
commit tran
end else begin
begin tran
update...
April 20, 2005 at 6:38 pm
Something else that I think was lost in a post I made...
Though I hate, despise, spit upon... silly certs... Everytime a friend asks me to give advice to their children/nephews...
April 20, 2005 at 6:17 pm
"BTW, you've inpired me to finally set up an avatar image...go creative commies!"
DOH! Another one slips over to the darkside...
Resist people! Don't be lured into the evil waste of...
April 20, 2005 at 5:54 pm
Yes.
Don't do that.
Don't insert then update. Insert only.
April 20, 2005 at 4:16 pm
Viewing 15 posts - 181 through 195 (of 335 total)