Not sure but I think it may be the way that Crystal is using the view... I believe that it creates a different instance of the view for each instance that...

Kokyan gave a good example of "Dynamic SQL"... just wanted to remind everyone that dynamic SQL can be quite a bit slower than "Static SQL" because it does not pre-form...

It's a forum, not on-line help...

Anyway, use the -m parameter followed by the number of errors you wish to allow.  Lookup BCP,Overview in...

1. You need to assign a "table alias" to the SELECT in the FROM clause.

2. You need to use that table alias on all column names to the right of...

Basically, @@Error only lasts for one successful line of code so by the time you get to the "SET @out_param = @@Error" chunk of code, @@Error has been reset to...

Add the "-n" parameter to your command line to suppress both the prompts and the line numbering.

Recommend you use OSQL instead.

Not sure if it uses the 'Sum of Product - Mod 10' method you were talking about but...

Have you tried the CHECKSUM function in SQL?  It's in "Books on line".

--Jeff...

Richard,

It's a bug and it's in BCP as well as bulk insert.  The only time the "First Row" option works correctly is when the rows to be ignored, the first...

The "-c" parameter, as you are probably aware, uses the CHAR format.  What you might not know is that it adds the "newline" character as well.  Hex "0D" is a...

Lookup "hierarchical information" in Books on Line for an example.  Has a bug in it but shouldn't be hard for you to find.

--Jeff Moden

Kind'a what I thought... Thanks for the quick reply, Gary!

It's been my unpleasant experience that the production server will usually be much more active than the development server.  You could be having a problem with wait-locks from other processes...

Apologies for disagreeing with the masters...

Just changing the "if exists" to tempdb (as previously posted) will NOT detect or delete a temp table...

Not real sure but I think if you have "GO" anywhere in your script, you need to set nocount to on after the "GO".  Of course, if you don't have...

Actually... there is a way if you want to generate the scripts for ALL the objects in a database.  Check out the following URL...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q220/1/63.asp&NoWebContent=1