It's FAKE! It's NOT THE MICROSOFT TECHNET. Go to http://www.microsoft.com then find the link to Technet. Then go to Scripts. You won't find this on their site. -SQLBill

It sounds like you boss is talking about DBCC INDEXDEFRAG and DBCC DBREINDEX commands. Check them out in the Books OnLine. -SQLBill

48% geekness for me!

Of course you can, that's why the stored procedure sp_attach_single_file_db exists.

Please don't go back to the old forum style!

Andy,

That's okay. I hope you didn't take it as a complaint. I completely understand you all are busy with the upgrade and it WAS a minor question.

Keep up the great...

Sure, I'll do that from now on...don't know why I didn't think of that to begin with.

-SQLbill

Frank,

As I have found out (I had the same question but never got an answer), when you start a new thread, between the subject and the message are a bunch...

Whoopss! I misread your post and used an extra carriage return (blank line). I'll try the extra space now.

But like I said, even just this post I'm making now. The...

That could be it Frank...but we'll see when you get up around 4000 posts.

BTW-I like being rated a Super Poster at only 600+ posts and you are also a Super...

This is really irritating (at least for me) since I have to uncheck it for EVERY post I make. Even if it's in the same thread that I just posted...

I'll try that with the extra carriage return. But if you haven't noticed, you lose the carriage returns even when you are just typing in your thread itself.

I put a...

Now they are doing 'fill' boxes. Look under your name. There's your 'title' which in your case is Super Poster. Then there are boxes. Those boxes appear/fill based on the...

Try replacing LAST with MAX.

-SQLBill

In Frank's solution, add TOP 10 after the SELECT.

SELECT TOP 10 virusname..........

-SQLBill