Using <= in that one will be the opposite of what you want. Use Drew's last example. No reason to overcomplicate this.

Have you checked things like the error log?

SSRS logs errors to a file in the installation directory. It also has, if I remember correctly, an execution log in the...

I must also be missing something. What's wrong with the solution you already posted?

Usually, the application needs to have that built into the data access layer (DAL). It either checks a heartbeat for the primary and, failing a response on that, changes...

If you're using "SELECT @Trigger", that's a result-set, not an output parameter. Change to a simple result set, and map it in the options.

What kind of standards?

Standard coding?

Layout and readability standards?

Best-performance standards?

ANSI standards?

Coding standards are on MSDN (and in Books Online). These often include notes on best/worst use.

Layout and readability standards depend...

Multiply the hours duration by 3600, the minutes duration by 60. Total those up with the seconds, and you have a total seconds of duration. Even easier, skip...

Change SINGLE_BLOB to SINGLE_CLOB. BLOB is for "Binary Large OBject", CLOB is for "Character Large OBject". Using the BLOB version makes SQL Server assume it's binary data, which...

When I used to be in sales and marketing, I made sure to include drawbacks, costs, et al, in the negotiations. Wasn't selling software, but it was still sales...

iPolvo (1/4/2012)

---

paul s-306273 (1/4/2012)

---

In my experience all sales staff over exaggerate the merits of the software that they are trying to sell you. Only the non-IT people are easily duped....

This should be a new post, not an addition to a post from 2007 on a somewhat different subject. But, to answer your question, no, that's not what that...

Brandie Tarvin (1/4/2012)

---

On a slightly different note, I was looking into some linked server issues and found a comment in this Microsoft article http://msdn.microsoft.com/en-us/library/ms188279.aspx that MS doesn't recommend the use...

Cool.

Is it anything you can post here?

sqlvogel (1/4/2012)

---

From a SQL developer's perspective it is tempting to assume that data integrity should always be enforced by the database. Unfortunately SQL Server (like most SQL DBMSs) is only...

I've never yet seen an application correctly validate all the data being fed in through it. Most? Sure. All? No way.

Just ran into a situation where...