You're right.

I've tested it.

And the most interesting thing is the the error file (-e switch) is not filled in.

My test shows that if bcp fails ir returns 1 as error.

therefore here is a script:

bcp MyDB..MyTableWichNotExists out c.txt -SMyServer -UMyUser -PMyPassword -c -C1250 -r\n -t\t

@if errorlevel 1 echo bad...

on your tempdb check if unlimited autogrow is enabled.

If yes check if you have enough free space on the drive which holds your tempdb

If you are considering purely the performance then I would say that an integer value is faster then a string value (char(n) or even wors varchar(n) or nchar, nvarchar)

The reason...

Yop Frank,

I'm looking for a kind of all-in-all tool or language how ever you call it.

Or better said I'm not looking for that tool but I'm just curious what you...

Hey foxpro guys,

Without offending you why do you think VFP is the best frontend to MSSQL?

Do you mean to manage the server or run the apps?

I've had a look on...

First of all if you want to know which was the even then you have to create 3 triggers. one for INSERT, one for UPDATE and one for DELETE.

I do...

Yes there is a way to create a stored from from an another SP

create proc sp1

as

declare @STR varchar(1000)

set @STR = 'create proc sp2 as select *...

This errormessage is not an error but a warning and your client has to treat it as a warning.

If you really want to avoid be shure not to insert the...

As an additional info a propiety (price, partner info...) could have been modified more then once since the given date.

We only have to retrieve each product info once, regardles how...

Jon,

It is 'max degree of parallelism'

see sp_configure

Thanks guys for all the replies.

I've liked very the solution of Antares and alzdba but those solutions is still doing a table scan on SB_MODIFIED_TABLES.

As info in the SB_MODIFIED_TABLES there...

How do you like this?

SELECT  @sz = sum ( CAST (coalesce(file_size_bytes, 0) as bigint))/1024, 

 @Total_Tifs = sum(case when Image_Filename LIKE '%tif' then 1 else 0 end),

 @Total_Jpegs = sum(case...

Keith,

Thanks for reply.

Some infos:

All indexes are fine and they are used in the query. With the exception of one table SB_PRODUCTREPORT where a table scan is used which is normal,...

Why not to use an INSTEAD OF trigger?

Also if you define default for a specific column and during the insert you are providing NULL values to thoses columns, the default...