Thanks, what is IMO

Thanks that is quite a little trick.

Most of time I will use update query to do that.

But sometimes for some data entry issues, I found this is a quick way to edit the data quickly.

I don't...

Checked our data, if there is an apartment it will have apt#, so your query will work for me, will do more test, thanks much

Thanks, that is part...

Thanks much,

Thanks much,

A question about SQL browser, we have a cluster.

On node1 it installed two instances, one production, one QA.

The browser recently keeps stops, causing front end sharepoint not available.

I have...

Elliott Whitlow (6/19/2013)

---

I would consider it 2 complete SQL installs, except that the point to a single set of system and user databases. So in that regard yes there are...

Elliott Whitlow (6/19/2013)

---

You have two installs of the binaries for SQL, one on each node, the databases are available to only a single node at a time. So no you...

HanShi (6/19/2013)

---

It does a full installation of...

HanShi (6/19/2013)

---

It looks like the steps you mentioned are correct. From my point of view only one thing is missing:

Before applying the servicepacks I would shut down the Sharepoint sites...

Thanks, I saw the link provided above too. That scares me, it seems we have to uninstall SQL server totally, it will be a long process , esp. for a...

Thanks that is what I suspected too.

But I did a readerror_log 'recovery' and found that was a week ago.

The change is a bulk-logged backup.

But the full backup is on...

THanks, that is what I found out.

No alias name.

Ignore my recent post, removed