Hi Ward,

Thanks for the suggestions but I tried them & no luck.  I still receive the same error when I execute:

Update

HeatCustomerDim

Set

CurrentCustomerStatus

Steven,

Thanks for the reply! 

I did see that article already.  I am not quite sure how that applies to mine mainly because it works in the statements before & after...

Alastair,

Did you use the import/export wizard to do your export?  You should be able to right click on your database, go to tasks/export data.  Select your SQL 2005 server as...

From what I have read & understood, if you change the protection level of the package to ServerStorage, then it will store the passwords in the MSDB database & uses...

Doesn't Oracle have a native connection or an OLE DB driver?  From what I have been told, the 64 bit won't ever support ODBC because of it being an old...

Charles,

We have views that were accessing tables in our CRM application via ODBC in SQL 2000 on the 32 bit platform.  So for the 64 bit platform, we are creating views...

We are currently moving to the 64 bit platform.  The biggest thing we have hit so far is that ODBC is not supported on the 64 bit platform. We used...

Hi Claudia,

Did you try a transaction log backup before deleting the file?  That should have cleared out the log file for you. 

Anyways, have you tried using the following command...

Mike,

Do you have any disk on the server where you could add a second data file?  Also, depending on the type of database it is you may be able to...

I am getting this same error message.  I have rebooted several times & still receive the error.  Anyone else have any ideas to resolve this?

I am running SQL 2005 Enterprise...

Mike,

You check the logs manually on every server or have a SP parse through them?

John

Thanks for all the responses guys.  You all confirmed what I just discovered.  I ended up going with a process similar to what SQLBill suggested.

I am not sure what I...

I am not sure why I had to do this but it worked.  I reinitialized all subscriptions & then the snapshot was regenerated & the subscriber was able to pull...

Never mind, this post can be deleted.  I couldn't see where I can delete.

John

Walter,

I never did find a solution to this besides having the user use named pipes instead of TCP/IP.  Only had this issue with one user so I am not exactly...