It sounds like an intermittent network problem or a resource contention/availability problem, so you're probably going to have to get your sys admins involved.

If you have Standard, BI or Enterprise...

Knocking up some easily consumable sample data would help people to provide better answers, but what you're trying to do would require either dynamic SQL or picking an arbitrary maximum...

Why not just create the solution/project in your scripts folder in the first place, then your project folder and scripts folder are one and the same?

Yep, that's the problem, the PTR record must point to your domain's MX record or Reverse DNS will fail. There's no other way around it that I know of...

As far...

I'm pretty sure this needs to be resolved by the provider of the IP that the mail is getting sent from (e.g. your host).

Specifically, it needs to have a...

It's not relevant how many rows were actually returned, it still has to access a range in the index if it's not marked as UNIQUE as it doesn't know how...

Lynn Pettis (8/9/2012)

---

That's where you build a database agnostic DAL and your actual database layer is written to support the RDBMS of choice. To provide a system that performs...

EdVassie (8/9/2012)

---

Does your business know how much cost and time they are adding by forcing people to write code that can run on multiple types of DBMS?

This is...

I don't have an environment to test on at the moment, but I suspect as it's all submitted as one batch, there's an outer (implicit) transaction that's for the whole...

The relative cost is an estimate. In this case, the cost of the parameterised query depends on the relative distribution of whichever value happens to be fed in as the...

Yes INTEGER is supported. The smallest mutually available data type for this would be CHAR(1) (which is 1 byte in each) and you can use Y/N or T/F or whatever...

Because it's not a UNIQUE index, so it's retrieving a range of values that match your criteria rather than a singleton lookup.

This new syntax was only created with SQL 2012. you need to use sp_addsrvrolemember in 2008.

Compare the two articles for 2008 R2 and 2012 and it makes sense. The syntax...

Your question is a bit vague. Primary Keys and Sequences don't have much to do with one another.

Are you talking about adding the equivalent of an IDENTITY column to a...

You'd have to either:

1) Use a script transformation task (this is just pure .Net code), then just use one of the examples of converting a bmp file to a jpg...