Thanks Gail, so finally here is my code :-

DECLARE @tbl TABLE (acntname VARCHAR(800), Permisson VARCHAR(800))

SET NOCOUNT ON

DECLARE @C VARCHAR(800), @p VARCHAR(800), @cNext VARCHAR(800), @pNext VARCHAR(40)

DECLARE c CURSOR FOR

...

Thanks Gail. But till date, I am not able to figure out the script writing using CTE.

Need help with this code please.

Basically we have users who are up at all times and there is an ETL process from 2am to 5am that needs to run that is crashing because users are...

I wanted to know that did you too faced the same error (i.e. upgrade process didn't update the MSSQLSystemResource files on some instance & you were not able to restart...

you need to install SP1 on all instance.

When you will run setup, it will ask the instance name.

so you mean everyday table will be dropped and re-created?

If yes, then

In your SSIS,...

Its about the point where you planning to change the isolation level to read uncommited.

you can use query hint " with nolock" in your select queries.

Not sure if I understood your requirement correctly, but is this query not helping

select col1,col2,date from tblname order by date desc/asc

Thanks Gail and all.

ok, so then how sql come to know while restoring the database that it need to add the specific amount of free space in database files and as exact of...

thanks. If that is the case then when we restored the database why our mdf and ldf comes with same size including free space.

yes. So that msdtc can maintain the database in consistent state during failover.

1 for msdtc

1 for virtual name

2 private ip for healthcheck for 2 server

2 public ip (optional)

if its a virtual machine, then take ghost copy and you are good to go.

Just make sure the disk are configured in the same way as it is in...