Hi,

Thanks for the reply.

To Provide High Availability of the Database. We thought of establishing this aspect.

I was refering the Document from net with the name ReplicationAndDBM

With Regards

Dakshina Murthy

I am HAving SQL server 2005

Even i would like to have the Hot fix downloaded, i am not getting the link from where to download.

In My scenario, i had a...

Hi,

Was there any thing wrong in my question, if so please let me knew. I am new to this. So i am not getting it.

I have obsorved few things, i...

Hi,

Here i am attaching my scenario example with the explaination, please do the need full.

With Regards

Dakshina Murthy

Hey Thanks for the reply,

But what i want is, is there any way where in if records are present in the userprofile table then only it should have left outer...

Hey,

Thanks a lot for the reply, i will try working on this, Thanks for the input once again.

With Regards

Dakshina Murthy

Thanks a lot i will check with this, sorry for asking how to restart the sql server, i would like to restart the sql sever agent.

With Regards

Dakshina Murthy

Hi,

There is nothing like a home work or copied the same thing, i came across this and i have posted, may similarly the other guy might have also come across...

Hi,

Thanks a lot for the guidance and showing the way to learn, i am really happy, definitely i will read this.

Thank you very much

With Regards

Dakshina Murthy

1. Do you have indexes on those tables.

Answer: Yes we do have...

Hi,

The page counts are less than 1000. Thanks a lot, it was really helpfull for me. Thanks for the instant reply and help.

With Regards

Dakshina Murthy

The size is in KBs,

Hi,

Thanks for the help. I have excuted the Rebuild Command for certain tables (20 + ) whose avg_fragmentation_in_percent varies from 35 to 80 for certain tables. Even after rebuilding indexes,...

Hi,

Thanks for the support, i have found the query to find the lines of code in a Given SP for a DB in the following Link, this will be usefull.

Hi,

Thanks a lot for the reply, if you dont mind can i have the sample of the script which will restart the agent.

Thank you

With Regards

Dakshina Murthy