Interesting.

If I load the software on my PC can I direct where the new diectories should be created? I thinking of putting the output on a shared network disk as...

I'm interested in this type of Documentation. I can see where this data will be very valuable but I'm a little scared at what appears to be a very complex...

Just learning about the event this morning Monday June 16. If it was an event that I wanted to attend or even think about attending I wouldn't have enought lead...

Good Point.

During the testing I used the T drive. Afterwards I changed the final destination on another server over the network and I made the changes as you have indicated.

Thanks...

I have resolved my problem. Thanks to everyone who contributed.

For those who might be interested here is the code that works.

use ccs

DECLARE @FileName varchar(150),

...

TommyB and Adam

I've been plugging along at trying to get the code to work and I'm at the stage were I believe I need somemore help. Here is the BCP...

Hi Tommy

I tried your modification and a file got created . No data juet the following

OSQL -E -Q "Select filepath, filetree, filename from ccs.dbo.Work_DBA_Purge"-O

This query will return 47 rows of...

I followed michelle advice and everything worked fine for me.

You said that this is a new database? I'm assuming you created the database on SQLserver2005 but if you populated the...

Hi Lucky

I changed the compactibility level to 90 and now I can see it

in the drop down list. Why I changed it to 70 and not 90 in the first...

Thanks Michelle ...your recommedation was right on the money. 

Success at last. 

John thanks for the help.

I adjusted the memory sizes and the error still continued.

After banging my head on the...

The old server has database using 2780 MB.

The new server only has 745 MB.

Configure info on the old server/new:

I did not do a detach/reattach. I create the database in SQL2000 and did a recovery from a backup.

thanks for the reply

  continue

Error s1000 (10000, 0)intersolv)(ODBC SQL server driver)(Microsoft SQL server) Unable to allocate sufficient memory. Unable to allocate sufficient memory

HI ....

I've increase tne max server memory to 2147483647 but still having a problem.

I also install MDAC 2.8 sp1 - no change

here is the error again in full.