I finaly found the problem, you don't need to drop the FK's or the triggers.
There were views defined with "WITH SCHEMABINDING" that referenced the table.

To find the views...

Indeed, I had a similar experience, a Fortran 4 programmer said when confronted with Fortran 77 the string type was useless, basically it is a integer array so you can...

no, never received a reply.

The $_.fullname is the filename.

The content of the file is being converted by the script.

PowerShell will handle a filename with double quotes in it correctly.

I have added a Powershell step that removes the extra " chars.

I use the | symbol as field seperator which is a regex special char, so the regex expression has...

in fact there is a book about SSIS although the title suggests something else..

the title is Implementing a Data Warehouse with Microsoft SQL server 2012 (exam 70-463)

It covers a lot...

Andy I'am enjoing the series but I have a small problem with the 'Update'.

I'ts working, but it only updates about 700 records each run, I can't find any option to...

Good to know.

oracle behaves the same.

declare

round1a binary_float := 165.755;

round2a binary_float := 165.555;

round1b float := 165.755;

round2b float := 165.555;

begin

dbms_output.PUT_LINE (ROUND(round1a,2));

dbms_output.PUT_LINE (ROUND(round2a,2));

dbms_output.PUT_LINE (ROUND(round1b,2));

dbms_output.PUT_LINE (ROUND(round2b,2));

end;

165.76

165.55

165.76

165.56

Rob

Matt,

You're great!!!!

I had a database build using SQLserver\Express with a log file of 6GB and truncation didn't work what ever I tried.

When I did

select [name], log_reuse_wait,log_reuse_wait_desc from sys.databases where database_id=22;

it...