Viewing 15 posts - 4,366 through 4,380 (of 9,643 total)
The error message states that NAMED PIPES did not work so enabling TCP won't work. Maybe this article will help, http://msdn.microsoft.com/en-us/library/ms188247.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 1:09 pm
Sure, you either need to run query analyzer on the server/PC that Express is installed on or you need to use the Surface Area Configuration Manager to allow remote connections...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:59 pm
If as Jeffrey has noted, you have 8 sockets then SQL Server 2005 Standard will only use 4 of the processors. You should be able to run SQL Server...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:57 pm
Have any PTF's been applied to the AS400? If so you may need an updated IBMDASQL driver.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:52 pm
If your source is SQL Server might I suggest you do the conversion in your SQL Statement in the source. Something like:
DECLARE @test-2 TABLE (col VARCHAR(5))
INSERT INTO
...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:50 pm
I don't know of anyway to hide a parameter based on another parameter within SSRS. You could do a custom web page that does that and then calls the...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:39 pm
Are they ad hoc queries or stored procedures? Are they parameterized? Are they the exact same queries including parameters?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:37 pm
Apparently this is a known issue that currently will not be addressed in SQL Server 2008 but is supposed to be addressed in the next version of SQL Server. ...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:31 pm
Just found this thread which asks the same question so you might want to check it out as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:18 pm
Check out this thread as well as it asks the same question.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:17 pm
I wouldn't recommend it. Anything that happens in a trigger happens within the scope of the INSERT/UPDATE/DELETE transaction so if the web service call fails the transaction will roll...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:15 pm
What you are seeing is the ExistingConnection event. This basically lists all existing connections along with the connection settings. This can be important because some of the settings...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:12 pm
I'd probably do the Virtual Machine. You can build it once, save a copy of the clean VM off somewhere, mess around and if it gets messed up you...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 8:07 am
anki_bakshi (8/17/2009)
I am wondering do indexes on the table play part in this FK constraint violation error.I have a unique index on DocumentChild2(Document_GID,Child2_name).
Nope, you'd get a unique index/constraint violation error.
Was...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 17, 2009 at 2:59 pm
Here's a good blog post[/url] about setting US Holidays in a calendar table.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 17, 2009 at 7:14 am
Viewing 15 posts - 4,366 through 4,380 (of 9,643 total)