Lets say they have to be restarted and those moments when the server is getting restarted is when the SQL jobs are scheduled.Is there a configuration which would take care...

Sure,will keep in mind

Thanks Jeff/Eirikur .Should have updated the forum.I got what I was looking for.Thanks again.

ascii value for comma

nothing just ...just learning some coding

I do not want to use reverse function.please check the code I posted and correct what wrong I did.thanks

This is my IF clause which did not work...

if (@charvaluefront= @charvalueback)

Print 'its a palindrome'

I am not sure why it did not work...

Yes,I do plan to get it done using SSIS and SSRS.

I got the code working properly.

The code worked for sometime ...

then it stopped working.

It gave me these extracts SSIS570.html where 570 is the ID passed as a parameter.

After testing it a couple of times it...

Already tried that...still getting an error...

Msg 139, Level 15, State 1, Procedure usp_Names, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Procedure usp_Names,...

Did what you suggested...still throws an error...

Here is the code I tried executing...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from Table where ID=@ID';

Select...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from Table where ID=@ID';

SET @sqlquery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\SSIS' +@ID + '.html'

EXEC sp_makewebtask...

It still throws an error...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from dbo.Table where ID=@ID';

SET @sqlquery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\'...

It gives me this error ...

Msg 137, Level 11, State 1, Line 0

[Microsoft][SQL Native Client][SQL Server]Must declare the scalar variable "@ID".

Msg 16805, Level 11, State 1, Procedure sp_makewebtask, Line 131

SQL...