jjssilva (6/27/2008)

---

Jeff Moden (6/26/2008)

---

So... what do you do when you...

Heh... Hey, Barry! Did I 'splain all that correctly? :hehe:

Don't look at the symbols... the symbols mean nothing to humans. What is important is the ASCII value... it can be 0 to 255 in a single character VARCHAR...

Chris Morris (6/27/2008)

---

Ahah...

I don't see where you've used that particular ISNULL as a join. It think it would be a problem if it were actually in a join because it uses...

jezemine is correct, though. I didn't really help with your test questions and you should learn how to use Books Online to find those answers.

You still haven't explained why you want to do that, Gerald. Not trying to bust your chops......

Thank you for the awesome compliment, Jim! Folks like you sure help keep me going...

Wow... I guess 64 bit isn't ready for primetime...

Of course, I still say that about 2k5 when the optimizer makes the wrong choice... 😛

GilaMonster (6/27/2008)

---

Jeff Moden (6/26/2008)

---

I haven't had to work with it so haven't been able to see what it actually does to a database and, as a result, can't say whether...

Ummm... yeah... just don't try to run the same proc twice at the same time unless you detect if the table is present before you make it...

... and be pretty...

Never mind... I got it... took a little trickery...

drop table #Fun

GO

select *

into #fun

from openquery([myserver],'SET FMTONLY OFF exec master.dbo.xp_DirTree [C:\],1,1')

select * from #fun

Bugger... this works just fine (I changed my servername in the code)....

drop table #Fun

GO

select *

into #fun

from openquery([myserver],'exec master.dbo.sp_who')

select * from #fun

... and so does this...

exec master.dbo.xp_DirTree [C:\],1,1

... but this...

Dang it... nicely done, Matt... I totally forgot that OpenQuery could have an EXEC in it. :blush:

[font="Arial Black"]WHY???[/font] :blink: Especially when they all have the same file format...