It seems I must have set a local path and not a UNC path. Just tried it again and it worked. (A Friday Afternoon Special).

Thanks for the link. I read the article but it warns that this would...

Thank you Phil. In all the years I have used SQL Server I have never used that option, worked a treat.

I am executing it directly in SSMS.

I had already tried altering the query results to grid settings. You can't increase the value of Maximum characters retrieved for non XML data...

Although I don't know what the cause of the problem is, the error is not referring to a table index. An array has been created in the process and some...

Perhaps you have installed a 32 bit version of Visual Studio or SQL Server, in which case you won't be able to set 64 bit.

I think you would need Visual Studio 2010 to support SSIS 2008

David Benoit (2/2/2016)

---

If you run sp_repldone, you will mark all the transactions in the transaction log as replicated, and logreader will now ignore them. So, if there have been any...

All I can think of is to make sure the last data line in the file is terminated with Cr/Lf or Lf depending which temination is used in the rest...

Phil Parkin (1/21/2016)

---

Tim ffitch (1/21/2016)

---

I can see where this would be useful for multiple environments on the same server. When dealing with multiple servers then it would be better to...

Koen Verbeeck (1/21/2016)

---

Tim ffitch (1/21/2016)

---

I can see where this would be useful for multiple environments on the same server. When dealing with multiple servers then it would be better to...

I can see where this would be useful for multiple environments on the same server. When dealing with multiple servers then it would be better to create your environments in...

In the Data Flow task have a look at the properties of the ODBC Source Task. You should see a property for Statement Timeout. It is Zero by default but...

Check out this link, page 9 and 10 where Dell set up separate LUNS for Data, Logs, Tempdb etc. It might give you some clues.

http://www.principledtechnologies.com/Dell/M420_database_0912.pdf

It might not be...

Just a few more thoughts. Look at the size of the TempDB files when the server has been up for a period of time. Make sure the initial size of...