"Coincidentally, in my experience of interviewing I’ve often found that people that come across as not totally confident and don’t have all the answers often do better. They are just...

farrell - the only other request i would make of salvatore is to post sample data where we have the same set of IDs in each table - copying and...

Lee - this topic has been thrashed around on SSC as well - also includes joe celko's comments (that your blogger refers to).....

follow these links...

to id or not to...

Lee - I know from personal experience the number of poseurs out there masquerading as instructors and professors who certainly could not answer most of the questions I had....

It's luck...

what service pack and mdac versions do you have ?!?!

supposedly sp3 and mdac 2.8 is said to have resolved this issue! maybe just installing sp4 (if you don't have it)...

have you tried using the enterprise manager dts import/export wizard ?! that would be quick and painless!

i cannot test this on my machine but see if this works...

exec sp_MSForEachDB "select * from sysobjects where xtype = 'P'

and name not like 'dt%'

order by name"

there's an undocumented sp_MSForEachDB that you should be able to use...if you search the forums you're guaranteed to find the script for it somewhere...

select * from sysobjects where xtype = 'P'...

should give you all stored procedures for a given database...and unless you have user defined procs created with dt...you could extend it to:

select...

what about:

datalength(fieldName) is not null

datalength(rtrim(fieldName)) = 0

also....not only is @in not being used at all - it is also declared as Varchar(1000) - so excessive for something that has no place in the procedure other...

we have a saying in india which roughly translates to - "in the land of the blind, the one-eyed man is king"....

looking for words of wisdom from the gurus...sometimes i'm online round the clock -

san - here's something from BOL that you can pass on to your developers...

"After sp_defaultdb is executed, the login is connected to the new database the next time the user...

noel - since you know all about linked servers - could you please help Bryan out if you have the time ?!

bryan's post