Nice question .. thought Provoking and had to try a number of times.

As far as I remember you will be able to do this from Cluster Administrator in Windows.

As far as I remember (i dont have access to a cluster now) we...

sorry post/expectation does not make any sense.

may be there is a reason, but why create table for last run and where do you want to create it?

this is from one of my previous posts

For DB:

Option 1: If Downtime is permitted and db is of medium size --> put source DB in read only mode -->...

it depends on the types of data you will store.

In the example provided - agreed there is no performance implication.

however if the data stored in the...

sp_who2 returns

SPID --> which is the process under consideration

BLK --> if it has a value represents the SPID of the blocking process

Ex. SPID =10 BLK=51 --> Process...

requirements are not clear - how do you insert/update thur a SPROC or DTS or some other means.

Clarify requirements so we can provide directions

I looked at http://msdn.microsoft.com/en-us/library/ms175515.aspx too,

i'm not sure if just reducing the activity will help - because of the statment - "Regardless of system activity, running DBCC...

The default config for various options is available

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

It is best to reset to the original config after the work on index view is done

is it possible for you to post what the expected output is suppose to be. That will help with resolution

The following query will give an idea of why len is returning 12 and how to get it to return 9.

select len('123456789 ') IfVarchar, (cast(cast('123456789 ' as float) as varchar))...

Hello since the request format is not a standard we will have to manipulate.

The query below provides the format requested

select getdate(),

cast(datepart(dd,getdate()) as varchar) + '-'+ left(convert(char(12),getdate(),9),3) +'-'+ cast(datepart(yyyy,getdate()) as...

For DB:

Option 1: If Downtime is permitted and db is of medium size --> put source DB in read only mode --> Full backup and restore on new server.

Option...

understaning your data is quite difficult - its not clear. can you provide better data and expected output?