| 2. |
Start the Support Administrator Console, Microsoft SQL Query Analyzer, or SQL Server Management Studio. To do this, use one of the following methods depending on the program that you are using.
Method 1: For SQL Server Desktop Engine
If you are using SQL Server Desktop Engine (also known as MSDE 2000), start the Support Administrator Console. To do this, click Start , point to All Programs , point to Microsoft Administrator Console , and then click Support Administrator Console .
Method 2: For SQL Server 2000
If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start , point to All Programs , point to Microsoft SQL Server , and then click Query Analyzer .
Method 3: For SQL Server 2005
If you are using SQL Server 2005, start SQL Server Management Studio. To do this, click Start , point to All Programs , point to Microsoft SQL Server 2005 , and then click SQL Server Management Studio . |
| 3. |
Run the following statement against the DYNAMICS database to insert the missing records into the ALERT3RD table from the Alert3rd.out file.
/* start of fix script */
Use DYNAMICS
truncate table ALERT3RD
bulk insert ALERT3RD
from 'C:\Program Files\Microsoft Dynamics\GP\SQL\Install\309\System\Data\ALERT3RD.OUT'
with
( DATAFILETYPE = 'char'
, ROWTERMINATOR = '#EOR#\n'
, FIELDTERMINATOR = '||'
)
/* end of fix script */
Note By default, the Alert3rd.out file is in following location:
C:\Program Files\Microsoft Dynamics\GP\SQL\Install\309\System\Data\Alert3rd.out
If the Alert3rd.out file is in a different location, change the script to use the correct location. |