Viewing 15 posts - 1,351 through 1,365 (of 2,469 total)
"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...
August 18, 2005 at 10:08 am
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...
August 18, 2005 at 9:05 am
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...
August 18, 2005 at 8:23 am
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...
August 18, 2005 at 7:22 am
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)...
August 18, 2005 at 6:06 am
have you tried using the enterprise manager dts import/export wizard ?! that would be quick and painless!
August 17, 2005 at 4:29 pm
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"
August 17, 2005 at 11:53 am
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...
August 17, 2005 at 11:49 am
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...
August 17, 2005 at 11:40 am
what about:
datalength(fieldName) is not null
datalength(rtrim(fieldName)) = 0
August 17, 2005 at 10:36 am
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...
August 17, 2005 at 8:34 am
we have a saying in india which roughly translates to - "in the land of the blind, the one-eyed man is king"....
August 16, 2005 at 7:43 pm
looking for words of wisdom from the gurus...sometimes i'm online round the clock -
August 16, 2005 at 7:38 pm
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...
August 16, 2005 at 7:34 pm
noel - since you know all about linked servers - could you please help Bryan out if you have the time ?!
August 16, 2005 at 7:30 pm
Viewing 15 posts - 1,351 through 1,365 (of 2,469 total)