My Mistake and typo, as I meant to say CANT "Execute" anything in Function 🙂

That is what i am doing...:)

Anyways really thanks for the reply. This makes me confident about my approach 🙂

Thanks

Parth

Thanks a ton,

actually i have used both the answers in my stored procedure, one que though when i tried using the execute statement in my function it gave me an...

indeed it is working from command prompt but not working from SQL, 🙁

and then i changed my approach.....but still i would like to know the answer for that....

then how do i have latest status..??

If I delete the file, and create a new one how am i gonna write my data as my Excel which i am sending is containing some macro and Columns...

Delete openrowset('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=c:\MOMA.xls;','Select * from [sheet1$]')

above code we are using for deleting data.

It was Server Client Issue ,

Now i got it.

Thanks for the prompt reply.

Parth

Hi,

After following the artical which you gave, i am getting an

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Syntax error in FROM clause.".

Msg 7321, Level 16, State...

Hi,

First of all thanks for the prompt reply.

My EXE is in C Drive only, and it is running fine, if i run from the command prompt.

and my server and exe...

Hi,

I have an EXE file which i would like to run, what i am doing is running following script but in void.... 🙁

declare @sqlcmd varchar(200)

SET @sqlcmd = 'WinWSSList.exe'

EXEC master..xp_cmdshell @sqlcmd...

Hi,

Sorry to bother you, but what i can say is you need to create HTML with Cursor,

Let say,

Fetch Next from C1 into @tr,@td

--In this @tr,@td you...

i am facing a problem which is not allowing me to run my Windows app. using Xp_cmdShell and using that i want to run it based upon a trigger ,

here...

Thanks for all your Replies but i have manage to work it....!!!

but still i have a confusion who is gonna pay for it???

what i have done is? i have used...

Thanks for the Reply,

here in receipant what should i write: 99999999@airtel.com??

what puzzeled me most is who is gonna pay for my SMSs and what kind of profile i have...