TRY_PARSE was introduced in SQL Server 2012. You posted in a SQL Server 2012 forum so...

cjmorelock (10/3/2014)

---

Great article. Thanks! What if your "drop folder" is an (s)ftp site? Do you know if it is possible to test whether a file available on a...

Alan.B (10/3/2014)

---

I know this was originally published a while back but I just read through it; it solves a problem I have been struggling with.

Very well written. Clear and...

ramana3327 (10/3/2014)

---

I have a table which has manufacturing date column but they use the varchar instead of datetime datatype.

Also that has the null values.

I need to get the id...

You may be able to, never tried it. Here is how I would attempt it:

1. Disable the restore job on the secondary but let copy job continue to run.

2. When...

The TUF (transaction undo file) is only important when you configure the Log Shipping secondary in Standby/Readonly mode. In NORECOVERY mode there is no need to maintain the list of...

vijayalakshmii.venkatesh (9/9/2014)

---

Thanks it worked fine..

but here instead of passing variable I wanted to pass the Result set Object in the argument .Is that possible or Can we pass via standard...

Can attach one or...

If you happen to get to the bottom of it please post back. It may help others cruising these forums, not to mention I would be curious to know the...

Eirikur Eiriksson (9/8/2014)

---

In order to advice any further on the subject, more information is needed, without the info on network topology, connectivity etc., it is pure guesswork.

Keep in mind that...

tonybogyo (9/8/2014)

---

opc.three (10/25/2012)

---

dave-dj (10/25/2012)

---

excellent and comprehensive article.

I only have a couple of questions..

first - if you where required to process multiple files per day, would you adapt this process, or...

If only more people took that one to heart.

Samba does avoid the FTP client issue: however in some...

When you say you saved to a file, if you used the SSMS file-destination of a query window you're probably subject to the settings regarding max text length that can...

lvbntapasvi (9/6/2014)

---

Hello All,

I am new to SSIS, and have started using it from the past 3 weeks. I have a task where in I am supposed to access the flat...

I'll second what Jeff said, you should never grant individuals the right to execute xp_cmdshell. I take it a step further and say you should leave it disabled on your...