Hi

correct below condition considering points aspects.

1. If you already have (a) a covering index/clustered index on gv.VoucherNo, gvs.VoucherStatus or (b) the table is very small then

use two exist() with...

Go to SQL Server Agent > Proxies and check each container there if one has a proxy account set there. find and change the password. To fix it permanently, use...

import of data from csv works based on delimeter or fixed length.

Adress the delimeter before you import.

Next define and format the data as needed.

select Customers.idCustomers , count(*)

from Customers

INNER JOIN Meters ON Customers.idCustomers = Meters.Customers_idCustomers

group by Customers.idCustomers having count(*)>1

probably you can write a procedure to delete records based on existing eclustered index using a smaller transaction. Will be slower but will avoid deadlock.

I guess there are two workaround for this.

1. exchange the clustered index. make clustered index on the column Internal_name.

or

2. use tablelock hint to avoid deadlock

by the way, what is fragmentation...

What is error message? I assume you considered the agent account and it's access on the target sql server.

Please restart browser service and then check.

Note: Assuming here is no new security/firewal rules applied between client and server.

Login to the server using SQL Agent account. Open the outlook default profile and save.

Ensure that you are using the same profile in SQL Mail property.

Now let the job run...

I do not know what is your exact requirement, however, this piece of code may help you.

declare @from varchar(50) , @to varchar(50)

select @from = 'APR0111OFR_AAAAAAAA_01'

select @to = stuff(@from,2,2, lower(substring(@from,2,2)))

Print @to

-----

Seraj...

If you want a workaround, here it is.

Add a column Filler char(4000). you said there are few rows, should not be overhead.

create clusterd index on Reque_pa(CEREQ).

Enjoy!

Sreaj Alam

SQL DBA, HCL Technologies.

If the disk is performing normally and the query is similar that were used earlier for benchmarking, I do not see any solid reason. However, can you check if you...

Hi,

Did you run "sp_spaceused @updateusage= 'true'"? Hope it fixes.

Alternately, pl try below;

Create a filegroup and aleter table to move to the new file group.

Then again move the table to the...