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
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...
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...
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.
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
...
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...
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?
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. ...
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.
August 18, 2009 at 12:18 pm
Check out this thread as well as it asks the same 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...
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...
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...
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...
August 17, 2009 at 2:59 pm
August 17, 2009 at 7:14 am
Viewing 15 posts - 4,366 through 4,380 (of 9,643 total)