Viewing 15 posts - 25,066 through 25,080 (of 26,487 total)
This is a DTC error, not really a SQL error. Since you are only doing a select query in Q2, it should work if you remove the BEGIN TRANSACTION...
March 14, 2008 at 11:01 am
Jeff Moden (3/14/2008)
John Rowan (3/14/2008)
I just wanted to thank you all for your military service.Awesome, John. Thank you, Sir!
Just want to add my Thank You as well.
True story: ...
March 14, 2008 at 10:32 am
Agreed. Looking back, I have no regrets and would do it all again.
😎
March 14, 2008 at 8:05 am
Grant Fritchey (3/14/2008)
And Jeff,...
March 14, 2008 at 7:12 am
You guys out on the front lines while I served 4 years in the Country Club (aka Air Force). All the best to you!
😎
March 14, 2008 at 12:12 am
I think I saw the light. Is this what you are trying to get?
SELECT
crmaf_account.name AS Company,
crmaf_account.new_membershiptypename AS MemberType,
...
March 13, 2008 at 4:44 pm
Okay, I reformatted the code, but I still don't really know what you are looking for. part of it is I am not sure which table is which that...
March 13, 2008 at 4:35 pm
GilaMonster (3/13/2008)
CREATE TRIGGER trg_PreventInvalidHours ON Works_On AFTER UPDATE AS
IF EXISTS (SELECT 1 FROM inserted i inner join deleted d
on i.ESSN...
March 13, 2008 at 4:20 pm
Asking for more:
For a better response, please read the following article. It provides excellent guidance on asking for help.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
There are plenty of people out here who would like to...
March 13, 2008 at 4:04 pm
Grant, you and my brother would defintiely have some stories to tell. He was nuke in the Navy also. He served on CVN-65.
I wish I could remember the...
March 13, 2008 at 1:01 pm
Set MAXDOP to 1 on the server, and reran the query and .........
the winner is .........
it took 30 seconds versus to 27 seconds for the straight select!!!!
This now goes back...
March 13, 2008 at 12:50 pm
UNC paths are they way to go in SSIS. The only place I have had a problem with not being able to use a UNC so far is with...
March 13, 2008 at 11:08 am
I think I have come up an explanation. Part of it comes down to parallelism. The straight select has a parallelism of 1, the select distinct has a...
March 13, 2008 at 10:59 am
For a better response, please read the following article. It provides excellent guidance on asking for help.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
There are plenty of people out here who would like to help, but...
March 13, 2008 at 10:06 am
Viewing 15 posts - 25,066 through 25,080 (of 26,487 total)