The first thing you need to do is run an integrity check on that database - just as the message is telling you (sorry, but I have to wonder if...

SELECT ...

,CASE WHEN COALESCE(Memo, '') = ''

THEN 'NO'

...

interfac (12/30/2008)

---

With more testing I have found that none of the code samples return what I require.

SELECT master.id, master.field1, child.field1

FROM master INNER JOIN child on master.id = child.masterID

WHERE child.id =...

One thing you can try - might work, is to prefix all calls to the system views with the database and run the script from within the context of a...

No - once a database has been upgraded, it cannot be restored or attached to an older version. This was true from 2000 to 2005 and is still true...

This is a classis UNPIVOT process. You can review UNPIVOT in Books Online to see how to use it to get what you want. Another option you could...

You can use VARCHAR(MAX) - but I have to ask why you are using dynamic SQL in the first place, and especially a dynamic SQL string that exceeds 8000 characters.

Posting the full code doesn't make any difference here. You have a cursor, inside a cursor looping through who knows how many rows - creating multiple temp tables for...

Yeah, I know what you mean - but, I think I have it a bit harder than you do. If you have ever worked with any flavor of Mumps...

Yeah - I can see that. Thanks for the pointer to the bug article - I knew I had seen something like that also, but since I no longer...

Jeff Moden (12/30/2008)

---

I was also looking at today's article on SSIS and what I think is a fairly simple import...

http://www.sqlservercentral.com/articles/SSIS/64766/

All I can say is "Good Grief"... it took this person...

Gail, thanks for the test. It is interesting that the OP is getting the same error that you would get if you tried to perform a diff before ever...

Hey, I was just wondering if he's 9600, 14400 or 19200.

AFAIK - the QFX format is proprietary and banks actually have to pay Intuit for the specs. Not sure you are going to find anything available that is free.

Okay, I am still not clear what you are trying to say. If you have replication enabled between two databases and these objects which you have created synonyms for...