Jeff,

I have yet to come across a bigger company where they didn't have SOME off the shelf software. Which is kind of my point, if you are running purely...

thierry.vandurme (11/22/2013)

---

This is a re-published article and the last replies date back from 2012 but I'll throw my remark in anyway.

CLR is all nice but I still think it's not...

How many files are we talking?

if its less than say 20 its probably still pretty easy to use SSIS.

2008/2012 in this case is about the same..

CEWII

SQLSteve (8/7/2013)

---

Reduce the max memory allowed for SQL.

Personally.. If other applications require large amounts of memory, I would put them on seperate...

Yes, both are "merged" and as the other poster mentioned denies take precedence.

CEWII

Your scenario is quite complex but I think I can answer your question.

Since the 2008R2 and 2012 clusters are indeed different clusters and for AlwaysOn the remote machine will need...

You are very welcome, glad I could help. SSIS has a fairly steep learning curve. Some of the other topics are even steeper.. Good luck..

CEWII

I can't answer why there are two spids, that clearly says TWO connections to me, if your web service can get two calls at one I bet it can create...

Saintmount.Sql (8/2/2013)

---

Hi,

I’m executing the Procedure thru SQL execute task along with input Param( which will retrieved from another SQL task).

EXECUTE Proc_GetVal @a = ?,

cgreathouse (8/2/2013)

---

I have a stored procedure that takes a number of parameters. It will first check to see if a record exists based on the parameters. If a...

The error tells me you have something set to expect a variable name BUT you are passing it a command.

I actually see several problems.

The Variable User::TruncateTable is incorrectly formed. ...

Its really tricky, I would probably talk to MS directly and if possible get it in writing.

Good luck.

CEWII

I think your primary issue is that I think for AlwaysOn all of the machines have to be in the same Cluster for automatic failover. Always on is...

lostdisk (7/29/2013)

---

CEWII-

Thanks for the amazing response, and depending on if the one way endpoint would need a CAL or not, would be dependent on if I can make my case.

In...

Found the licensing guide (more detail than the datasheet) and found this: http://www.microsoft.com/licensing/about-licensing/briefs/multiplexing.aspx

Your one-way example seems to fit into Figure 2 on page 2 and would not require a CAL.

CEWII