those set options are connection specific; they are not server wide.

just because you set it someplace, does not mean it's going to affect jobs or anything else on the...

probably the best most recommended way would be using the delimited split function.

there's also a CHARINDEX2 custom function you could use as well.

/*

--Results

val ...

Jeff when i did a project using rssbus for quickbooks i ended up writing an applicati:-Don that read qb info into tables on my server, so i had snaphots of...

relaying is forwarding/sending to email addresses that are not administered by the specific server you are conecting to...for example, if my server is the google's gmail, then emails to @sqlservercentral.com...

this is a job for a programming language; here's an example in vb.net for the...

we don't know what your preferred programming language is;

here's a link to an article on how to make a registration form in asp.net;

if you prefer php or something else, just...

--three char table: bigger range

CREATE TABLE X(XID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CHECK ((XID> 0) AND (XID < 17577)),

XCALCULATED AS

CHAR(((XID -1)/...

besides Seans sage advice, noone on your side has thought through possible max values, right?

if you force a min length of 3 characters, and also a max length of three...

if just the IP, is specified, then the instance that answers is whatever is listening on Port 1433.

you can see it in SSMS by connecting to each instance and finding...

sql-lover (10/19/2012)

---

Apologies,

Maybe I am not following, or I am not explaining myself properly, but I do not see the reason why we cannot elaborate an answer with the two column...

skb 44459 (10/19/2012)

---

Thanks for the reply.

Another Quick Question. My Email body is very long.

Ideally i would like to store the Body in a text file and read the text file...

here's an example of what you are asking;

you'll have to use a cursor if you want to send emails on a per-email basis from the data.

remember that when you assign...

you would have to uninstall 8 different cumulative updates, it looks like to me:

from http://sqlserverbuilds.blogspot.com/

see the number of rows different...

sql-lover (10/18/2012)

---

Like I explained, the PK is a surrogate key. MS-SQL needs to generate the key itself, no manual intervention.

The real tables are more complex. I just simplified it using...