Really you want to post this as a new question for an in depth answer.

In terms of HA here, the SQL2k5 clustering requires the same hardware. IF you want a...

Rights granted to public are available for all users. This is usually a bad idea since it prevents you from setting limited permissions.

The information_schema tables are meta data tables. The...

Your question doesn't quite make sense and I'm not sure what I'm looking at in the lines with INFORMATION_SCHEMA.

Is there some code you ran or a dialog you see this...

Thanks , glad we got it working

Looks like ill advance. Was worried at the start of the day but things ce around nicely after an hour

Elliott Whitlow (12/6/2013)

---

SQL Logins are particularly tricky because internally they had a SID, it is possible to extract the logins with the encrypted password and carry them into...

Yes....

Lynn Pettis (12/4/2013)

---

There could easily be routers and firewalls configured that are preventing us from using Linked Servers. Lets just say this site is extremely tied down. I...

I'm not sure it's fair, though I'm not sure how much fairness I want in business. We don't have a lot here, with plenty of poor decisions by managers because...

Lynn Pettis (12/4/2013)

---

HowardW (12/4/2013)

---

Whichever port the remote instance is listening on, it's just...

djackson 22568 (12/4/2013)

---

Absolutely. What we don't want or need...

Markus (12/4/2013)

---

Friends of mine worked for a company that does this and the lowest rated employees are gone in year 2 if they don't improve. I don't know how...

Paul White (12/3/2013)

---

I have a copy of Itzik's book, and I can vouch...

Saw this today as well: http://www.theverge.com/2013/12/4/5173960/70-percent-of-american-silent-films-have-been-lost-study-shows

I have removed the article and linked to the book.

My apologies for the issues.