I agree with Philip, non of the given answers is correct.

The question explicitly says 2005 or higher, but the result on a 2005 server is different from a 2008 server.

You postd this in the SQL server 2005 forum, but if you have any SSIS 2008 available you could use the data profiling task to get this information.

Here's a short...

Check out DB Visualizer (http://www.dbvis.com/).

It's especially usefull when you need to manage different database systems other than SQL Server.

They have a (limited) free version if you...

Saga... (10/20/2011)

george sibbald (10/20/2011)

so he does.

The ops...

I just noticed that the OP wants to migrate maintenance plans from SQL 2000 to 2008. So SSIS isn't an option after all.

But in case you want to try between...

There is no limit other than the availbale storage space.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

You have to export them through SSIS and the import on your target server(s)

Roger,

from your description I can't really tell what's wrong, but there are a couple of easier ways I think to resolve this issue. First of all you could add your...

Gary,

this is a browser feature, not specific to IE but also others you can't control that from your report. Maybe if you only have internal users there's a possibility to...

All that info is in the reportserver database:

USE reportserver

SELECT Name, ModifiedDate, UserName

FROM dbo.Catalog C

JOIN dbo.Users U

ON C.ModifiedById = U.UserID

ORDER BY ModifiedDate

If you're still using SSRS 2005, that's not possible. In case you have SSRS 2008 (with or without R2) it is. Here's a good blog on how to do it:

This could be caused by a lot of different causes, but the first thing to check in case of a named instance is if the SQL Browser service is started.

SSRS is not cluster-aware.

You can place the databases on a clustered instance, but the reporting services itself will only run on one of the nodes. In case you want...

Yes that is possible. Depending on the events you want to monitor look for DDL triggers http://msdn.microsoft.com/en-us/library/ms186406(v=SQL.90).aspx

or Event Notifications http://msdn.microsoft.com/en-us/library/ms175854(v=SQL.90).aspx

You can do that by connecting to your SSRS instance from management studio.

Expand the Security section and either add a new role or customize one of the existing ones.

With...