Ben - when you say "entering data directly" I assume you're using EM - have you tried running the "insert into"..off QA ?!

..hmm - not so sure about that - Gagandeep didn't say "EX-"Architects did he ?!?! Unfortunately they'll be around till it'll probably be too late...

All that you say is true oh wise one!

However, I think back to when I was first handed my present database (4 years...

Noel - before you wag your finger disapprovingly at this - I know that directly manipulating system tables in not recommended..but for convenience it can't be beat..

Good heavens! I know this sounds facetious but I'm in dead earnest when I say that people like these should be behind bars - at least they shouldn't be anywhere...

Have you not been listening ?!?! The "Architects" are "against Stored procedures"....

Hey Noel - Gagandeep didn't say they call themselves "good" architects...

Dim sSQL As String
sSQL = 'IF NOT EXISTS(SELECT * from NotificationTemplate WHERE OrganizationID...

why not create a stored procedure then ?!?!?!

This is scary since it involves messing with the system tables directly - but I guess if you try running it first (& second & third...) on a test environment,...

Jim - if I was in your shoes I would take the easy way out and create a stored procedure that'd execute various queries based on table & field names...

I find it much easier to just build my queries in QA...you can try testing it in QA first and then pasting it in your DTS query box...my sql usually...

Hey knucklehead - say hullo to "Bunny" aka "yours truly"...

tongue is definitely in the cheek...go up 5 posts for similar confusion...

...I don't think so, unless some plastic surgery's been involved - though if I were Steve I'd...

Just to clarify what padmakumar is saying..use a query like this...

select sc.name as ColumnName, so.name as TableName 
from syscolumns sc
inner join sysobjects so on
sc.id = so.id
where sc.name = 'colName'
order...