make drop-down checkbox wider

Is there a way to make my drop-down checkbox wider? I have a label that is a
concatenation of several fields and I'd like the user to be able to see all
of the data in a row.
Thanks!
StephanieOn May 7, 2:05 pm, Stephanie <Stepha...@.discussions.microsoft.com>
wrote:
> Is there a way to make my drop-down checkbox wider? I have a label that is a
> concatenation of several fields and I'd like the user to be able to see all
> of the data in a row.
> Thanks!
> Stephanie
If you are referring to the multi-select parameter drop-down control,
I'm afraid not. Sorry that I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Maintenance plans: online rebuilding of indexes...

I'm using SQL Server 2005 SP1 Standard.

On the Rebuild Index Task there is a checkbox at the bottom that says 'Keep index online while reindexing'.

Great I thought, I'll check that.

Later, when I tested the job, I got this error:

'Online index operations can only be performed in Enterprise edition of SQL Server.'

Why have that checkbox available to check, if I'm running a version that doesn't allow it? Where's the bug?

Thanks

Ed

I've entered a bug in our tracking database.

Thanks,

Mark

Maintenance Plan...what is it doing exactly?

I would like to know exactly what commands the "Maintenance Plan" is
executing behind the scenes when the checkbox Reorganize data and index
pages is checked on the Optimizations tab on the Maintenance plan. My
thought is that it is executing some DBCC DBREINDEX commands across the
entire set of databases selected.
SpencerWhat it does depends on the version of SQL Server you are using. In 2005, yo
u can clock in the
"display SQL" (or whatever it is called) button. But to be sure, use Profile
r to see what SQL maint
plan submits. In 2000, it uses DBCC DBREINDEX for all tables in the database
(regardless of
fragmentation level :-( ).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"stabbert" <spencer@.tabbert.net> wrote in message
news:1144850383.926367.95100@.z34g2000cwc.googlegroups.com...
>I would like to know exactly what commands the "Maintenance Plan" is
> executing behind the scenes when the checkbox Reorganize data and index
> pages is checked on the Optimizations tab on the Maintenance plan. My
> thought is that it is executing some DBCC DBREINDEX commands across the
> entire set of databases selected.
> Spencer
>

Maintenance Plan...what is it doing exactly?

I would like to know exactly what commands the "Maintenance Plan" is
executing behind the scenes when the checkbox Reorganize data and index
pages is checked on the Optimizations tab on the Maintenance plan. My
thought is that it is executing some DBCC DBREINDEX commands across the
entire set of databases selected.
SpencerWhat it does depends on the version of SQL Server you are using. In 2005, you can clock in the
"display SQL" (or whatever it is called) button. But to be sure, use Profiler to see what SQL maint
plan submits. In 2000, it uses DBCC DBREINDEX for all tables in the database (regardless of
fragmentation level :-( ).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"stabbert" <spencer@.tabbert.net> wrote in message
news:1144850383.926367.95100@.z34g2000cwc.googlegroups.com...
>I would like to know exactly what commands the "Maintenance Plan" is
> executing behind the scenes when the checkbox Reorganize data and index
> pages is checked on the Optimizations tab on the Maintenance plan. My
> thought is that it is executing some DBCC DBREINDEX commands across the
> entire set of databases selected.
> Spencer
>