I am facing the same issue on SSRs2008 installation. Can someone please shed some light on its resolution?

Thanks in advance.

Manu

I think read/write access to shared location is must.

Manu

Do you get any row in output if you execute select * from master.sys.database_mirroring_witnesses?

MJ

Have you tried the workarounds mentioned in link below.

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/aa98c62c-bda4-4dfa-bec9-690afbb5951a/

HTH!

Manu

Did you check http://connect.microsoft.com/SQLServer/feedback/details/126163/maintenace-plan-integrity-checks-fail-with-alter-failed-for-server-xxx

Check the "Automatically set I/O affinity mask for all processors" in your server properties. We had unselected this to reduce processors for licensing, and the...

Turn on trace flags for deadlock and check the deadlock grph or run both the statements and turn on profier for deadlock events in background.

This will enable you to analyse...

I don't think there is a direct command to open it in that case. You might need to take help of some external tools like --> http://dts-documentation-generator-for-sql-server-2000.soft32.com/free-download

Although I...

Thanks for sharing the script Jeff and a superb suggestion.

Manu

In that case you need to script out ur roles and check for object level access.

You can certainly change the collation of a single database.

USE master;

GO

CREATE DATABASE testdb

COLLATE SQL_Latin1_General_CP1_CI_AS ;

GO

ALTER DATABASE testDB

COLLATE French_CI_AI ;

GO

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

You can make use of command prompt for it:

start /wait Path of setup.exe /qb VS=Virtual Server name INSTANCENAME=MSSQLSERVER ADDLOCAL=SQL_FullText GROUP=Fulltextgroupname IP='IP Address' ADMINPASSWORD='Password' SAPWD='SAPassword' INSTALLSQLDIR='directory path' INSTALLSQLDATADIR='Data Folder path'...

Check the execution plan of the stored procedure

Nope, you cann't as full backup of the same database whose diff/log backup is there with you now is required.

HTH!

MJ

Thanks Michael. Info. provided by you helped me too:)

Manu

Do you know the tablename? If not, then you might need to make use of sys.columns and sys.tables information for constructing the query.