I agree with Dan here (not...

I've now found several locations on the net that illustrate it is possible to have transactional replication setup between a SQL 2005 Publisher & SQL 2008 Subscriber so my question...

nellisjp (8/18/2011)

---

Any new connections should connect to whichever server is currently acting as the principal. As for existing connections, I believe they would need to be dropped and re-established...

Thanks for the response Lowell. I've got a DDL trigger that exists on the database in question, but as you've stated I think it's a DML statement and not DDL.

I'll...

Lynn Pettis (9/28/2010)

---

You can also point out the follwing:

Server A -- SQL Server 2005 Standard Edition Principal Server

Server B -- SQL Server 2005 Standard Edition Mirror Server

...

Steve Jones - Editor (8/6/2010)

---

I think exercise has worked well for me. We used to play ping pong, throw a football, etc. at work and discuss things. We solved a...

Hi,

I believe the following link answers my original question: http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx%5B/url%5D

Hope this is of some help to other people.

Dan

Elliott W (4/14/2010)

---

I was looking at it a bit ago and age is the only option. I guess I would ask why that is a problem? Disk is...

Elliott W (4/14/2010)

---

I have to admit I don't often see Log Shipping as a method used to maintain a Dev environment. I would ask why this is being done?...

I understand that it will potentially break the chain if a transaction log is deleted that is required for a restore to happen. The backups would be carried out every...

Robert O'Byrne (9/18/2007)

---

When using Reporting Services tasks to export to a flat file destination you have to create a <U>Flat File Destnation Task</U>. This task needs a <U>Flat File Connection...

Aha! A group had been added to the local admin group on the...

Sure have....have run into the issue of...

Thanks to you both.

George, I was not able to restart the SQL Server service the previous weekend. The aim is to do it this weekend. In the meantime I have...

george sibbald-364359 (9/23/2009)

---

I believe because the SQLagent kicks off the job BUT the backup command itself is run by the database engine therefore the SQL service account needs access.

Only a...