I noticed something similar investigating the use of a stored procedure with two queries and switching. The sproc still appeared to alter its plan without a recompile. Not sure, but...

Don't think so. Someone posted a link to a util (bii.exe) in the resource kit to load images or binary fields.

Steve Jones

steve@dkranch.net

In 2000, I believe this is also stored at the database and table level. You might need to rebuild the table.

In EM, if you go to the table, right click,...

I guess DMO would work. Haven't tried it.

Could write something in VBScript to load each package and then resave it.

Steve Jones

steve@dkranch.net

Andy,

I am your father.

Steve Jones

steve@dkranch.net

you might have them. Consider that portland has both a Maine and an Oregon entry. The index structure could be more compact since there could be more cities under Oregon....

thanks for the update.

Steve Jones

steve@dkranch.net

2nd vote for that method.

Steve Jones

steve@dkranch.net

A few ways. If this is strict sql, I'd do

where datepart( year, mydate) = datepart( year, getdate())

and datepart( month, mydate) = datepart( month, getdate())

and datepart( day,...

select person, max( date)

from table

group by person

Steve Jones

steve@dkranch.net

Don't think it affects performance. Likely the parser handles this, so the query engine will not even see it.

I ALWAYS use aliases.

Steve Jones

steve@dkranch.net

can you post your code? I am not sure what you are describing?

Try this:

create table MyTable

(MyPK int

, MyID int

, MyChar char(4)

)

go

create trigger MyTable_Update on MyTable for Update

as

if Update(MyID)

...

No way to force this. Another argument for NT Authentication. Otherwise you'd have to write some process as suggested above.

Steve Jones

steve@dkranch.net

Pls don't cross post.

Steve Jones

steve@dkranch.net

Can you post what you tried alogn with some more sample data. Not entirely sure what you mean. Also include the table DDL.

Steve Jones

steve@dkranch.net