When i execute the below select statment i am getting same error and i am using SQL SERVER 2005 SP2

SELECT

s.spid,s.dbid,s.login_time,s.hostname, s.loginame, s.program_name,s.waittype,s.lastwaittype,s.cpu,s.memusage,s.status,s.net_library,s.sql_handle

,e.text as SQL

FROM

sys.sysprocesses s

CROSS APPLY sys.dm_exec_sql_text(s.sql_handle) AS e

Error is:

Msg...

I am executing the below script

create view sqlexec as

SELECT

s.spid,s.dbid,s.login_time,s.hostname, s.loginame, s.program_name,s.waittype,s.lastwaittype,s.cpu,s.memusage,s.status,s.net_library,s.sql_handle

,e.text as SQL

FROM

sys.sysprocesses s

CROSS APPLY sys.dm_exec_sql_text(s.sql_handle) AS e

I am executing this script in SQL server 2005, and first step itself i am getting below error.

Msg 102, Level 15, State 1, Procedure sqlexec, Line 7

Incorrect syntax near '.'.

Hi Venugopal,

This script was not working when i create the view i am getting following error.

Msg 102, Level 15, State 1, Procedure sqlexec, Line 16

Incorrect syntax near '.'.

Regards,

Sarath

Hi Lowell,

Thank you,

I have downloaded Core FTP LE 2.2 : free version, and created the site profile as CVE.

I have used the below code to execute in SSMS.

DECLARE @ShellCommand varchar(4000)

SET...

Hi Lowell,

Thank you for your reply.

Please can you explain in detail, because which version of Core FTP we need to download.

wat we need to do after download. please if you...

Thanks Jeff, it is working for me.

Hi opc,

I am using this code in SP and we need to append the data to same text file with loop.

so please help me on this.

Hi ALZDBA,

I can't use SSIS because of client restriction.

by using my code it is adding one space to the end of the line, I have to elemenate that how can...

Thanks Steve

Hi Ben,

thanks for your help on SSIS, but how can use that task, can u tell me the procedure of 'Derived Column Task' for adding new column to destination table.

while...

try this i am using like this only it is working for me

<

a href="http://Localhost/ReportServer/Pages/ReportViewer.aspx?