because you are appending fields to each other, if any value is NULL, when sent to a text file, you end up with blank rows.

i'd start with bulletproofing the query...

i'd start with the basics: who has sysadmin, who has db_owner and in what database.

grab a copy of Brent Ozar's sp_blitz, and run that, it gives a nice, quick overview...

what i would do:

change the alert to call a stored procedure.

Have that stored procedure insert details into a table.

have a separate job run every two hours that emails you a...

hmm; how big is the attachment, then? what is the attachment extension name? or at least how many rows in the query?

specific mail servers often have rules on attachment size,...

Mailbox unavailable implies the wring target email ;you are sending to a full email address, right?

you must be sending to "happy55@somedomain.com", and not hoping exchange will convert "happy55"...

i liked the suggestion above, to create a view which includes @@Servername and db_name() as columns.

did you try it, or can you say why that will not work for...

it doesn''t work is pretty vague;

It sounds like you are sending, but the mail doesn't go through; that's where you want to look at the mail logs and see what...

meerack11 (6/19/2015)

---

I had try like if I enter new data like gl code CA700-40165_Home Dt Canada - Expedited Air' then its work but old data which already in table that...

and that would be normal. equal means equal, not...

As Alvin said, one of the strings has an extra "4" in the middle; if the texts are lined up, it's easy to see.

select * from Gl_code_data where Gl_code='602-43335_Planning -...

I'd bet the issue is unqualified database name;

@query= 'EXEC test,

needs to be soemthing that can be run form another database context , ie msdb or master

@query= 'EXEC SandBox.dbo.test', would probably...

mark.dickinson (6/18/2015)

---

Lowell (6/18/2015)

---

i think a logon trigger is the wrong device in this case.I don't think the database named in a connection string has much relevance.

i think the OP is...

i think a logon trigger is the wrong device in this case.I don't think the database named in a connection string has much relevance.

i think the OP is really looking...

there's no guarantee that EVERY row contains the search term, so you need to include that check in your WHERE.

update MyTable

set Description = LEFT(Description(CHARINDEX('<',Description)-1))

where CHARINDEX('<',Description) > 0

AND myid...

yeah i'd go programming language on this, whether SSIS, Powershell C# ,VB.Net, or whatever you are

comfortable with.

As Eric said zip functions and conversions are not native to SQL, so you...