What tool are you using to extract the data?

Jay Beta (3/15/2013)

---

You can also use SQL Server 2012 Always ON Availability Groups and using a secondary replica for reporting. This way you also accomplish redundancy and reporting at the...

It depends on whether someone ever changed the default connection in the MP.

You're quite welcome!

I suspect peer-to-peer would be practically impossible between MySQL and SQL Server. If you want to split reads and writes SQL 2012 has some great options within the Always On...

It's like...

Have you considered the costs associated with

1. Getting an unsupported configuration working initially.

2. Maintaining an unsupported configuration over time.

3. Splitting your development time and expertise across two platforms...the techniques and...

You're welcome. Thanks, you too.

In a Data Flow connect a Flat File Source to an OLE DB Destination. Then in the properties of the OLE DB Destination when the type is set to "Table"...

sa is like the Windows "Administrator" account for the instance. When logged in as sa you can do any action on the instance. Lots of people, including myself, like to...

Sure. Open a query window and on the Query menu select SQLCMD mode.

http://msdn.microsoft.com/en-us/library/ms174187(v=sql.105).aspx

What the code sample illustrates is that an AFTER trigger firing for an event listened for by an INSTEAD trigger on the same table will not fire that INSTEAD trigger,...

This thread seems to have gotten to the bottom of the behavior you are seeing:

http://www.sqlservercentral.com/Forums/Topic1430725-391-1.aspx

bugg (3/14/2013)

---

opc.three (3/14/2013)

---

bugg (3/14/2013)

---

GilaMonster (3/14/2013)

---

bugg (3/14/2013)

---

That is why I was looking into creating a new table with the addtional column then moving the data etc and finally doing a table...

That seems to be the ticket. The instead trigger is fired once, and the after trigger is what continues to recurse.

USE [master]

GO

ALTER DATABASE [YourDatabaseName] SET RECURSIVE_TRIGGERS ON WITH NO_WAIT

GO

USE [YourDatabaseName]

GO

IF...