Hi ,

Thanks for the response.

I have read the post, but just wondering the pros and cons of deleting the data in Sysmail tables using the scripts.

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

DECLARE @DeleteBeforeDate DateTime

set @DeleteBeforeDate= '1/20/2010'

EXEC...

Hi,

Try these links ,

Hope they will help you to put/ get the files to/from FTP Sites

http://www.simple-talk.com/sql/t-sql-programming/pop-rivett-and-the-ftp-directory/

http://www.virtualobjectives.com.au/sqlserver/ftp_scripts.htm

http://haacked.com/archive/2006/04/21/sqlstoredproceduretoftpfilesfromsqlserver.aspx

http://beyondrelational.com/justlearned/posts/608/upload-all-files-from-source-folder-via-ftp-in-sql-server.aspx

Thanks

Hi ,

Openrowset works fine on 32 bit machine/server to import data from dbf file to sql server database.

SELECT * FROM OPENROWSET(

'MSDASQL', ' Driver={Microsoft dBASE Driver (*.dbf)};

DefaultDir=c:\Testfolder; SourceType=DBF', 'SELECT *...

Hi,

I have got the same problem with my reports now,

Please let me know if you got or find any solution for this.

your help will be greatly appreciated.

Thanks

Lakki

lakki1901@gmail.com

Hi can you tell how to use set locks .

Possible explain with an example please.

Thanks

Lakshman

Hi John

i have a mastertable MT and a child table CT.

in a stored procedure i am accession a row of master table and doing the calculations etc,...

Hi Jason,

else

Is it possible to do like this

untill current session job executes successfully

start loop

waitfor delay '00:00:02'

check the jobstatus of current session

end loop

and the next record...

Hi Jason,

Thanks for the response.

I ran this procedure in cursor so that i can generate reports for all the records in result set of the cursor.

and the time delay is...

Hi ,

Actually my task is to send report to different clients to their email address using respective parameter values

The cursor will give a result set with columns like ...

I am looping the job with records because.

I created a subscription to email a report in reporting services. and i observed that a subscription creates a job and parameter fields...

Hi,

The above srcipt u gave is only for Fail,Success, Cancel.

the code i used is like as follows

_____________________________________________

DECLARE Csr_CursorEmail CURSOR

FOR SELECT top(5) ClientNo, Depot, Service,...

Thanks for the reply,

I am using the code

EXEC msdb..sp_start_job @job_name = 'Jobname'

inside a cursor for every record of the cursor dataset.

I want to execute the job only after...