Read about sp_delete_log_shipping_secondary at http://msdn.microsoft.com/en-us/library/aa933265(SQL.80).aspx

MJ

Client tools/workstation components.

MJ

Yes, it is possible as DBCC SHRINKFILE is logging database file page movement information in log file.

MJ

The recommended default path in Windows 2000 and later is %SystemRoot%\Cluster. For example, C:\WinNT\Cluster\Cluster.log.

MJ

Evict a node from the cluster:

http://technet.microsoft.com/en-us/library/cc784955.aspx

MJ

Please check sql server error logs and eent viwer logs for any error messages.

MJ

SELECT a.* FROM OPENROWSET('SQLOLEDB',

'DRIVER={SQL Server};SERVER=.\yukon1;Trusted_Connection=yes;',

'select @@servername') AS a

MJ

Try:

Create procedure USP_DelOldFiles @path varchar(25),@duration int

as

--Objective: To delete files older than certain period from a folder

--Usage example:

--Exec USP_DelOldFiles 'c:\test',30 -- which deletes files older than todaydate-30

--Created by :MAK

--Created date:...

Execute the code mentioned below and paste the output here:

use DBName

go

sp_change_users_login 'report'

MJ

Profile the statements(using profiler) executed by the application when it runs the update code and see what all gets executed apart from this(any other statement due to presence of triggers).

MJ

If you are going with active/active cluster then need to run setup on both the nodes individually.

If active/passive then need to run setup on primary node only. Rest about...

Check-->http://support.microsoft.com/default.aspx/kb/288745

HTH!

MJ

select table_name,column_name from information_schema.columns

where column_name='ColumnNameHere'

MJ

Grant ALTER SCHEMA on the schema(s) that the developers need to modify stored procedures in to the role. Add the developers to this newly created role.

MJ

As suggested in error message try running DBCC CHECKDB on the database in question and see if it gives any errors.

MJ