anthony.green (11/1/2011)

---

http://kinecthacks.net/sql_kinection/

I stumbiled across this on Brad McGehee's linked in profile via twitter the other day and forgot to post it up.

I like the work the guys have done, but...

cool question

Rameumptom

Evil Kraig F (10/31/2011)

---

My pleasure. You're correct though, you do want NOCOUNT off, but that's standard for me (sorry, was pseudocode above). FMTDATA setting is...

We understand. 😎

Kiara (11/1/2011)

---

L' Eomot Inversé (10/31/2011)

---

SQLRNNR (10/31/2011)

---

GilaMonster (10/31/2011)

---

SQLRNNR (10/31/2011)

---

L' Eomot Inversé (10/31/2011)

---

Thomw (10/31/2011)

---

Thanks! I noticed that the thread has 'drifted' after my post and have edited to at least...

Essentially you would do the same steps as if failing over from the primary to the secondary - but you leave the primary in place.

So, break logshipping and bring the...

Lynn Pettis (10/31/2011)

---

Jeff Moden (10/31/2011)

---

isuckatsql (10/31/2011)

---

I have a simple SSIS package that reads a SQL DB input file, runs thru a script and does some parsing using regex, then updates...

Could you explain a little more?

I use stored procedures as data sources in a majority of cases without issue.

For server collation

http://msdn.microsoft.com/en-us/library/ms179254.aspx

For database collation

http://support.microsoft.com/kb/325335

And system databases in SQL 2008

http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

Ninja's_RGR'us (10/31/2011)

---

Steve Jones - SSC Editor (10/31/2011)

---

Congrats, Gail.

I am not putting as much effort into the discussions lately with all the travel. Not likely to change, either, so I think...

You found a case where SSIS is the wrong tool. You are doing transformations within the same database. If SSIS is installed on that same instance you could...

I agree with Sean, it is so much cleaner to define the table first.

GilaMonster (10/31/2011)

---

SQLRNNR (10/31/2011)

---

L' Eomot Inversé (10/31/2011)

---

Rather...

Sorry - no chance on that. Besides the app is java - and it has more bugs than .Net when trying to do this.

Not using reportviewer, but we are...