Hi,

I have few more questions too.

I have also few Databases coming from one DB server and other one DB coming from other DB server so I will be...

I will be building brand new test enviornments ans need to restrict user for security purpose so need to create Group for each Role

anad assign user to each Role Group,...

Thanks So much.

I have another situation that my developer wants some tables from Prodction DB server to their desktop m/c.

We have already sql express installed and Database and tables ae...

Thanks Jeff.

When i do again Database Refresh on a By Weekly or Monthly, so i need to follow the same steps or is it any other approach or method? I...

Thanks so much for your prompt response.

We are taking back up - differential back up daily and during week end we take full back up.

We have 4-6 DB on one...

Thanks.

If you provide me the link or any guide lines to set up alert that will be great!

Regards,

Thanks, let me do some analysis and i will get back to you!

Thanks so much for your detailed answer. I am completely agreed with you that is poor written code.

Its our turn to rewrite the code or fine tune it.

Could you give...

Thank you very much!

I got it the same way but really appreciate your help!

Hi,

I found the stored procedure but when i set up the DBMail and job notification, lof shows that it ran but its not sending me an email.

I tried to cross...

Thanks Adams and Jack, i will look the script secion.

Is it onlt sql monitioring script or it has volume level script also?

Thanks.

You are right, i don't want to create index on other columnd because it wil slow down my Inert as i have mostly Insert activity.

Thanks for help!

Thanks for your tips.

Are you suggesting to add indexex on all the select columns or all the FK columns?

Thanks for your JOIN query suggetion and Index tips.

I know from oracle that we should create index on FK columns but i was little confuse for Sql server.

I will use...

Query:

select A.DTrackID, A.DVersion, A.Version, A.Locale, A.OS, A.OSLocale, A.CId,

B.LId, B.LType, B.PLCount, B.PJCount,

C.PId, C.Model, C.Local,

D.SId, D.Starttime, D.Stoptime, D.Source

from

dbo.DTrack A, dbo.LTrack B,

dbo.PTrack C,...