The first thing you should do is download and run the Microsoft SQL Server 2008 Upgrade Advisor. Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and...

Sample script for Database mirroring

Video for Db Mirroring

You can use Database mirroring or Replication....

matt.newman (10/12/2011)

---

Check to see if there are other jobs with that same service account that are failing or if anything else uses that account where the permissions could have changed...

By default the 32 bit Operating System (the Kernel) can only use up to 2 GB of Virtual address space (VAS) leave 2 GB of Virtual address space for...

As I said there wasnt any problem with code itself.... the problem was at Linked Server Server Options...

Please find attachement....

Perry Whittle (10/12/2011)

---

Heartbeat and private are the same!

I assume you...

I was using this code to list all Indexes from linked servers..... but IT shows only system defined indexes...

I am using SQL Server 2008 R2

IF EXISTS(SELECT * FROM

SYSOBJECTS WHERE...

You can use

select * from sys.syslogins

exec XP_logininfo

My perspective for using cursor is.... In one query it should give all indexes information for all linked servers.... hence i m not using Instance name....

Yes You will need 2 ip's (Heartbeat IP, Private IP) for each node & 1 Ip for SQL server.

first of all thank you for your reply....

I am creating an Inventory Application for all Linked servers... for that I have scripted rest all things like DB info, logins, Drive...

Is there any negative scoring for the wrong answers.... ???

Christi Wilson (8/25/2011)

---

Saga... (8/25/2011)

---

Christi Wilson (8/18/2011)

---

Hi everyone! I hope some of you can help me out.

I was a database programmer for 6 years and due to illness I had to...

Christi Wilson (8/18/2011)

---

Hi everyone! I hope some of you can help me out.

I was a database programmer for 6 years and due to illness I had to take about 6...