Stan Kulp-439977 (8/7/2014)

---

shah.muhammad (8/7/2014)

---

Bulk Insert works in most cases but if your operation is based on sequence, you can't rely on bulk insert as it loads the data from the...

shah.muhammad (8/7/2014)

---

Bulk Insert works in most cases but if your operation is based on sequence, you can't rely on bulk insert as it loads the data from the file regardless...

Thanks for the article. Can you please clarify how you configured the computer object?

the Trusted for Delegation property was then visible for the SQL service accounts, which I enabled....

Nice question. Thanks for provoking some research on a feature new to SQL Server.

Hugo Kornelis (7/28/2014)

---

...I then tried running it and found that I had to make a lot of code changes to even get it to work. I had to fix the...

Jeff Moden (7/24/2014)

---

opc.three (7/24/2014)

---

To anyone reading this article and subsequent comments, know that BULK INSERT introduces problems and carried with it many more hidden limitations than it offers benefits. BCP...

To anyone reading this article and subsequent comments, know that BULK INSERT introduces problems and carried with it many more hidden limitations than it offers benefits. BCP (the command-line counterpart...

Jeff Moden (6/21/2014)

---

"It Depends". I think of it (and virtually any programmable product) as more like a mirror and it's color is dependent on the imagination of the person...

+1 for SSIS

You can implement the SSIS Catalog (SSISDB) in SQL Server 2014 and execute a Package from within your own stored procedure using stored procedures provided within the SSISDB.

Deploy...

The UPDATE...JOIN construct can yield unexpected results. Usually a safer way to handle these tasks is using the MERGE statement because it protects you from updating the same row multiple...

Sounds like a reason to move away from xp_cmdshell. What is the executable doing and can it be hosted on a machine other than a machine hosting SQL Server and...

Check out system stored procedure sys.sp_altermessage.

Not a problem. You just need to string (pun intended) a few concepts together to arrive at a solution. Look for rows in the table where the expiry date is...

I do not think that information is captured anywhere by default. An Extended Events session or Server-Side Trace could capture the error information and tie it to a specific Login.

Another,...

The trigger, if it were the only DDL trigger in place, would only create a minor nuisance for someone who really wanted to get an illegal name into place. Consider...