When DBCC SHRINKFILE is run, SQL Server 2000 shrinks the log file by removing as many virtual log files as it can to attempt to reach the target size. If the target file size is not reached, SQL Server places dummy log entries in the last virtual log file until the virtual log is filled and moves the head of the log to the beginning of the file. The following actions are then required to complete the shrinking of the transaction log:
After stopping and restarting MSSQLSERVER service, eCM cannot connect and receives error message [Microsoft][ODBC SQL Server Driver]Communication link failure. The logical solution would be to stop and start vcs server service after MSSQLSERVER has been restarted. Unfortunately, this is not always appropriate and can be extremely bothersome if SQL is shut down on a daily basis.
Receiving error message that VCS_Server fails on automatic startup after a system re-boot. The message refers to a SQL server communication error. Possible problems may be that the SQL service has not yet started or the vcs server is depending on other services to be already started.
After upgrading from previous versions to 5.2.0, customer needs to run the following script against eChange Man database in SQL Server . UPDATE vcs03 SET file_type = 0 WHERE home_path NOT LIKE '%.%.%' AND file_type = -1
This error ocurs when running a Implementation script using CMNAREA The full error is 1: [Microsoft][ODBC SQL Server Driver][ SQL Server ] Violation of PRIMARY KEY constraint 'PK_vcs24'. Cannot insert duplicate key in object 'vcs24'.
The work around to display current date in combo box using SQL query. We can use getDate() function of SQL Server in SQL query like "SELECT getDate() AS CurrentDate".
