No, not verifying on the Veritas.

The scheduled task(script file .bat) is placed on Netbackup client server which does the copy job.

In the same batch file, can we add any...

Hahaaa...Google Search 🙂

As Perry told, it is good to troubleshoot why in first place the LS restore job is not picking up the t-log backups.

There is no need to re-configure LS each...

declare @var1 int

set @var1=3

select schid, stuid from stu where stuid in (select stuid from (select * from stu where schid=@var1) a )

where (select * from stu) is your resultset...

Create a DB maintainence plan to fulfill this

1) create a subplan for full backup and schedule it to run Monday

2) create a subplan for diff backup and schedule it to...

Try this and see if it fixes ur problem.

use Master

Go

select * from master.sys.sysprocesses

where spid>50 -- don't want system sessions

and dbid = DB_ID(name of database in question)

--Find the SPID...

Create a NON-Clustered index on the filtered column which you are issuing in DELETE statement and see if that fixes the dead locking issue to complete the statement.

It seems other...

I have overlooked at the problem statement and gave the wrong query.

Thanks Andy for correcting me.

Check if the below one helps ur purpose.

select distinct custid

from product_details

where prodid in (1,4) and custid not in (select custid from product_details where prodid=0)

It depends on the size of your database, number of tables and rows in them.

Generally, publishing to a report server running in SharePoint integrated mode,

we need to specify the TargetServerURL property to a URL of a SharePoint top-level site or subsite.

For example,...

It seems the length of the report file path is too long. Please run <select len('path including file name with extension')> and see if it is exceeding 260 or not....

Please try below one

EXEC xp_cmdshell 'FORFILES /p "C:\SSISFILES\Log\" /s /m *.txt /d -4 /c "CMD /C echo Deleting the file : @file del /Q /F @FILE && del /Q /F...

Below is the size of the tableA

namerowsreserved data index_sizeunused

TableA49132 19352 KB 8464 KB ...

Try the above one and see if it serves your purpose!!!

*******:cool:

Sudhakar