unless you add an alias to the the tables from the other db, you have to reference them with the whole 4 part identifier in the select:

[ON_KEY_42R5_UDM2]..astAssets.ID,

not just...

damn you are right....

i copied this from the end of a long thread, figuring it was complete...i tried isReallyInteger('bob'), which returned 1 for true...I'm looking at it, but it's either...

a much longer thread on the ins and outs and liabilites of the IsNumeric function resulted in two enhanced user function s:IsReallyNumeric and IsReallyInteger. I saved them in my snippets.

try...

except for the fact that a delete is logged and truncate is not, doing a DELETE and the DBCC RESEED has the same affect.

this script grabs the tables in FK...

just missing the ELSE/END:

update tblDrawings

set TypeCode = case SheetNumber

...

it's your business process, so you'd know better than me...do you need to update the whole table every time?

i thought the trigger should only update from the INSERTED table, and...

there is a built in procedure to get all your objects in dependancy order:

EXEC sp_msdependencies @intrans = 1

I've only used it to build script, and not to drop...

I think you are planning the right way. I try to analyze the issue like this:

say i was going to support Spanish language version of my data, and consider...

you really need to start with creating a trace with profiler....create one and let it run for a while...I'd say one business day.

with that, it will give you every query,...

somewhere in your classes, notes and lectures, you must have heard there is an INFORMATION about SCHEMA information in the database I wonder if you were to look at some...

With this being your final year project at school, it wouldn't be right for us to do the work...you'd never gain the knowledge by copying our code. Being aware of...

you were so close on the syntax;

to assign to a static value, you usually use SET; but

you can assign a variable inside a select, like SELECT @CITY=CITY,@STATE=STE FROM ADDRESSES....

here's...

dunno why i keep looking at this...

you can add a trigger on the VIEW to handle the status column....

rename the original table.

--add a view that has the old table name...

Lynn he had stated previously that he actually has to check a couple other tables to get the true status...i think this was just a simplified example....since he's got to...

the point trying to make, is that if the "status" is based on criteria, which you said was a combination of the end date and other factors in other tables,...