Think so , thanks once again 🙂

check if the server is on network by using ping, then create a linked server, then there shouldn't be a problem in accessing this server, hope this helps

Thanks BU69, i will give it a go , by the mean time is there any other option that i have on this solution that you can think of 🙂

thanks , i tries from SQL 200 - SQL 2005 that was then i had this experience :-), do you think 2005-2005 is stable and worth giving a try 🙂

Hi Anand

What are you trying to achieve by creating a duplicate rows for all the values that u...

Hi

There are various ways to migrate a server, well the first thing i will ask is how much down time...

Thanks mate, but there is one main problem, i am using a 64 bit version of SQL 2005, which is not allowing me to use OLEDB, is there any other...

Thanks , that will make my job a step easier, 🙂

you dint mention the version of SQL you are using , i am assuming that this is 2008

Thanks mate,This is what exactly i have done now in my SP, but i am quite interested to know if there are any other ways to incorporate this on the...

Thats Great , Thanks mate

Thanks Guys

I can use it, but i am not sure how to use it on...

Thanks Mark, this is an interesting new dimension, Looks great, i will work on this and let you know my result

Cheers

🙂

Wow 60 minutes, you are lucky winston, never had that window to do something, As marcus suggested, until there is a transcation on the primary server the logs, it will...

Thanks mate, there are some ascii characters which i need to check them , its a good idea, but i need to implement this on the live services at some...