you can use the CONVERT function in 6.5.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

inserted and deleted are only available from the scope of the trigger. You can't even access them from an SP called from the trigger.

You either have to use global temp...

You need to use a format file, to import fixed width into different columns

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

The UPDATE function will return true if that column was included in the SET clause of the UPDATE statement even if the value does not change.

Your trigger will only...

Or you could move to IIS and win2000

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

You need o use isql. or do something funky like add the column headers to the resultset i.e

select 'col1', 'col2', 'col3'

union all

select col1, col2, col3

from mytable

Simon Sabin

Co-author of SQL Server...

use RAISERROR in the SP should do it

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

DTS is probably the neatest solution.

You can run them using DTSRUN from the command prompt or as a scheduled job

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Simon true. you do have to use cursors, but you need to know when to use cursors. If you don't know try not to. Your example is one where you...

How long does it take to run? could it be disconnecting automatically?

Can you paste more code?

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

You'll have to rename the table,

drop the constraints

create the new table

then insert the data back into the new table from the old table.

Finally recreate the constraints

Simon Sabin

Co-author of SQL...

ALTER TABLE TableName ALTER COLUMN ColumnName varchar(5)

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Make sure that at the bottom of each SP script is a line.

GRANT EXECUTE sp_something TO Developer

That should do it.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Nope, you can rename all but the primary one, by adding new ones, emptying the old ones (which copies data to the new ones).

Simon Sabin

Co-author of SQL Server 2000 XML...

I have wrote a little app that scripts everything and then I compare the files with sourcesafe. This also means I can check with my stored version of the database

Simon...