Gil i don't believe it is possible.

I'd seen this question a couple of times before, and here are some threads on the same issue.

http://www.sqlservercentral.com/Forums/Topic921933-391-1.aspx

http://www.sqlservercentral.com/Forums/Topic906015-145-1.aspx?Highlight=whoami

http://www.sqlservercentral.com/Forums/Topic905937-146-2.aspx

i had tried reading the registry of...

I think Jim Dillon has posted the definitive way to create a linked server to MySQL here:

http://www.sqlservercentral.com/Forums/Topic340912-146-1.aspx

he posted some really good instructions, and there's a lot of sharp questions on...

then the error is in the logic where you are determining the substring; does this return any rows?:

;WITH CTE AS

(

SELECT Field9,

...

the problem is in the data; at least one row does not have every charindex you are looking for:

select * from evCreateUser

WHERE CharIndex(''User Account Created'', Field9) = 0...

there is absolutely no advantage to storing dates as anything except dates.

never store datetime as any other datetype except datetime.

what is the date of the integer 20105404?

internally, SQL stores it...

depends on what "kind" of integer you want:

select convert(int,getdate())

--40332 days since 01-01-1990, SQL's internal start date

select YEAR(getdate()) * 10000

+ MONTH(getdate()) * 100

+ DAY(getdate())

--an integer "20100604"

i don't know if this will help you, as it's not a canned solution, just how I've done it in the past.

I created a simple vb6, and then improved it...

davidandrews13 (6/4/2010)

---

thanks for the responses.

so if i wanted to find out if 'lowell@davidandrews.com' exists on my own server how would i go about that?

lets say that the email in the...

no sorry Dave; all you can do is check that the format of the email is correct...[something] @ [a correct TLD]

If you have your own mailserver for davidandrews.com,for example, then...

you did not really provide any definitive requirements; your procedure is unnamed and your fourtables are pseudo names(TABLEA,etc)

here is some pseudo code that is the basics of what i think...

i bet the email is sent as html, and since html does not respect CrLf/Lf, you should substitute the <br /> instead:

Set @Job = 'The following opportunity has been changed...

uggg....you have a SQL server exposed directly to the internet? At our shop, we have a web server that is exposed to the internet, and it connects to a SLQ...

the devil is in the details, but here's my two cents:

use computed columns or a view which does the computation for you whenever possible.

i don't know if you've ever tried...

denying UPDATE at the table level prevents "smith" from directly updating your table with the statement UPDATE TableB SET somevalue = ''

if smith should not update tableB, he should...

also using roles is the recommended best practice for assigning permissions. If you do not want to use them, it's more likely you are not familiar with how useful they...