Check whether the job owner is same, as it was earlier. Also check the user rights for both the users.

U can use a script that will check against all the servers those r registered (by creating linked servers) -- in sysservers.... and check for "Enable or disable command shell"...

I didn't get ur requirement...

Did u mean like if there are 3 rows for ID=1, and we are going to insert 1 more row for the same ID, then It should return all the...

It would help me to understand, if u can post the list of indexes on the table as well as the error u r getting while trying to enable the...

U can use case conditional expression in ur qry... for more help see BOL...

I did it by using ur example. Check whether this what you are looking for.....

DECLARE @Var1 varchar(max),@Var2 varchar(max)

SET @var1='Sethuraj'

SET @var2='Sahithya'

PRINT '@var1 = ' + @var1

PRINT '@var2 = ' + @var2

set...

Check execution plan for cursor-qry as well as the queries participating inside the cursor structure... that might help......

It would be helpful for me to understand if u can send me the output of below command :

RESTORE FILELISTONLY FROM DISK = 'completepath \ <your backup file name>'

Also send...

U can make the changes in excel itself, before doing imports. (By selecting the comments column & use find/replace)...

Provide complete path for the input file under double quotes.

bcp CRIS_IST.dbo.Blaze69Repository in "c:\...\...\blazerepo.cris.bcp" -T -c -SLUWZD5584 -Uroger -Proger

Since u have migrated the database, You should do rebuilding indexes as well as Update the statistics. This will definitely help in reducing response time.

If single quotes are there, try replacing single quotes with some other special character, that should not be anywhere in comments column. (U may choose double quotes...).. I hope it...

Configure Database Backup using Maintenance Plan and add another step to compress Backup File.

Syntax to compress the backup file by using winzip :

winzip32 [-min] action [options] filename[.zip] files

U need to put condiition to build @Collist string.....

Try replacing <SET @Collist = @Col1 + ',' + @Col2> with .........

---------------------------

if @Col1 is null

SET @Collist = @Col2

else if @Col2...