I'm yet to use this version

MSreplication_subscriptions

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

I might have even confused myself. I think that a DENY should always take precedence over any other permissions.

However I think fixed server roles will override database level permissions....

Is the user in any database roles eg.db_datawriter or fixed server roles that could be overriding this?

Powershell is also pretty good for these sorts of tasks. You can easily write some scripts which will loop through a list of servers to find all this information and...

This question is pretty poorly worded...

"we setup the Transactional replication from ABC to ABC\first" - from this it sounds like ABC is just a default instance as no instance is...

You can also create a database snapshot on the mirror to avoid failover - if you're on Ent or Dev edition.

I can find the description of all my reports in SSRS 2005 via dbo.Catalog.Description

Params can be extracted from the parameters column.

Another option is an SSIS package or some powershell to...

Have you thought of querying the ReportServer database?

look in dbo.Catalog & dbo.DataSource for the info you need.

D

RAID 10 for your data looks good.

RAID 0 has no redundancy - so if a disk goes pop (they eventually will), you will lose the database as it contains the...

Have you tried it with the @updateusage option? Sometimes when an index is dropped, the space stats can be out.

eg.

USE AdventureWorks;

GO

EXEC sp_spaceused @updateusage = N'TRUE';

GO

Have a look at Application Roles in books online. These should allow you to control what applications are connecting through.

Before your cluster goes live, it is worth running the SQL Stress IO Sim from MS to get some bench mark figures. It provides most of those stats to check...

I'm not too sure why they are suggesting 3rd party products when SQL 2005 has quite a lot DR capabilities built in.

Some good reads...

Clustering - (thx Brad)- http://www.sql-server-performance.com/articles/clustering/cluster_sql_server_2005_p1.aspx

Mirroring...

Windows clustering will take care of the heartbeat - generally you will run a crossover cable between the 2 nodes for private cluster traffic. Your application is unaware of which...