quick google image search:

http://www.microsoft.com/mspress/books/sampchap/4713/0753611424-3.gif

I found the answer. Start SSMS, server type Analysis Services. right click on the SERVER, then click Properties. Modify the DATADIR property to the location you want...

I guess the first thing I would do, since it appears you do not care about the log files, would be to put the database in simple mode. 

This gave me a good start - I use the sp_msforeachdb and foreachtable quite often.  in this case, this statement does not work because the part inside the quotes is...

What is the error that you are getting?  what is the process you are using for BCP?

Okay - I have a followup question.  I know there is a compatibility mode between versions - how about a way to run in standard edition compatibility mode. ...

I ran this as well on one of my servers, nearly all of my DB's have more than one datafile, and I got one datafile to come back as well. ...

What about

sp_msforeachdb "?..sp_helpfile"

That would give you the results for every db on that server.

Thanks all

I did not think there was either, and I have the list, and have instructed the developer to try and understand what set of tools they are using.  I...

I found the following link - which may help someone in the future...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_2xtf.asp

Thanks all for your help!

I found this in the BOL:

Upgrading From One Edition to Another

These are the supported upgrade paths between the editions and versions of SQL Server 2000:

• SQL Server 2000 Personal...

Well - what is in master that I need?  does it just sotre DB locations and such?  so, really, msdb contains the users and schedules?

So, can someone tell me if...

What about Master and MSDB?  I need the user information as well as the jobs, the schedule, and such.  Can I simply dettach those and re-attach?

*****************************************

Cory - can you give a URL to the information you quoted? Books Online states 2^31-1 bytes as maximum length for VARCHAR(MAX): http://msdn2.microsoft.com/en-us/library/ms176089(en-US,SQL.90).aspx.

*****************************************

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dataacc9/html/4a58b05c-8848-44bb-8704-f9f409efa5af.htm

I looked in help, and this is what I found for SQL Server 2005 varchar(max):

SQL Server 2005 introduces a max specifier for varchar, nvarchar and varbinary data types to allow...