I am afraid you have to accept the third way and live with it.

Another approach is to find a better design solution that does not require passing long XML...

You are right in the way you decided to resolve the issue. Adding a day to the @date_to is the best solution I think. Of course, it is not a...

You can also put a DOS command 'rename' or 'copy' as the last step of your job and rename/copy the output file using the date/time as you wish.

Edited by -...

Unfortunately, you have to create a standard login in SQL Server to connect to ERwin, There is no way around as far as I know. A user name with read-only...

Use statement

ALTER TABLE tblMMStudentTestScores

DROP CONSTRAINT UN_tblMMStudentTestScores

or

ALTER TABLE tblMMStudentTestScores

ALTER COLUMN ...

- something like that to get rid of the constraint. It should help.

Edited by - mromm on 01/02/2003 5:04:25 PM

Go to Steps tab of the job, then double click on a step, click on Advanced tab, find a box called "Transact-SQL Script (TSQL) command Options" and Output File entry...

I think indexes won't help here. IS NOT NULL (or <>) condition has to go through every row anyway. This is different from IS NULL (or =). Also, once you...

You cannot update a value in the inserted table. You have to do an UPDATE of the same row based on its primary key from the trigger. Or, better yet,...

Of course.

Instead of executing a custom XP from a trigger, insert a record into a separate 'log activity' table. Run a SQL job on the server that checks that table...

What do you mean? What value of a parameter?

If you are talking about order of parameters, then there is a column called Param_order in the SELECT statement I provided. It...

Test both ways if you can and let us know.

I think your approach should also depend on whether you are going to INSERT this data into DB and than...

UPDATE c

SET location = i.Location,

Region_code = i.Region_code,

Bedroom = i.Bedroom,

Area = i.Area

FROM COAManyflats c

JOIN inserted i

ON c.Flatsno =...

Please, never ever put anything in trigger with exception of the simplest data integrity checking or auditing code. Triggers are not a messaging system. They are table constraints in a...

So, what is the exact question (in English) your query needs to answer?

Edited by - mromm on 12/27/2002 2:24:25 PM

Just run this and enjoy:

select'Procedure Name'= o.name,

'Parameter_name'= c.name,

'Type'= type_name(c.xusertype),

'Length'= c.length,

'Prec'= casewhen type_name(c.xtype) = 'uniqueidentifier' then c.xprec

else OdbcPrec(c.xtype, c.length, c.xprec) end,

'Scale'= OdbcScale(c.xtype, c.xscale),

'Param_order'= c.colid,

'Collation'= c.collation

fromsyscolumns c

joinsysobjects o

ono.type = 'P'

ando.id = c.id

order...