Any way to determine last optimization Run..

Is there any way on a SQL Server 2000 db to determine when it had the
last optimization run on it?
Thanks.
Check the Agent history?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"newsqlman" <ndittoo@.yahoo.com> wrote in message
news:1182280108.117724.142340@.o11g2000prd.googlegr oups.com...
> Is there any way on a SQL Server 2000 db to determine when it had the
> last optimization run on it?
>
> Thanks.
>

Any way to determine last optimization Run..

Is there any way on a SQL Server 2000 db to determine when it had the
last optimization run on it?
Thanks.Check the Agent history?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"newsqlman" <ndittoo@.yahoo.com> wrote in message
news:1182280108.117724.142340@.o11g2000prd.googlegroups.com...
> Is there any way on a SQL Server 2000 db to determine when it had the
> last optimization run on it?
>
> Thanks.
>

Any way to determine last optimization Run..

Is there any way on a SQL Server 2000 db to determine when it had the
last optimization run on it?
Thanks.Check the Agent history?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"newsqlman" <ndittoo@.yahoo.com> wrote in message
news:1182280108.117724.142340@.o11g2000prd.googlegroups.com...
> Is there any way on a SQL Server 2000 db to determine when it had the
> last optimization run on it?
>
> Thanks.
>

Ansi_Padding Question

Hi all,
How do you determine if ansi_padding was set to on or off when a table
was created? Aside from inserting a record with trailing blanks, I
can't seem to find an answer.
Thanks,
Terryif (@.@.OPTIONS & 16 = 16)
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Terry" <wondermutt@.sbcglobal.net> wrote in message
news:6eee4aa9.0310031300.468ccb15@.posting.google.com...
> Hi all,
> How do you determine if ansi_padding was set to on or off when a table
> was created? Aside from inserting a record with trailing blanks, I
> can't seem to find an answer.
> Thanks,
> Terry|||@.@.options only helps you figure out the current value of ANSI_PADDING.
To check the value in effect when a column was created, use COLUMNPROPERTY
SELECT COLUMNPROPERTY(table_id, column_name, 'UsesANSITrim')
Please see Books Online for more details.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Terry" <wondermutt@.sbcglobal.net> wrote in message
news:6eee4aa9.0310031300.468ccb15@.posting.google.com...
> Hi all,
> How do you determine if ansi_padding was set to on or off when a table
> was created? Aside from inserting a record with trailing blanks, I
> can't seem to find an answer.
> Thanks,
> Terry