If you go to the My Account page, and then the Forum Control Panel (shortcut here: http://www.sqlservercentral.com/Forums/ControlPanel.aspx), you can view your Forum and Topic subscriptions. It's a little ways...

Can you copy and paste what SQL Server is suggesting into a post here? Would help.

create table #T (

Col1 int);

insert into #T (Col1)

values (1),(2),(3),(4),(5);

Like that? Or something else?

Not being a SAN engineer, I really don't know. But if it works, you're fine. Test it with a small dataset and a few files.

S_Kumar_S (5/1/2012)

---

The from end will be a SSRS report(2008 R2). And I think it should be supporting the font if sql server 2008 R2 is supporting it. As I mentioned...

The connections in the SSIS package will have that. Double-click them. The connections are usually in a window at the bottom of the screen in BIDS.

As far as understanding Scrum goes, you'll be better off researching it yourself. There's a lot to it. It's mainly about breaking things up into pieces that can...

Scrum meetings with business stakeholders and sprints is how I prioritize. Some projects take more than 1 sprint, moreso for a DBA than for a dev, but the basic...

The error message says column ACT_REC_ID is longer in the source than in the destination, and is hitting a truncation error.

I think you just need to install the 32-bit JET driver to do that.

Are you appending text files to each other? Or something else?

With text files, in C#, there's a File object with an AppendText method, if I'm not mistaken.

It's storing the character, but SSMS doesn't display it. What front-end will the actual application use, and does that front-end support a font that displays the symbol?

Try this, see what you get:

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T ;

CREATE TABLE #T (X XML) ;

INSERT INTO #T

...

capn.hector (4/30/2012)

---

The OP was talking about Windows Server not SQL Server being the limiting factor the...

BarbW (4/30/2012)

---

I think I finally identified the problem...the server with SQL 2012 is new to our network and it was not added to the DNS servers correctly. I found this...