I pieced this together using posts from elsewhere on SQLservercentral.com:

CREATE  PROCEDURE dbo.usp_IsSQLAgentJobRunning

 @ParmJobName sysname

AS

/*

--  procedure to determine if the SQL Agent job named in @ParmJobName is currently running.  returns 0 if...

What happens if you run the same bcp without the format file, with -c?

I'm not sure about a .vbs file, but in an active server page, you first check the connection errors collection, then ignore everything with SQLState = 01000.  That covers general...

Yep, that's what we did.  Doesn't seem to be a problem when you script them with the object browser in QA, though...

Like so?

DECLARE @V1 int, @V2 int, @V3 int, @V4 varchar(10)

IF (@V1 <> 0)

     EXEC dbo.do_code_1

ELSE IF (@V2 <> 0)

     EXEC dbo.do_code_2

ELSE IF (@V3 <> 0)

     EXEC dbo.do_code_3

ELSE IF (LEN(@V4) >...

Nah, you can have as many as you need.  Although it does get hard to read after a while. 

If you really are dealing with varchars, and if you are...

More good info:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=157332&p=2

If you could give us the DDL for your input file and the tables where the data is to be stored, we might be able to give you some more...

You could also direct the output of the EXEC usp_Myproc to a temp table, then cursor your way through it:

CREATE TABLE ##MyTable ( lname varchar(20), fname varchar(15) ...)

INSERT INTO ##MyTable

EXEC dbo.usp_Myproc

DECLARE...

I don't know if there is a better way, but I created triggers on the FK table that queried the parent table in the other database.  If the FK is...

Four refurbished Dells; very reliable and good price points when purchased.  Two w/XP Pro, one for me to develop on and one for the wife to VPN to her work.  One Windows...

OK, where do you get the latest BOL update?

Why do you think they want to decrypt someone else's credit card number?  They want to go shopping! 

michanne:  Sure it's worth it, if it gets done what I need done.

Rich:  Thanks, that is certainly handy and dandy. 

Sauron:  I tried your example, and QA went off for five minutes or so, then gave me a "timeout" message and broke the connection.  I'm not sure what I might have...