ugg...i've inherited a couple of situations like this, where a field needs a Decoder Ring to parse out the secret values contained in the field...it's a pain since it doesn't...

what you want to do is create a VIEW that gathers this information on demand, instead of trying to update a static table with the calculations

try this working snippet:

CREATE TABLE...

the key is two parts: including a @query parameter = 1, and making sure the @attach_query_result_as_file = 0;

the only issue is if you wanted it formatted as each value being...

i believe it is because of the correlated subquery, where the inner query getting the TOP 2 is connecting to the outer query:

...

mrpolecat, with windows 2005 and up, you could easily use the row_number() function to get what you are after; you probably knoew that already.

For SQL 2000 it's not so intuitive.

Here's...

well in my case, I might be sending hxkresl@gmail.com,lowell@yahoo.com and jason.stephens @bing.com all the same email....

all those emails are going to be in a table with all my contacts, right?...

it's been a couple of years since this post was active; glad you found it.

since then, i put together a script to check for invalid objects; read this article, grab...

I had wondered why the table had those values...it didn't make any sense to me before, either...loked ugly in the results.

the issue:

the value in the field is a string which...

in my case, each of my profiles mirror the email accout they are going to send from...

without pushing my own sites on you poor saps,

i'd create one named "sqlservercentral"...

Here's a script that will create a procedure to help you script out any existing trace on the server; with that, you can tweak the script to make a NEW...

just hazarding a guess here, but could it be your SQL instance is 64 bit and the drivers are only 32 bit?

anthony.ventura (7/6/2010)

---

Hi, new to the forum, and have a...

don't put the drive in it, only the path:

'c:\OutputConsistencia_'+@DB+'.txt'

gets turned into :'c:\c:\OutputConsistencia_SandBox.txt'

use '\data\OutputConsistencia_'+@DB+'.txt' to put it in a sub folder off of the root od the drive, for example, or...

river i am sorry; you are correct...if there is an error, NO_INFOMSGS returns them;

here's the results you asked for...4 lines referencing jsut the single table that has the issue...the other...

river, the way i read the NO_INFOMSG parameter is no results at all...seems ideal for an unattended job, but if you want results, i think you need to...

i did an sp_helptext sp_MSget_jobstate, which targets a single job....

inside there seems to be this command, which reveals a bit about any jobs, i think:

EXECUTE master.dbo.xp_sqlagent_enum_jobs 1, 'dbo'

hope that helps.