our devs would write code in 2000 which would look like

select col1, col1 from some_table order by col1

why they did this, no one knows. but it broke in sql 2005...

if you have EMC SAN's just use SRDF. we mostly go R/O when we have several hours of downtime and R/W when there is a few days, like when we...

why not just use SQL 2005 AS?

in my experience with SP2 you have to reboot both nodes since it will upgrade files on both nodes and the shared SQL files on the shared storage. it's pretty...

stupid auditors strike again

one of the recommendations they told us to implement is to require MS DTC for everything. changed it on a few servers on Friday and now replication...

if you are running windows 2003 you can check out the new http based replication. i forgot the exact name of it and you might need to set up IIS...

Matt Miller (12/15/2007)

---

Unless I skip that part in BOL, 1433 is not a telnet port, so telnet is going to fail....telnet is a specific application - so trying to get...

GSquared (12/12/2007)

---

I've actually used a SAN for SQL Server, and at first the admin (outsourced) didn't want me to have any say in how it was set up. He...

can you install SP2 again?

we had a similar issue and if you to the control panel and rerun sql setup there is a repair option that will allow you...

local security policy on the server in the user rights assignment

add the account that SQL is running under

so far we haven't secured SQL against anyone, but hopefully we will do it on some servers. we are also going to look at forcing people to use their local...

Philip Horan (11/28/2007)

---

Thanks guys. That explains why the consultant wants to mirror. Never considered a SAN for a shared disc array as I have never worked with SAN's. How does...

Philip Horan (11/27/2007)

---

Hi Matt. Servers fully fault tolerant (well as good as they can be):

Redundant Fans / PSU / Processor.........

Each server has 8 HDD Bays. 2 Xeon QUAD Core...

the old one was, but the new 64 bit one is nice. we combined several distributors to make this new one and it's faster than the old two combined

this is a monthly process so i was hoping to speed it up while keeping it only as SQL replication and not dropping the replication. table is close to 300...