Jim Lawrence
accessd at shaw.ca
Thu Nov 2 12:17:59 CST 2006
Well that was fast John... Not as tough as you initially thought, eh??? Maybe this might help: http://sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk Regards Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of JWColby Sent: Thursday, November 02, 2006 9:55 AM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Installing SBS2003 - was What is going on SBS is installed dual boot to XP. SBS is the default in the dual boot menu. SBS seems to run just fine. It is giving me a message "at least one service didn't start" which I still have to investigate. Server 2003 appears to have at least one advantage over XP, which is that it supposedly can really use all of 4 gb (the max I can currently install on this MB). If that is true I will also order another 2g of RAM for this machine since it is up to it's eyeballs in a huge database. I did install all of that remote access stuff. It had terminal admin checked I think. As for actually getting past the firewalls... We shall see. I am in the XP system now detaching the database from SQL Server there. Rebooting into 2003 to attach there. Is there any way to get a status from SQL Server re progress when it is doing something like a shrink operation, building a new field or index etc? Any way to tell how much is done, how long remaining etc? John W. Colby Colby Consulting www.ColbyConsulting.com