I have a stored procedure that worked beautifully when it was in Access, but now that I have moved over to SQL Server 2000, I am losing data. The problem occurs with my two ntext(memo) fields and the bit(true/false) fields. The data is disappearing. I tried putting the ntext fields at the back of my query AND dumping them into variables to hold the values, but the problem is that I can't get all of the data. Also, I have heard of losing memo fileds but why would I be losing bit fields?