Click here to Skip to main content
15,561,681 members
Home / Discussions / Database
   

Database

 
AnswerHash code Pin
David Mujica31-May-11 3:48
David Mujica31-May-11 3:48 
GeneralRe: Hash code Pin
Vimalsoft(Pty) Ltd31-May-11 4:51
professionalVimalsoft(Pty) Ltd31-May-11 4:51 
GeneralRe: Hash code Pin
Pete O'Hanlon31-May-11 5:10
mvaPete O'Hanlon31-May-11 5:10 
GeneralRe: Hash code Pin
Vimalsoft(Pty) Ltd31-May-11 5:35
professionalVimalsoft(Pty) Ltd31-May-11 5:35 
GeneralRe: Hash code Pin
Pete O'Hanlon31-May-11 5:57
mvaPete O'Hanlon31-May-11 5:57 
GeneralRe: Hash code Pin
Vimalsoft(Pty) Ltd31-May-11 6:25
professionalVimalsoft(Pty) Ltd31-May-11 6:25 
GeneralRe: Hash code Pin
Shameel31-May-11 6:28
professionalShameel31-May-11 6:28 
QuestionBCP CLI Cannot find Invalid object name. [modified] Pin
Groulien31-May-11 0:37
Groulien31-May-11 0: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 5:31
professionalCorporal Agarn31-May-11 5:31 
QuestionMSSQL Backup database - without BACKUP command Pin
David Hovey30-May-11 5:58
David Hovey30-May-11 5:58 
AnswerRe: MSSQL Backup database - without BACKUP command Pin
SilimSayo30-May-11 9:41
SilimSayo30-May-11 9:41 
AnswerRe: MSSQL Backup database - without BACKUP command [modified] Pin
Shameel31-May-11 1:33
professionalShameel31-May-11 1:33 
GeneralRe: MSSQL Backup database - without BACKUP command Pin
SilimSayo31-May-11 4:49
SilimSayo31-May-11 4:49 
GeneralRe: MSSQL Backup database - without BACKUP command Pin
Shameel31-May-11 5:22
professionalShameel31-May-11 5:22 
GeneralRe: MSSQL Backup database - without BACKUP command Pin
SilimSayo31-May-11 8:24
SilimSayo31-May-11 8:24 
QuestionStored Procedure Pin
berba30-May-11 0:09
berba30-May-11 0:09 
AnswerRe: Stored Procedure Pin
Luc Pattyn30-May-11 0:59
sitebuilderLuc Pattyn30-May-11 0:59 
AnswerRe: Stored Procedure Pin
SilimSayo30-May-11 3:31
SilimSayo30-May-11 3:31 
QuestionCopy table 1 to table 2 for missing data only Pin
MAW3026-May-11 18:02
MAW3026-May-11 18:02 
AnswerRe: Copy table 1 to table 2 for missing data only Pin
Blue_Boy26-May-11 22:14
Blue_Boy26-May-11 22:14 
AnswerRe: Copy table 1 to table 2 for missing data only Pin
PIEBALDconsult27-May-11 3:32
professionalPIEBALDconsult27-May-11 3:32 
GeneralRe: Copy table 1 to table 2 for missing data only Pin
MAW3027-May-11 7:29
MAW3027-May-11 7:29 
GeneralRe: Copy table 1 to table 2 for missing data only Pin
jschell27-May-11 10:07
jschell27-May-11 10:07 
AnswerRe: Copy table 1 to table 2 for missing data only Pin
dasblinkenlight29-May-11 18:45
dasblinkenlight29-May-11 18:45 
QuestionProblem with POWER Pin
TheComputerMan26-May-11 5:14
TheComputerMan26-May-11 5: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.