Thanks again Noel!

Assumption #1

I assumed that using recursive triggers was probably not the best idea since it is so limited. It causes an error when nested_level > 32.  I assume...

Thanks very much! As usual Noel!

Thanks very much! I think that will work!

Thanks that information was helpful.

Thanks for the article Noel. I read it. But i guess i'm not going to get any suggestions on this. I didn't think it was that difficult at least for...

Thanks Noel, you always provide helpful information. I'll do some research on this SET QUOTED_IDENTIFIER statement.

Thanks!

EXEC sp_addextendedproperty

'MS_Description', "Employee's first name", 'User', 'dbo', 'table', 'Employees', 'column', 'FirstName'

So this doesn't work? I used two double quotes on both sides with...

Someone said it might be the difference in the quote mark. It is a different font not a different quote mark. Actually it is supposed to be the same font!...

Thanks again guys. I will take a look at the link too Mike. Greatly appreciated!

Rule #1: Use NULLs to indicate unknown/missing information only. Do not use NULLs in place of zeroes, zero-length strings or other "known" blank values. Update your NULLs with proper information...

Thanks guys! Based on the information you guys provided, i was able to find this info on msdn.com that might be helpful.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_08_7qb7.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ua-uz_91k9.asp

Thanks very much guys!

All columns must be dependent on the primary key. If it is a calculated column it will be dependent on the columns involved in the calculation. From what i understand...

Thanks that is a good point. I hadn't realized that.

HOWEVER, the statement itself is contradictory. "When a batch is submitted for processing, it's parced, resolved, optimized, compiled, and then...

Thanks!