Sending mail from code in the application is, most of the time, problematic. A typical approach is to insert a message into a queue table, and have a separate job...

Trelin (1/27/2015)

---

Actually, this trigger is...

Instead of calculating them, try this table,

http://www.sqlservercentral.com/scripts/Date/68389/

These questions all appear to be written by someone who has worked with Access, especially all of the "over the network" questions.

I can relate to being in a small shop....

There are numerous splitter functions out there.

The example you provided uses a loop.

If you read the article, the performance of a loop splitter is significantly worse than...

There is no better splitter function!

Enclose the table name in square brackets

.

SELECT City, Country, Population

FROM tblCities

WHERE EXISTS (SELECT SP.item FROM dbo.DelimitedSplit8k('London,paris,new york',',') SP WHERE SP.item = tblCities.City)

OR...

Start here.

http://www.sqlservercentral.com/articles/Tally+Table/72993/

My question, I suppose, has more to do with UDTs in general. I can store the IDs as VarChar(n), or create a UDT and add a Rule to it. Yes,...

Why are you making up some sort of artificial value?

What does 3-9 in the first digit stand for? If this stands for something like a "parent type",...

Jeff Moden (9/3/2014)

---

JimAtWork (2/3/2014)

---

I have the same challenge and I have to query thousands of servers many of which do not allow the use of OA_ and also do not...

Is the problem that on a regular basis your rights are removed from the server?

The bigger question is why.

Is this production? If so, and you...

Try it out. Create a series of procs that generate errors.

See what happens.

The errors bubble up.

Put the parent proc in a try/catch also.

A procedure will return 0 if it is successful, and non-zero if it fails.

In the parent proc, you can do this:

DECLARE...