The PowerShell step type runs commands in a mini-shell called sqlps.exe which is not the same as what you get when you open a PowerShell prompt using powershell.exe so results...

james marriot (1/2/2013)

---

Do i need to explicitly say SET TRANSACTION ISOLATION LEVEL SNAPSHOT; in each batch that i want to operate under Snapshot isolation?

I altered database

Set Allow_Snapshot_Isolation ON, but even...

You may need a Data Conversion Transformation your Data Flow in between your MySQL ADO.NET Source and your SQL Server OLE DB Destination.

timscronin (1/3/2013)

---

Proof of concept would be about 100, but if it flies could be 1000, THinking of doing the proof version on BI and see if software vendor if...

$9K/server + $209/user allows for the lesser of 4 sockets or 16 cores & 64GB of RAM for BI Edition. That could be viewed as a bargain when compared to...

Please post the table definitions including all indexes and constraints.

The clustered indexes you chose for ClientOrder and ClientLine are not ever-increasing so you will incur page splits as clients add orders to existing pages, which is not going to...

Sqlism (1/3/2013)

---

Hi Experts,

I created a named instance, I am a DBA , i can connect to named instance using SERVERNAME\INSTANCE name, but none of the developers are able to connect...

I've seen differing opinions from MVPs about the best way to submit BOL feedback. One said Community notes, one said Connect.

SQLRNNR (1/3/2013)

---

JAZZ Master (1/3/2013)

---

SGT_squeequal (1/2/2013)

---

crookj (1/2/2013)

---

Daniel Bowlin (1/2/2013)

---

In the immortal words of Uniblab

"Back to work (click), back to work (click). Everybody ( click) work, work, work, work (click), work, work...

Referring to the link Anthony provided, at minimum I would recommend applying this security update:

* 9.00.50572005.90.5057.02494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4...

Thanks, Lowell. SQLCLR is a powerful tool, to be sure. You know where I stand on the topic already but I am curious now, can the assembly you created be...

You continue to amaze. Thanks for the info, Gail!

As an aside, I added a Community note to the 2008, 2008 R2 and 2012 Books Online pages. Hopefully that's the correct...

mbvnaveen5 (1/3/2013)

---

i changed the option Run64BitRuntime to false but still i am getting "could not retrieve the table information for the connection manager .Failed to connect to the source using...

Some scenarios where enabling remote DAC might be plausible:

- you are in a shop where the DBAs do not have Remote Desktop access to the server hosting SQL Server (rare...