Osql and CommandLine stored procedures

I'm currently developing a number of SQL scripts to handle a major upgrade of our database from a development server to a production server using Osql.

Everything is working fine, but I have each of the scripts generating text-output and am hoping someone may know how to suppress some the Caution text (specifically triggered when a column has been renamed).

Can anyone provide a possible solution? (there's so many notes being written to the console its easy to miss the errors I'm concerned about.

Thanks!

TedNot that I am aware of. You might try SET ANSI_WARNINGS OFF but that will not suppress the types of warnings to which you are referring.

Terri

OS requirements.

I am considering buying a new home PC but want to make sure it can handle SQL 2005. Most of what Im looking at comes with XP Home edition. I found this:

http://www.microsoft.com/sql/editions/developer/sysreqs.mspx

but it doesnt specifically say Home edition, and I dont want to purchase without knowing this first. Does anyone know a link that would specify this?

TIA, cfrI was considering buying a new pc for myself, but decided to wait for about 6 - 9 more months. Just a couple of reasons why.

1. Windows Vista will come pre-installed, save yourself some $$
2. Windows Vista is 64-bit compatible, so make sure you get a 64-bit processor. Even though a lot of apps don't run at 64-bit and thus don't really benefit from it, it is still good if your OS is running as fast as possible.
3. Windows Vista supports and adds security (http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx)to SQL Server 2005

Just some thoughts.
Hope it helps|||Does anyone else happen to know about XP Home? Media Center?