hi than's for your response.

I am aware of conditional split but what my question is

I had one file in that file 50 records are there I want to move 25...

Hi thank's for u r response..

my flat file data is :- fred,milk,10

...

Thank'Q For reply,Ratheesh.K.Nair

Yes I have the all The permission to that location, In sa login I did all these things.In CMD prompt it is fine, By using xp_cmdshell i...

thanks for your reply,my problem was solved.I was restarted my server then that query gives result.

Hi,thank's for your reply

here u can find my trigger code.

CREATE TRIGGER connection_limit_trigger

ON ALL SERVER

FOR LOGON

AS

BEGIN

IF EXISTS(SELECT * FROM sys.server_principals AS SP WHERE [name] = SUSER_SNAME() AND type_desc IN...

HI,thank's for your repaly,

I am trying to create logon trigger form my sysadmin login but it gives error like

Msg 1084, Level 15, State 1, Procedure Tr_ServerLogon, Line 2

'LOGON' is...

Thank's for your replay.