trouble using index optimizer

#1

when I try to run the optimizer with this query analyzer selection it says
An error occurred when trying to run sql statement.

Got this the last 5 times trying to use index optimizer - the other times i
solved it without the optimizer but this time i would like to see what it
says.

select *
from dbo.finansbudgetposter_staging a, dbo.crossjoin_test b
where a.aktiviteter = b.aktivitet
and a.steder = b.sted
and a.formål = b.formål
and a.sagsbudget = b.sagsbudget
and a.standardspec = b.standardspec
and a.delregnskab = b.delregnskab
and a.finanskontonr = b.finanskontonr

#2

Hello michael,

You may be better asking this is the tools or programming group

Allan

Quote:

when I try to run the optimizer with this query analyzer selection it
says An error occurred when trying to run sql statement.

Got this the last 5 times trying to use index optimizer - the other
times i solved it without the optimizer but this time i would like to
see what it says.

select *
from dbo.finansbudgetposter_staging a, dbo.crossjoin_test b
where a.aktiviteter = b.aktivitet
and a.steder = b.sted
and a.formål = b.formål
and a.sagsbudget = b.sagsbudget
and a.standardspec = b.standardspec
and a.delregnskab = b.delregnskab
and a.finanskontonr = b.finanskontonr

#3

Thanx Allan

I'll try that...

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

Hello michael,

You may be better asking this is the tools or programming group

Allan

when I try to run the optimizer with this query analyzer selection it
says An error occurred when trying to run sql statement.

Got this the last 5 times trying to use index optimizer - the other
times i solved it without the optimizer but this time i would like to
see what it says.

select *
from dbo.finansbudgetposter_staging a, dbo.crossjoin_test b
where a.aktiviteter = b.aktivitet
and a.steder = b.sted
and a.formål = b.formål
and a.sagsbudget = b.sagsbudget
and a.standardspec = b.standardspec
and a.delregnskab = b.delregnskab
and a.finanskontonr = b.finanskontonr

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

trouble using index optimizer

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

trouble using index optimizer - 10-26-2005 , 03:22 AM

Re: trouble using index optimizer - 10-26-2005 , 02:32 PM

Re: trouble using index optimizer - 10-28-2005 , 07:43 AM