Hi Randolph,

I had the same problem a while ago. Check out this link:

http://support.microsoft.com/?id=906954

Running   instcat.sql which is included in SP4 for SQL 2000 solves the problem.

Markus

markus,

 Actually it's not the only report which doesn't work, but what I've seen so far all of them are fixed in SP2.

MarkusB

Nomi,

Database mail can only be configured using a SMTP server for outgoing mail. From the error messages it looks to like either the server doesn't exists or can't be reached...

Martin,

the "real" error messages for maintenance plans can be found in the log files. Usually they should be in the default log directory for your SQL Server instance.

Markus

James,

have you tried SQL Profiler ?

Markus

Rs

it would help a lot easier to help if you could be clearer about what kind of problems you have. Any error messages?

Maybe this helps http://msdn2.microsoft.com/en-us/library/ms175535.aspx

Markus

As long as SQL server service is not starting you cannot restore the backup. So you will need to rebuild the system database. See BOL for the exact syntax.

Be aware...

Can't tell what the "industry standard" here in the Netherlands is, but as a contractor I come in contact with quite a lot of companies and I would say that...

Almost good just one thing missing

grant alter trace TO [domain\username]

Markus

Lezza,

open SQL Server Configuration Manager, SQL Server Services and right click the SQL Server(MSSQLSERVER). Open properties and go the advanced tab. Under Startup Parameters replace the default errorlog path -eC:\Program...

Michael,

try select * from msdb.dbo.sysdtspackages90

I admit it's mostly very cryptic but you can get at least the create...

The Lock request time out is set from the client application in your case EM. Opening Enterprise Manager, Management, Current Activity, Process Info actually executes a series of stored procedures...

The only feature which needs IIS (and ASP.net) is Reporting Services. It has actually nothing to do with web access. If you have no plans of using this you can...

I don't know if it's by design are simply a bug, but the toolbox stays gray in my case too. Anyway if I drag and drop a task to the...

Hans

are you sure your looking in the right place in SSMS? Triggers on tables are listed under DatabaseName>Tables>TableName>Triggers

while Database Triggers are listed under DataBasename>Programability>DatabaseTriggers.

Markus