Click here to Skip to main content
15,922,894 members
Home / Discussions / Database
   

Database

 
AnswerRe: sql query Pin
zahedonline21-Jul-08 2:10
zahedonline21-Jul-08 2:10 
QuestionHai Pin
jeena994022076518-Jul-08 19:26
jeena994022076518-Jul-08 19:26 
AnswerRe: Hai PinPopular
N a v a n e e t h18-Jul-08 20:02
N a v a n e e t h18-Jul-08 20:02 
AnswerRe: Hai Pin
zahedonline21-Jul-08 2:13
zahedonline21-Jul-08 2:13 
QuestionSave results from table Pin
Waheed Ur Rehman18-Jul-08 19:22
Waheed Ur Rehman18-Jul-08 19:22 
AnswerRe: Save results from table Pin
Parwej Ahamad19-Jul-08 4:07
professionalParwej Ahamad19-Jul-08 4:07 
AnswerRe: Save results from table Pin
SimulationofSai19-Jul-08 4:33
SimulationofSai19-Jul-08 4:33 
GeneralRe: Save results from table Pin
Waheed Ur Rehman19-Jul-08 22:40
Waheed Ur Rehman19-Jul-08 22:40 
Hi i have searched a lot and found that BCP can be used for this purpose.
Now i have written a simple query
Declare @str nvarchar(4000)
set @str='bcp "Select DISTINCT MAIN_ID from mydb.dbo.Postings " QUERYoUT "E:\Temp1.txt" -T'
Print(@str)
Execute master..xp_cmdshell @str
But i get the Output
SQLState = 08001, NativeError = 126
Error = [Microsoft][SQL Native Client]VIA Provider: The specified module could not be found.
NULL
SQLState = HYT00, NativeError = 0
Error = [Microsoft][SQL Native Client]Login timeout expired
SQLState = 08001, NativeError = 126
Error = [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connecti
ons.
NULL
I have checked remote connections are enabled......
Looking forward for your reply.
Thanks
GeneralRe: Save results from table Pin
SimulationofSai20-Jul-08 0:07
SimulationofSai20-Jul-08 0:07 
GeneralRe: Save results from table Pin
Mycroft Holmes20-Jul-08 14:53
professionalMycroft Holmes20-Jul-08 14:53 
AnswerRe: Save results from table Pin
zahedonline21-Jul-08 2:19
zahedonline21-Jul-08 2:19 
QuestionFind saturday Pin
Member 387988118-Jul-08 3:42
Member 387988118-Jul-08 3:42 
AnswerRe: Find saturday Pin
Paul Conrad18-Jul-08 4:17
professionalPaul Conrad18-Jul-08 4:17 
AnswerRe: Find saturday Pin
Colin Angus Mackay18-Jul-08 5:14
Colin Angus Mackay18-Jul-08 5:14 
AnswerRe: Find saturday Pin
Parwej Ahamad18-Jul-08 6:21
professionalParwej Ahamad18-Jul-08 6:21 
QuestionNeed working dates? Pin
Member 387988118-Jul-08 3:21
Member 387988118-Jul-08 3:21 
AnswerRe: Need working dates? Pin
Paul Conrad18-Jul-08 4:18
professionalPaul Conrad18-Jul-08 4:18 
QuestionNeed Query. Pin
Binod K18-Jul-08 3:09
Binod K18-Jul-08 3:09 
AnswerRe: Need Query. Pin
leoinfo18-Jul-08 4:35
leoinfo18-Jul-08 4:35 
AnswerRe: Need Query. Pin
Blue_Boy18-Jul-08 6:24
Blue_Boy18-Jul-08 6:24 
Questionlike query Pin
brettokumar18-Jul-08 2:47
professionalbrettokumar18-Jul-08 2:47 
QuestionRe: like query Pin
leoinfo18-Jul-08 2:56
leoinfo18-Jul-08 2:56 
AnswerRe: like query Pin
Mycroft Holmes20-Jul-08 14:57
professionalMycroft Holmes20-Jul-08 14:57 
AnswerRe: like query Pin
Paddy Boyd18-Jul-08 3:54
Paddy Boyd18-Jul-08 3:54 
GeneralRe: like query Pin
TheFM23418-Jul-08 5:02
TheFM23418-Jul-08 5:02 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.