Agreed, wrong section.

For SQL2008 support for parenthesis though...

SQL 2008 BOL for TOP - http://msdn.microsoft.com/en-us/library/ms189463.aspx

Parentheses that delimit expression in TOP is required in INSERT, UPDATE, MERGE, and DELETE statements. For...

That error is basically saying that the database server cannot resolve the host smtp.gmail.com [edit]or it simply can't reach the server if it is able to resolve an IP[/edit]. ...

Actually SQL 2000 does not allow you to paramaterize the TOP clause of a SELECT statement. You need to be running at least SQL 2005 for this, in which...

Can you paste the results of the following query? It sounds like there is something misconfigured in the alert. Just replace db_name with the database name and then...

Boolean_z (4/6/2009)

---

It still fails for me

Message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2009-04-07T08:45:10). Exception Message: Cannot...

Mark Sumner (4/6/2009)

---

smtp.gmail.com is the outbound from gmail smtp server. It will refuse your relay request.

If that doesn't work, you could try installing IIS...

Try this...

Use smtp.gmail.com for the server

Change port to 465

Require secure connections checked

Basic authentication with your gmail username and password (make sure you use the full email address for username with...

Just a warning for anyone looking for study material for this test. A friend of mine recently got the CBT Nuggets videos for SQL 2005 and he showed me...

Out of curiosity, what kind of action do you need to take on each result?

That is a perfect example of what I was talking about with being easier to read. I actually missed the NOT at first glance looking at your code! 😀

OK I think I see what you are asking now. You could try something like this if I am understanding you correctly.

DECLARE @result TABLE( data varchar(100) NULL )

INSERT INTO...

If you view the query plan for not(a=b) vs for a<>b you will see that the predicate is evaluated as the same thing. The CPU cost is the same...

You may want to check out the thread over here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648 which talks all about split functions and the best way to handle the scenario. I have a feeling...

I have had to do this before, pretty simple. See the following...

xp_cmdshell"net use t: \\10.10.10.10\share_name password_here /user:username_here /persistent:yes"

/* Add extra code here... */

xp_cmdshell"net use T: /delete"

You shouldn't have a problem with using varchar and CHAR for the characters you are talking about... see the following...

Running this code...

DECLARE @i int

DECLARE @STR varchar(222)

SET @i =...