Viewing 15 posts - 1 through 15 (of 29 total)
hi Ahmed,
After a long time........
again the same query .
Left the query at that time and now i want to do the same thing from tommorrow.
Actually ,i am not having any...
December 27, 2007 at 12:17 am
hi Ahmed,
Did u get any result of our query?
If possible make it know.
it's taking lot lot lot of time to execute the query.
I want a trigger as soon as...
December 3, 2007 at 2:34 am
hi Ahmed,
Seperately if i run it it's working but in a trigger it's not working.
Iam also trying for that only by doing another task too .
so iam a bit...
November 30, 2007 at 4:11 am
Ahmed ,
This is my trigger .......
Alter Trigger TestTrigger1
On tablefortrigger
For Insert
As
Begin
Set nocount on
EXEC master.dbo.xp_cmdshell 'bcp "select * from tablefortrigger order by track FOR XML Auto queryout d:\anu.xml -S system22...
November 29, 2007 at 9:45 pm
Ahmed ,
I din't find any difference between ur last post and the present.
Is it that u removed the ' " ' (double qoutations ) from the query of exec xp_cmdshell...
November 29, 2007 at 6:05 am
hi Ahmed ,
I got the result saved inthe xml file but .........it's only once.
After that iam unaable to execute any of the query on that table.Even "select * from tablefortrigger".
It's...
November 29, 2007 at 5:36 am
hi Ahmed,
I got the result to a xml file.
After getting it if i want to execute "select * from tablefortrigger" after executing the cmdshell command of xml file the...
November 28, 2007 at 11:58 pm
Ahmed ,
Ur DBA so u can do this .
But iam a .net programmer.So iam unable to do this.
Thank God for showing u as a helper.
Anujahnavi S.
November 28, 2007 at 5:28 am
Ahmed ,
Iam not having any of the user name or password.
directly windows athentication iam using.
so no need of giving those..
i specified server name.
I have given u know the output...
November 28, 2007 at 5:26 am
Ahmed garu,
It's not at all recognizing it as a query(select * from tablefortrigger)
Iam getting the output as
usage: bcp {dbtable | query} {in | out | queryout | format} datafile
...
November 28, 2007 at 4:12 am
I want to create a empty xml file in d: and want to save the result to that xml file
Anujahnavi S.
November 28, 2007 at 3:15 am
Ahmed,
I created a result.xml file in d: is it ok
it automatically creates it?
How can i create a xml file from sqlserverexpress.
ur fead of me right Ahmed.
Sorry for disturbing...
November 28, 2007 at 2:58 am
hi Ahmed,
Can u be a bit clear about this saving to xml file.
What r those
bcp,ELEMENTS,root,-c,-r,-t?
and can the xml file be created when the trigger is fired in sql server...
November 28, 2007 at 1:40 am
hi Ahmed,
Thanks alot
My Team Leader Said
"hmm Anu ,U did a Good Job"
I felt happy it's because of u .
Thinking that i dint give any reply back
I was...
November 27, 2007 at 10:39 pm
Hi Ahmed,
Y not responding?
ok
If iam hving doubt u will or what.
My TeamLeader said
"hmm Anu Did a Good Job".
All this credit goes to u Ahmed.
This is the first time i...
November 27, 2007 at 10:04 pm
Viewing 15 posts - 1 through 15 (of 29 total)