I have a  DB of size 240 GB and when the rebuild index job runs the log file grows upto 300 GB. I do a online reindex activity....

Yes, but not the way you think.  It's a mistake to move only the FULL backups.  You have no chance of restoring to a given time without the log files. ...

How big or small is the table?  Some tables are...

Yep... I was looking at his code, as well.  It appears that the OP wants only columns that contain nothing but nulls.

Agreed... Scott hit the nail on the head on this one, for sure.  I've run into the identical problem several times and ended up doing just like Scott posted.

I'm with ya on having some good stuff in the Master database.  I agree that a lot of people poo-poo such things but it works incredibly well especially if you're...

It's a real...

As a bit of a sidebar, the table I tested it against has, like I said, 147 columns.  It's kind of a small table weighing in at only 8.4GB and...

I asked because many people are happy with code as long as it ultimately does what they need it to do, i.e. "the code's good enough for me." ...

What are you asking why instead of posting a...

What are you asking why instead of posting a link to something better?...

And let's hope it's not an update to SSMS that's causing the problem.  Which edition and version of SQL Server do you have and to which version of SSMS did...

Hi,

I get the object id, it stopped working when I updated the management studio, i think it is not the code, but rather a new thing i need...

You code works correctly when I changed that table name to a test table I made specifically for the...

Let's do what Steve did (and nicely explained/demonstrated) but on steroids.

First, we need a very typical million rows to test against...

--===== Create the test table. 
 ...