Click here to Skip to main content
15,867,568 members
Home / Discussions / Database
   

Database

 
AnswerHash code Pin
David Mujica31-May-11 2:48
David Mujica31-May-11 2:48 
GeneralRe: Hash code Pin
Vimalsoft(Pty) Ltd31-May-11 3:51
professionalVimalsoft(Pty) Ltd31-May-11 3:51 
GeneralRe: Hash code Pin
Pete O'Hanlon31-May-11 4:10
subeditorPete O'Hanlon31-May-11 4:10 
GeneralRe: Hash code Pin
Vimalsoft(Pty) Ltd31-May-11 4:35
professionalVimalsoft(Pty) Ltd31-May-11 4:35 
GeneralRe: Hash code Pin
Pete O'Hanlon31-May-11 4:57
subeditorPete O'Hanlon31-May-11 4:57 
GeneralRe: Hash code Pin
Vimalsoft(Pty) Ltd31-May-11 5:25
professionalVimalsoft(Pty) Ltd31-May-11 5:25 
GeneralRe: Hash code Pin
Shameel31-May-11 5:28
professionalShameel31-May-11 5:28 
QuestionBCP CLI Cannot find Invalid object name. [modified] Pin
Groulien30-May-11 23:37
Groulien30-May-11 23:37 
I'm trying to export the results of a stored procedure to a csv, here's what I've got:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" myDb.dbo.spExport out "Data.csv" -T -Slocalhost -t";" -c
It keeps telling me "Invalid object name 'myDb.dbo.spExport'."

Other stored procedures don't work either and none require parameters.
Pointing to a table works so I thought I was pointing to at the SP's the right way.
What am I doing wrong?

-Nevermind, got it working:
"C:\Program Files\Microsoft SQL Server\90\Tools\Binn\bcp.exe" myDb.dbo.spExport queryout "Data.csv" -T -Slocalhost -t";" -c

modified on Tuesday, May 31, 2011 10:08 AM

AnswerRe: BCP CLI Cannot find Invalid object name. Pin
Corporal Agarn31-May-11 4:31
professionalCorporal Agarn31-May-11 4:31 
QuestionMSSQL Backup database - without BACKUP command Pin
David Hovey30-May-11 4:58
David Hovey30-May-11 4:58 
AnswerRe: MSSQL Backup database - without BACKUP command Pin
SilimSayo30-May-11 8:41
SilimSayo30-May-11 8:41 
AnswerRe: MSSQL Backup database - without BACKUP command [modified] Pin
Shameel31-May-11 0:33
professionalShameel31-May-11 0:33 
GeneralRe: MSSQL Backup database - without BACKUP command Pin
SilimSayo31-May-11 3:49
SilimSayo31-May-11 3:49 
GeneralRe: MSSQL Backup database - without BACKUP command Pin
Shameel31-May-11 4:22
professionalShameel31-May-11 4:22 
GeneralRe: MSSQL Backup database - without BACKUP command Pin
SilimSayo31-May-11 7:24
SilimSayo31-May-11 7:24 
QuestionStored Procedure Pin
berba29-May-11 23:09
berba29-May-11 23:09 
AnswerRe: Stored Procedure Pin
Luc Pattyn29-May-11 23:59
sitebuilderLuc Pattyn29-May-11 23:59 
AnswerRe: Stored Procedure Pin
SilimSayo30-May-11 2:31
SilimSayo30-May-11 2:31 
QuestionCopy table 1 to table 2 for missing data only Pin
MAW3026-May-11 17:02
MAW3026-May-11 17:02 
AnswerRe: Copy table 1 to table 2 for missing data only Pin
Blue_Boy26-May-11 21:14
Blue_Boy26-May-11 21:14 
AnswerRe: Copy table 1 to table 2 for missing data only Pin
PIEBALDconsult27-May-11 2:32
mvePIEBALDconsult27-May-11 2:32 
GeneralRe: Copy table 1 to table 2 for missing data only Pin
MAW3027-May-11 6:29
MAW3027-May-11 6:29 
GeneralRe: Copy table 1 to table 2 for missing data only Pin
jschell27-May-11 9:07
jschell27-May-11 9:07 
AnswerRe: Copy table 1 to table 2 for missing data only Pin
dasblinkenlight29-May-11 17:45
dasblinkenlight29-May-11 17:45 
QuestionProblem with POWER Pin
TheComputerMan26-May-11 4:14
TheComputerMan26-May-11 4:14 

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.