while waiting for user confirmation on the data type length ,  I has some idea how to convert this while loop, but I need help to confirm on the joining...

Thanks Thom.

The typo is fixed  .

All the (Max) data type will  be reviewed with the users once the while loop  logic have been converted and tested .  I can use the...

It means the IX locks that requested by the update process is not successful because the same page is owned by the select process . and the select operation is...

There are actually index created :

CREATE NONCLUSTERED INDEX [IDX_TXN_DESP_OUT_STATUS] ON [dbo].[TXN_DESP_OUT]

(

[DESP_STATUS] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF,...

The blocking occur intermittent

i have also set sp_configure 'blocked process threshold', 10. .

and when the blocking happened , i try to select other rows in the config table ,...

Unfortunately , the blocking happened again . and blocked process report capture nothing . I run the SOL SEVER report- activity -all blocking transaction during the...

Well. i manage to sort out the issues .

When i Disabled the SQL SERVER BROWSER services. it have a "Active" option in the SSCM - SQL SERVER BROWSER -...

I have try to ping from other pc machine in the same domain, and I still see ABC in the list of sqlcmd -L.

i try to remove all the SQL...

I cannot connect to that ABC instance , it only have one instance in the server .

I have checked from the services.msc , it only have one SQL INSTANCE which...

Is your own domain account have a domain admin rights ? or own local administrator rights in both of the cluster node ?

So, should i say when running the DBCC SHRINKFILE , if sum(all type of objects virtual memory committed) larger then 2GB, the error should be generated ?

why i need...

I will try to locate a 64bit sql server with 2 TB disk space available before i can restore the database over there . It will take sometime .

Is there...

I have not implement /3GB . only /PAE and AWE is configured.

Query Output :

physical_memory in bytes ...

I do some slightly changes in the Min and Max memory . I set both the min memory and max memory to 12 GB.

This time , i can see the...

I have try both DBCC SHRINKDB or SHRINKFILE no trucate and truncate. No luck, still the same error.

Continue on my troubleshooting, i restart the sql service and run the...