Gianluca Sartori

That worked. thx.

Dan

CEWII

I login in through Win Authen; so I do not see my login in under Security->Logins

Dan

Thanks happycat59

GSquared

When you post scripts like that, do you put it in the Articles section in SSC?

Thanks

Dan

Slick

I monitor it throughout the day for every hour using a job.

So I have record of what it is, 24 times a day for 3 months. So I can easily...

1)The index files are all chosen to be seperate from the data file and is saved as .ndf. I had mistaken that dm_db_index_physical_stats checks only the fragmentation in the index...

Can I select (Cherry pick) just the SP's I need from SSMS 2005?

GSquared

When you say the rebuild task - it is the Alter Index Rebuild and Reorg, right? that is what I was hoping the code from MS will do for me...

Gail

Thanks for the useful article.

Other than slowing down the DB, does it also cause lot of fragmentation?

Also what is the best way to estimate the ideal size of the log...

Ian, Thank you. Both your ideas are good. (UNIQUE & trigger).

I will probably use trigger or the (-) idea of Ken's for this.

Ken

Sorry , I had missed the (-) part. It is brilliant.

Dan

Ken

ARS_No is not nullable field. So it does have many '11111' values which is the default when there is no ARS_No to enter. (From now on, with new code, this...

My main and only emphasis right now is that ARS_No does not get entered in Staff_in_EDT if it is not in tbl_person.

If it was unique in tbl_person, I would...

Ian

If I make the two columns part of the primary key in tbl_person, will that help me to add the FK lookup? (3 columns in the new table looking up...