Viewing 15 posts - 2,101 through 2,115 (of 2,387 total)
Someone has similar problem and here is the link.
March 24, 2003 at 11:39 am
SQL Server trace has confirmed the deletion of single history line from EM touches table 'sysdbmaintplan_history' only. I can't think anything else need to access/use this table.
March 24, 2003 at 10:07 am
I had similar error on one of SQL SErver 7.0 machine, What patch you are referring to?
March 24, 2003 at 9:18 am
I don't think the alert can be fired before SQL Server recovery processes complete. You may write a script either to search event log error 17052 or SQL Server errorlog...
March 24, 2003 at 9:15 am
Suggest to review machine application and system logs why SQLServerAgent service was unable to start under local system account.
March 24, 2003 at 8:00 am
Goto service to verify which account is used to start MSSQLServer and SQLServerAgent services.
USE master
go
EXEC sp_grantlogin 'NT Authority\System'
go
EXEC sp_addsrvrolemember 'NT Authority\System', 'sysadmin'
go
Edited by - Allen_Cui on 03/24/2003 07:33:46 AM
March 24, 2003 at 7:28 am
Double click your maintenance plan --> Reporting Tab --> Check 'Write report to a text file' option to log the execution of the maintance plan job. Review the log file...
March 24, 2003 at 7:21 am
Did you receive this error from specific client machine? What is the MDAC version in client?
March 22, 2003 at 12:26 pm
What privileges the network account have both in SQL Server and in your domain?
March 22, 2003 at 12:19 pm
Did you remove BUILTIN\Administrators login from SQL Server? Which account do you use to run SQL Server and Agent services?
I believe SQL Server Agentg is running by local system account....
March 21, 2003 at 3:39 pm
If you simply renamed the database files to make database suspect and restart SQL Server, you should see some kind of error like 'Device activation error or FCB::Open failed' without...
March 21, 2003 at 2:40 pm
Double click your maintenance plan --> Reporting Tab --> Check 'Write report to a text file' option to log the execution of the maintance plan job. Review the log...
March 21, 2003 at 2:29 pm
When you mentioned message in event log, Are you referring to machine application/system logs or SQL Server Errorlog?
In order for alert to fire, Message with Severity: 23 has to be...
March 21, 2003 at 1:37 pm
Right click your SQL Server --> Properties --> Security Tab --> Make sure Authentication is 'SQL Server and Windows' is selectd.
Try use QA to login to SQL Server to confirm...
March 21, 2003 at 1:11 pm
Viewing 15 posts - 2,101 through 2,115 (of 2,387 total)