What you've created there is a computed column in the table, not a column with a default. The function is recursive as written, and will call itself without end, which...

Not sure how you want this displayed

This is the easiest:

That can be achieved by unioning the selects together

select '-Total-' AS Title, count(*) AS...

Are either of the boxes Server 2003? If so, you might want to check this out.

http://support.microsoft.com/default.aspx?scid=kb;en-us;329332

One thing to note is that bit fields are only really useful if there are multiple of them in a row.

From BoL

"If there are 8 or fewer bit columns...

An update statement may only target one table.

I don't know what the update statement looks like, but it sounds as if you're trying to update RaceLog and RaceLogRslts in...

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.