Jeff Moden (11/29/2010)

---

dataguru1971 (11/29/2010)

---

I kept re-reading that thinking i must have missed something for the Modenator to respond with something different. I am a big fan by the way,...

Jeff Moden (11/29/2010)

---

Actually, my bad. I didn't read the whole post to see what the data source actually was. I agree that the Information_Schema views are the ticket...

Would have to check it before insertion...is the value being passed as a variable anywhere?

If you do:

Create table concheck (

myint int not null

constraint isInt check (Ceiling((cast(myint as numeric(23,1))/1000)*1000)...

Why not populate both lists from INFORMATION_SCHEMA.tables and .columns views which exist?

Another excellent article Jeff.

Maybe the are referring to potentially use NOT EXISTS instead of NOT IN ?

http://decipherinfosys.wordpress.com/2007/01/21/32/

http://blogs.geekdojo.net/richardhsu/archive/2004/10/05/3325.aspx

That can be a pretty broad question.

What do you intend to keep in the trail?

Updating of record?

You can have a trigger set up to store information in another table when...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98659

cross post

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98640

cross post.

Are both versions of SQL the same and updated through the same service packs?