I have a multi-processor AMD x64 bit server with 8GB RAM that is serving as our SQL2000 database server. I have installed SQL Server 2005 32-bit side by side with SQL2000 on several servers and never had any issues.
Now on this server I have installed, side by side with SQL Server 2000, an installation of SQL Server 2005 Evaluation Edition(which is the same as the Enterprise Edition) but in 64-bit. I chose to install all server, services, tools, etc. components. I immediately had problems as instead of the Visual Studio 2005 BIDS installing it installed MS Visual Studio Premier Edition -enu. I say this loosely as I know that they are both really Visual Studio 2005, however the product that installed did not have the SQL Server related projects available (Integration Services project, Analysis Services project, Reporting Services project, etc.) when I clicked on new project. This is an issue as I am at the stage where I need to write several SSIS projects.
I have also read in these forums that it appears that most of the SQL Server 2005 services and tools are 32-bit compiled applications. So I have two options I would like to explore; would it be a better solution to:
(a) reinstall the 64-bit tools and see if the missing projects in BIDS becomes available
(b) uninstall SQL Server 2005 x64 and then reinstall the 64-bit SQL Server engine and then all other components and tools as 32-bit
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
Assuming all the usual rules on creating keys on primary and foreign keys, what recommendations could you give on the minimum number of records required in a table before creating indexes on that table.
For example, I have a table containing calls logged by customers as follows :
I create a sp with call date and/or customer code as parameters. How many records should there be in this table before I create indexes on calldate, customercode or both.
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager. I have remove and reinstalled but it never gets installed. Any ideas?
Hi: I try to install SQL Server 2005 but it gives warning message. My computer configuration is Pentium III 900 HZ, 512 RAM with operating system windows 2000 Pro and service pack 4 and 10 GB free space. It gives warning on operating system. Also Visual Studio. Net 2005 is already installed on my comupter.
- SQL Server Edition Operating System Compatibility (Warning) Messages * SQL Server Edition Operating System Compatibility
* Some components of this edition of SQL Server are not supported on this operating system. For details, see 'Hardware and Software Requirements for Installing SQL Server 2005' in Microsoft SQL Server Books Online.
- Operating System Minimum Level Requirement (Success) Messages * Operating System Minimum Level Requirement
* Check Passed
- Operating System Service Pack Level Requirement. (Success) Messages * Operating System Service Pack Level Requirement.
I have to install SQL Server 2005 on SBS Standard 2003. I am already running Sql Server Desktop Engine with three instances: MSSQL$SHAREPOINT, MSSQL$SBSMONITORING, MSSQL$BLUECOAT. I am wondering how the installation is gonna affect my system. I do need SQL Server 2005 for the new financial software which is intalled 2morrow. What shall I put as the instance during the installation. Is Sql Server Desktop Engine gonna be replaced by SQL Server 2005?
i had downloaded .Net and SQL Server 2005 from microsoft site. In SQL Server 2005 after installation i get only Configuration Tools and 3 subtopics. I am able to create table only through . NET but am not able to work independantly with SQL Server 2005. Can anyone advice me!!
I trying to Install on Windows XP with Service pack 4, OS.
I am trying to install the Developer Edition of SQL Server 2005 version for which it is not able to load many packages as it says IIS services, Integration Services Etc,. were not installed and if they were ignored then rest will be loaded and thereafter I could not either login or invoke either any.
Can anyone suggest me where it went wrong and what I need to do with instructions.
Unfortunately for me, I am not a DBA - even though I have always filled that role where ever I have been. That being said, I have always been fortunate enough to have someone else more knowledgeable than I to perform the initial build of the SQL Servers I have used and managed. So, I have the following question...
I just finished installing and configuring a new dedicated SQL Server (it is nice too). One of the included discs it he MSDN Library. Do I need to install that too? Is there any reason to or not to install it? I would appreciate any feedback.
Hi, SQL Server 2005 has been installed on windows server 2003 machine by the support team. Microsoft SQL Server Management Studio 9.00.3042.00 Now this machine has been passed on to me to create databases, tables, etc... On this server, I open the management studio and I get the connect to server windows. What should the entries in the connect to server window be for me to get to the next stage where I can start building databases. At present, I tried local or localhost and windows/sql authentication. Still can not get to the management studio window. Any thoughts please? Thanks
I have a couple of questions reagrding SQL Server 2005 SP2?
1) Do I need to install SP1 and its accumulative hotfixes before applying SP2??
2) Anyone know what is SQL Server 2005 V 9.0.3033?? I saw it in a couple of SQL 2005 servers that suppose to have SP2 installed. I thought SP2's version is 3042??
We have the Windows server 2003 R2 Service PAck 2 , we got updated to this version after i installed automatic updates today,and i am having problems with setting up maintenance plan in SQL server 2005 (9.0.1399)
Hence i am trying to install Sql server 2005 SP1, but the read me file says that this installation is compatible only with Windows server 2003 SP1
Also, i received this error when i tried to install SQL server 2005 SP1 yesterday
"The image file hotfix.exe is valid, but is for a machine type other than the current machine"
I am confused, Can someone help me out in this regard?
I'm trying to re-install the ms sql server 2005 but I keep getting the following message:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. ------------------------------
This is my second time installing the ms sql server. I couldn't create a new database connection using odbc, I constantly got error messages so i decided to install it with windows and sql authentication (earlier i installed it only with windows authentication).
Hello Experts,I have a Windows Server 2003 For Small Business Server SP 2. Is it possible to install SQL Server 2005 on Windows Server 2003? I am intending to switch to SQL Server 2005 from SQL Server 2000 (on Windows Server 2000).Please advice. Thanks in advance.Regards,Suman Ghosh
I have just purchased SQL Server 2005 and a new Dell 2800 server to run it on. I was told by my Dell rep to configure the server with the following drives. 2 - 36GB drives in a RAID 0 (15,000 RPM), 2 - 73GB drives in a RAID 0 (10,000 RPM) and 3 - 146GB drives in a RAID 5 (10,000 RPM). Dell pre-installed the OS on the 36GB drive. I was told to install SQL on the 73GB drives and the data (primarily TIFF images) on the 146GB. The server is a 64bit machine with Windows 2003 Server and 4GB of RAM. I was told to put the transaction logs on a different physical drive that the database to speed the writes. Is this a correct installation? Is there any information on a best practice installation? I have spent about 6 hours on MS and Google trying to find an answer. Thanks for any help you can give. Recap of Dell recommendation:
2 - 36GB Mirrored Drives = OS 2 - 73BG Mirrored Drives = SQL Server 2005 3 - 146GB RAID 5 Drives = Data (Images)
Is this correct? Where should the Transaction Logs Be?
While installing Microsoft SQL Server 2005 Express Edition the installation did not complete because of WMI configuation of my system. Can somebody help!
I have sql server 2000 on my PC. If I want to upgrade to SQL Server 2005 should I have to uninstall the Sql server 2000 and install Sql server 2005. Or can i install the sql server 2005 directly.
HI All, After i installed SQL Server 2005 workgroups edition to my Laptop, P4 and 1 Giga memory. I had a problem. my problem is: when i start my laptop need 4 minutes to start the windows xp pro edition. then I format my laptop and install the windows again, and every thing works fine, but I installed the SQL again and i had same problem with windows startup, there is nothing related to SQL in ;msconfig utilities. do you have any tip about this problem ? Thank You
Hi, I am new to the whole ASP and SQL data base and have a basic question.I installed visual studio 2008 and SQL server 2005 developer edition in my computer. However it seems like the SQL installation is not installing all the components I need. I tried to reinstall it again and the only thing it installs is the "configurations tools". Below is a screen shot of my installation.Is this correct? How to a get the other tools installed? thx in advance,
Hey guys - I am busy testing SQL 2005 Server Unattended installations and have a quick question. Microsoft specifies the following code for command line installation:
Start /wait <CD or DVD Drive>serverssetup.exe /qb INSTANCENAME=<InstanceName> ADDLOCAL=All PIDKEY=<pidkey value with no "-"> SAPWD=<StrongPassword>
Here is a link to the installation pages: Click Here (http://msdn2.microsoft.com/en-us/library/ms144259.aspx) My question is what are all the different accounts for? Any help will be appreciated. Thanks Reghardt
I am having problems installing SP1 successfully. So far I've tried it on two separate Windows 2003 server boxes running SQL Server 2005 Standard v9.0.1399.
The first upgraded successfully all over services except the SQL server itself. Reporting services then failed due to database version mismatch but that was easily fixed. The other box doesn't have anything other than SQL2005 and components were upgraded but the database upgrade failed. I got the generic "send this error to microsoft" message.
I've tried other suggested fixes on this board but none have worked so far.
The Logfile seems to go haywire at about this point:
Bootstrapsetup.exe === MSI (c) (88:78) [10:24:26:828]: Resetting cached policy values MSI (c) (88:78) [10:24:26:828]: Machine policy value 'Debug' is 0 MSI (c) (88:78) [10:24:26:828]: ******* RunEngine: ******* Product: F:ServersSetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (c) (88:78) [10:24:26:828]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (88:78) [10:24:26:828]: Grabbed execution mutex. MSI (c) (88:78) [10:24:26:828]: Cloaking enabled. MSI (c) (88:78) [10:24:26:828]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (88:78) [10:24:26:828]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (7C:94) [10:24:26:843]: Grabbed execution mutex. MSI (s) (7C:54) [10:24:26:843]: Resetting cached policy values MSI (s) (7C:54) [10:24:26:843]: Machine policy value 'Debug' is 0 MSI (s) (7C:54) [10:24:26:843]: ******* RunEngine: ******* Product: F:ServersSetupSqlRun_SQL.msi ******* Action: ******* CommandLine: ********** MSI (s) (7C:54) [10:24:26:843]: Note: 1: 2203 2: F:ServersSetupSqlRun_SQL.msi 3: -2147287010 MSI (s) (7C:54) [10:24:26:843]: MainEngineThread is returning 1620 MSI (c) (88:78) [10:24:26:843]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (88:78) [10:24:26:843]: MainEngineThread is returning 1620 === Verbose logging stopped: 3/27/2008 10:24:26 ===
SUMMARY.txt (C:Program FilesMicrosoft SQL Server90Setup BootstrapLOG) has follwing contents...
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Thu Mar 27 09:57:45 2008
Machine : ADITYA Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_OWC11_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_BackwardsCompat_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_MSXML6_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_OWC11_2.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_BackwardsCompat_2.log -------------------------------------------------------------------------------- Machine : ADITYA Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_MSXML6_2.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLSupport_3.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_OWC11_3.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_BackwardsCompat_3.log -------------------------------------------------------------------------------- Machine : ADITYA Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_MSXML6_3.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLSupport_4.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_OWC11_4.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_BackwardsCompat_4.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLSupport_5.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLNCLI_3.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_OWC11_5.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_BackwardsCompat_5.log -------------------------------------------------------------------------------- Machine : ADITYA Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_MSXML6_4.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLSupport_6.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLNCLI_4.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft Visual Studio 2005 Premier Partner Edition - ENU Product Version : 8.0.50727.42 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_PPESku_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_OWC11_6.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Books Online (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_BOL_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_BackwardsCompat_6.log -------------------------------------------------------------------------------- Machine : ADITYA Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_MSXML6_5.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Integration Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_DTS.log -------------------------------------------------------------------------------- Machine : ADITYA Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLXML4_1.log -------------------------------------------------------------------------------- Machine : ADITYA Product : SQLXML4 Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_SQLXML4_2.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Analysis Services Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_AS.log -------------------------------------------------------------------------------- Machine : ADITYA Product : Microsoft SQL Server 2005 Notification Services Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_ADITYA_NS.log Error Number : 1602 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
While installing sql server express 2005 get an error message install latest version using sqlnci.msi . Please let me know from where i can find or download sqlnci.msi
This error comes while installing native client option
I received the following error when installing SQL Server 2005: The setup has encountered an unexpected error while Installing performance counters. The error is: -1073741790
I have never used SQL Server, except that I did use MS Access, so after I downloading and installing the SQL Server Express 2005 ... I really do not know how to make it works!
1. Let say I would like to create a table at my local computer (1st) as a Server, how I do it (configuration)?
2. Then I have a second PC, as a client how I link to that table?
Might be they are 2 silly questions, but I would like to try out the new SQL Server Express and compare what are the better features with MS Access!
Ok the problem is that i have sql 2000 in a computer with windows 2000 professional sp4. i'm trying to install the sql server 2005 in other instance. When the installation begins i don't have any problem, but when it ends, y try to enter to the manage studio and is not in the start menu. Sql 2000 is ok but i can't work in 2005 i reinstall both versions but the problem persist. I delete all the files in the instalation but when i install it again the problem apperas again. how can i install both versions?
When i run sql server 2005 sp1 setup, during setup it authenticates everything except Database engine and reporting services. I m running this setup with administrative previliges.....can any one help?????
I received this error on upgrade installation from SQL 2000 Standard to SQL 2005 Standard. It doesn't seem to be causing any problems after install but I am currently not using Notification Services in any production capacity.
Errors:
----------------------------- Microsoft SQL Server 2005 Setup ------------------------------
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2147024893 Error message: The system cannot find the path specified. Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the path specified.
------------------------------ Microsoft SQL Server 2005 Setup ------------------------------
Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024893 Error message: The system cannot find the path specified. Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the path specified.
Any help would be greatly appreciated. Thanks, Keith
