Well it's not a particuarly good idea to modify primary keys in the first place. Why is it necessary to mod the pk? If the pk is changed, are there...

Yes, there is a way, and it's related to the inserted and deleted tables.

For an insert, only the inserted table will have rows.

For an update, both inserted and deleted...

I'm not sure, but I suspect that it has to do with there been 2 ways to cascade a delete or update from Rooms to Device

(Rooms->Device), (Rooms->Employee->Device)

You should be able...

Same here w.r.t. error_line(). No mention in BoL and select error_line() returns "'error_line' is not a recognized builtin function name

Version

Microsoft SQL Server Yukon - 9.00.852 (Intel X86)

Jul 19 2004...

Text and image fields aren't stored in the row, all that's stored in the row is a 16 byte pointer. That's why a text/image field may store up to 2GB

How...

No, run profiler, save into SQL table, run queries. I had a very nice set of stored procs at my last job that. One would summarise profiler data and produce...

1st I don't know

2nd you can use profiler to log stored proc start and end times

3rd 8060 bytes

As far as I know,not without dropping and recreating the columns or the table.

The way enterprise manager changes column orders is to create a new table with the new...

INSERT INTO Items (ID, Item)

SELECT ID, Items FROM Items_RTD

Update ...

Set val32 = ISNULL((Select vh3 FROM OPENQUERY(....)),0)

Should work. Works fine if the inner select is all local. I don't have a handy linked server to test on.

A tranaction was created by the initial delete statement and the trigger will be part of that.

BEGIN

RAISERROR('Property may not be deleted when it is on a...

You could try searching for " profit "

How are you doing the insert?

Try putting some print statements into the trigger and do an insert from query analyser. That's about the only way I know to get messages/errors...

I've never used calculated fields myself, but from what I understand they update only when the data changes, so it may save you from writing a trigger in the first...

Rule 1: You never need to use cursors

Rule 2: If you need to use cursors, refer to rule 1