No, I don't think so.  I think you've got some sort of circular reference going on.  But without being able to see what the FKs do, I can't help you. ...

Darren

Do you have Query Analyzer?  You can use the Object Browser to expand the database, then expand each table.  Find the Constraints you are looking for, then right-click and this...

Can you not have the stored procedure insert directly into the DataBaseSizeReport table?  Or you could have it insert into the same temp table and then copy the data from...

Darren

Please will you post the SQL to create those two constraints, and any other foreign key constraints inolving either of those two tables.

Thanks

John

This worked for me:

--Table

CREATE TABLE #t(dbname sysname, logsize decimal, logspace decimal, status INT)

--Insert

INSERT INTO #t(dbname, logsize, logspace, status)

EXEC ('dbcc sqlperf(logspace)')

--Results

SELECT * FROM #t

John

Claudia

Is 192.168.195.10 the publisher or the subscriber?  Is it possible that you have a case-sensitivity issue here (maybe one of the tables is called Region and the other REGION)?  You...

This is far too big a question to answer in a few lines.  Make sure that you have enough memory and disks and that they are properly configured.  Make sure...

Claudia

Sounds like you've got a table called Regions in the published database but not in the subscriber.  Check the list of articles in the publication, and make sure that all...

Ade

I know this doesn't answer your question, but it may make your life easier.  Why are you shelling out the SQL statement @Cmd to isql?  Why don't you run it...

Danster

That would work, so long as your stored procedure's result set consists of only one row.  I think my original idea for making sure you only update what you've just...

Dylan

Try this.

John

--Table
CREATE TABLE #eh_batch_reference 
 (eh_id_pk INT, eh_order_id_fk INT, eh_edi_reference VARCHAR(20),
  eh_batch_reference VARCHAR(20), eh_order_sent tinyint, eh_completed_date datetime)

--Data
INSERT INTO 
 

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...