Viewing 15 posts - 2,146 through 2,160 (of 2,387 total)
I remembered there is a log file that will tell you which files are being locked. Try shutdown all SQL Server instances before apply it.
March 10, 2003 at 9:37 am
I guess you have registered SQL Server with NT authentication from EM. Change it to SQL Server authentication should work, at least it works for me when Access database is...
March 10, 2003 at 8:07 am
Check with them how do they perform online open file/database backup and ensure their solution is supported by Microsoft. I understand they use open file manager (OFM) to temporarily take...
March 8, 2003 at 10:41 am
Your table is not that large as you image. As long as the table has beeb designed and indexed properly, you shouldn't see performance issues. If you have suspicion on...
March 7, 2003 at 1:34 pm
Try to reset the proxy account from the job system tab of SQL Server Agent Properties.
March 7, 2003 at 12:30 pm
Execute permissions for xp_sqlagent_proxy_account default to members of the sysadmin fixed server role.
Make sure the login you used is able to access SQL Server with 'sa' privilege.
March 7, 2003 at 12:25 pm
No ideas. You should have sqlsp.log in c:\winnt directory and it will give some indication about service pack's installtion.
March 7, 2003 at 10:07 am
I don't think so. Go to http://www.microsoft.com/sql to download SP3 and reinstall it.
Read the readme file carefully before start the installation.
Edited by - Allen_Cui on 03/07/2003 09:07:44 AM
March 7, 2003 at 8:56 am
sqlstp.log is the log file for original SQL Server installation. You should look for sqlsp.log.
March 7, 2003 at 8:39 am
Was the SP3 installation successful? Review the sqlsp.log to see any errors in c:\winnt directory.
March 7, 2003 at 7:38 am
You are not running SQL Server SP3. Instead, You are running SQL Server without any service pack. This could expose your SQL Server with slammer Worm virus attack.
Do you still...
March 6, 2003 at 1:56 pm
If you are in SQL Server SP3, you should see 'Microsoft SQL Server 2000 - 8.00.760' in the result of select @@version
March 6, 2003 at 1:27 pm
You have to download the newest MDAC component checker to verify the MDAC version.
Can you post the result of select @@version?
Edited by - Allen_Cui on 03/06/2003 1:03:00 PM
March 6, 2003 at 1:01 pm
SP3 has installed MDAC 2.7 SP1 so you should not install MDAC 2.6. Try to reinstall MDAC 2.7 SP1 to see whether your problems could be fixed.
March 6, 2003 at 12:43 pm
Viewing 15 posts - 2,146 through 2,160 (of 2,387 total)