Dhirju (11/28/2011)

---

thanks dev for your valuable inputs .

but i have already installed sql server 2008 with service pack 3 in anther windows server 2008.

now i want to transfer all...

In recovery, SQL Server roll forward commit transactions & rollback uncommitted transactions.

1) How can I find out the exact...

Please don't create duplicate threads...

http://www.sqlservercentral.com/Forums/Topic1212253-392-1.aspx

pushpi2000 (11/28/2011)

---

Ok procedure is not really an option for me.

I am just looking for a way to create (or alter) view without server checking for existence of it's dependent objects.

Is...

Planning a SQL Server Installation

http://msdn.microsoft.com/en-us/library/bb500442.aspx

How to: Upgrade to SQL Server 2008 R2 (Setup)

http://msdn.microsoft.com/en-us/library/ms144267.aspx

Jack Corbett (11/24/2011)

---

It's Thanksgiving Day here in the U.S., so Happy Thanksgiving to everyone who celebrates, and if you don't happy Thanksgiving to you anyway:-P.

I'm very thankful for the friendships...

Nope.... OP said 'We are converting our Database from ORACLE to SQL Server'

@Gail: Are you really a volunteer here in SSC? It’s hard to find such passion / dedication in volunteers. Hats Off to you!!!

Ninja's_RGR'us (11/24/2011)

---

GilaMonster (11/24/2011)

---

I'm off to the middle of nowhere for a few days (middle of nowhere also known as the Free State). Can you guys keep an eye out for...

Perry Whittle (11/24/2011)

---

[font="Arial"][/font]justify what???

each instance whether default or named require unique IP and virtual network name. The cluster group IP and network name are for explicitly that, the cluster group.

This...

Sorry to bother you Perry. I am just trying to understand for one default instance why do I need two IPs?

For example, try naming the hosts SQL01A and SQL01B. Then...

Let’s see ‘What else I have done...’

For Pocket Money:

$ Part-time Sales Rep (corporate accounts) for telecom

$ Part-time Technical Trainer (Computer Subjects)

$ Event Organizer / Manager (Corporate Gatherings)

$ Freelance Programmer (VB6.0...

same IP is not fine!

use the 10.10.10.21 IP for the instances virtual IP and DBCLUS for the instances virtual network name. Keep these unique from the Windows cluster group resources...

It might be helpful...

Error message when an application connects to SQL Server on a server that is running Windows Server 2003: "General Network error," "Communication link failure," or "A transport-level...

Exact same configuration (SQL Server)? Version?