This simplest way I can think of doing it is something like this:

EXEC xp_cmdshell 'cluster resource "SQL Server (Instance_Name)"'

John

Danster

Assuming your temp table contains columns col1, col2 and col3 for the SP results and var1 and var2 for the variables, try this:

INSERT INTO #Table (col1, col2 col3) EXEC SPName

UPDATE #Table SET var1 = @var1, var2 = @var2...

Sounds like my dealings with CA back in the day!  Always difficult to get information out of them.  With this person's understanding of "devices", it sounds as if they're stuck...

Tryst

I assume you have a foreign key relationship between the two tables, so that every AnswerSet record is related to an inspection?  If that's the case, then you can use...

Trystan

Please will you provide some sample date and expected results.  Do either of the two queries produce the desired output?  If so, why do you not want to use them...

If you can't change the stored procedure then I think your only option is to have the client side manipulate the result sets for you.

John

If you change your stored procedure as below, it should work.

John

-- Creating test procedure

CREATE

PROCEDURE sp_test

AS

It sounds like either disk E failed or was unavailable, or the path to the error log was incorrect, and so the SQL Server resources failed over to the other...

This means that SQL Server was stopped "gracefully" - either manually or by some process (scheduled job, maybe, or application of a service pack) that stops the service.  If the...

Jay

It doesn't use VB, but here's how I'd do it:

(1) Find the job under SQL Server Agent that starts your replication agent.

(2) Create a new job that does exactly the...

If you've got enough disk space, then you're better off dumping your database to disk and backing up the dump file to tape.  If you have to use the Arcserver...

Vidas

A few things here:

(1) It is OK to start and stop SQL Server 2000 using Enterprise Manager or SQL Server Service Manager, even on a cluster.  The Microsoft documentation verifies...

Kedar

Run this script, after inserting your logical file name in both places (the logical file name is what you see under File Name in the Data Files tab of the...

Vidas

If you can find the answer to question 1, it may lead you to the answer to question 2.  But I'm afraid you're going to have to do some work...