I thought we were talking about foreign keys?  At least that is what Darren's original question refers to.  I'm afraid I don't understand how you can have a foreign key...

Gift

Am I understanding you correctly?  Are you saying that, to create a foreign key, the name of referencing and referenced columns must be identical?  Is this new to SQL 2005,...

Darren

I'm afraid I'm not familiar with the SET TO NULL option.  But you can't have cascading deletes for the reason I mentioned above.  And you may find that you still...

So I'm guessing you're getting the error message when you try to create the second foreign key constraint?  I'm also guessing that you are using the following code to attempt to...

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