First step is to add the instance on ServerB to ServerA.

Do you mean i need to run setup to install fresh instance on Server A? Since Server A has...

One thing i forgot to mention is that; at present Server A has only one instance installed. So assuming first i need to install second instance on Server A, i...

I personally experience this one time. I was appointed by a mid size company (50+ employees) where there was never DBA appointed in their history. I did knew this during...

I personally experience this one time. I was appointed by a mid size company (50+ employees) where there was never DBA appointed in their history. I did knew this during...

sorry for confusions. See the two queries below which exactly are same except one uses INDIA and other uses PAKISTAN. Like indian and pakistan,k I want to run this query for...

Thanks.

It is in table and the query should run for each value in table just as 'India' in above query. I just don't want to run the above query for other...

Thanks. The problem is they charge and our company is very poor to pay this charges. My boss feels that this is a dba work.

Hi,

I have a similar problem. should i sent sqldump file? pls guide me.

I run SQL Server 2000 with SP4 with OS Win 2003. I found this error in event viewer. I am assuming that some procedure was running at this time.

Pls help...

Hi Jason Deyalsingh

How do i setup this vb script. Do i need to create a small vb app? pls. guide

sorry. windows alert on sql server agent stopped?

How can i setup Windows Alert for this?

hey guys,

do you think there could be any issues related to replcation or something else if i upgrade my primary server with SP4.??

Hi, BobAtDBS 

Can u help me in creating this script.

Thanks guys for all your efforts. Can any one tell me how i can setup alert on windows server to check the status of sql server services. This alternative looks...