Thanks. I'm not familiar with SQL Server Data Tools. Is this a part of SQL Management Studio or something optional?

Thank you. I understand this query gives me a list of which tables have foreignkeys on them and what the key is so I can be proactive in identifying and...

Both are good points and that's the recommendation I am making.

(That and I might actually have a need to delete something in my lookup table and since it's never been...

Thanks, doing this does cause my field size to display properly and so did scripting out my view and altering it (your suggestion was much faster though!).

However, I've modified tables...

Thanks, I tried this and kept getting a syntax error with my live data but will try again knowing it is possible to do it this way.

I understand my invalid object name error is a "compile error" and this wouldn't get caught in @@Error and that's why my code was stopping/failing. I believe the better way...

Ah, that worked. Not sure how it remained in sysobjects but it is gone now.

Doh!

select schema_id, is_schema_published,* from sys.objects

where name = 'temptest'

Results: 55 & 0

I'm not sure if I'm providing the right result.

select schema_ver, stats_schema_ver,* from sysobjects

where name = 'temptest'

Gives me zero for both columns.

No problems with CheckDB. Is there another DBCC I should be running?:

DBCC checkdb

CHECKDB found 0 allocation errors and 0 consistency errors in database 'XXXX'.

And Can't Drob Table Via...

Thanks!

I did a quick check and it turns out I did have a row with a null value in field1 for tableb. Once I deleted this record (since it was...

I believe this worked. My update did not occur and I did not get the message I was getting before.

Thanks!!

Thanks. We'll give it a try!

Thanks. I can't control the update statement that runs, as this is done by the application.

(When the user clicks save, the application updates the entire row.)

Because I can't control this,...

Thanks for the recommendation, I'll see if we can give this a try.