Unless otherwise advertised, yes. I do seem to remember a service pack that was released once that didn't have a fix from a CU, but that was quite a...

Brandie Tarvin (3/22/2012)

---

Lynn Pettis (3/22/2012)

---

Biggest problem I have is that he didn't even consult with the customer before doing anything. Sorry, but if I had a customer with a...

patrickmcginnis59 (3/22/2012)

---

Lynn Pettis (3/22/2012)

---

patrickmcginnis59 (3/22/2012)

---

UnbalancedKarma (3/22/2012)

---

http://www.codeproject.com/Articles/10135/Not-Another-C-Versus-VB-Article?msg=3050761#xx3050761xx

The article is the usual C#/VB snobbery and in-fighting but the linked reply makes some good points in the case for VB.NET.

Comparing the two is...

Elliott Whitlow (3/22/2012)

---

Lynn Pettis (3/22/2012)

---

The problem with doing backups across the network to a file server comes down to network issues. SQL backups do not handle network hiccups very...

Charmer (3/22/2012)

---

SQLKnowItAll (3/21/2012)

---

Charmer (3/21/2012)

---

Hi friends,

i try to run some T-SQL statements in ssms like insert and update left outer join with 5 tables...due to large records it takes too much...

Elliott Whitlow (3/22/2012)

---

You certainly can back it up directly to a UNC path.. However you need to have a security context to get there and LocalSystem isn't going to give...

If using BCP, you need to use the -h switch with the FIRE_TRIGGERs hint.

If using BULK INSERT (T-SQL) you need to use the WITH FIRE_TRIGGERS option.

If using SSIS, you need...

patrickmcginnis59 (3/22/2012)

---

UnbalancedKarma (3/22/2012)

---

http://www.codeproject.com/Articles/10135/Not-Another-C-Versus-VB-Article?msg=3050761#xx3050761xx

The article is the usual C#/VB snobbery and in-fighting but the linked reply makes some good points in the case for VB.NET.

Comparing the two is always invitation for...

You need the express edition with advanced services based on the comparision between editions.

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

Gazareth (3/22/2012)

---

Looks like you are filtering based on the aggregated COUNT(SERV.Reference) field in the select?

In that case, you need to add a HAVING clause:

SELECT SALES.UID

,SALES.Reference

--,SALES.SOStatusID

--,SALES.SalesOrderCategoryID

,COUNT(SERV.Reference) AS 'Number Of Service Orders...

Since we don't have access to your database and the data, it is difficult to answer a question the appears on the surface to be a data issue, not a...

Eugene Elutin (3/22/2012)

---

...

It all depends on the application/environment. I did database development where the sometimes the application handled the transaction (made several calls to the database running several stored...

How are you doing the bulk import, SSIS, BCP, some other method?

Brandie Tarvin (3/22/2012)

---

Lynn Pettis (3/22/2012)

---

Should I be surprised that people don't seem to comprehend the written word like they should? Perhaps I could have been clearer in what I...

Only way to know for sure would be to restore the source database from yesterday and verify that nothing changed between yesterday and today. You will want to see the...