if you only have a single userid being used to connect, how will this have any benefit? do...

euroray (5/12/2011)

---

Please take a look at this:

I don't get any errors but the email is not being sent. Looks like the EXEC sp_send_dbmail is being skipped. If I use the...

does this return results/an explanation for unsent mail/failed mail?

SELECT

err.[description],

fail.*

FROM [msdb].[dbo].[sysmail_event_log] err

inner join [msdb].[dbo].[sysmail_faileditems] fail

ON err.mailitem_id = fail.mailitem_id

you cannot use 32 bit drivers on a 64 bit instance; the JET drivers are 32 bit, so you'll have to download the ACE drivers from microsoft instead;

i had a...

Janet first do SELECT * FROM sys.servers

are you sure the servername is [LINKEDSERVERNAME]?

next, after you see the server name, do this:

EXEC sp_tables_ex MyLinkedServer

that should give you the lsit of tables...

HowardW (5/12/2011)

---

...rewrite the update as a set based operation rather than a cursor. The performance of cursors for this type of work is unnecessary and dog slow.

We can't tell you...

you said when you are trying to use the user test....

are...

Login failed for user 'pradeep1'.

the above error has to do with no login in the server for that user;

that's a different issue, not related to the user/role you created...

only...

seshukumar.thokala (5/12/2011)

---

Hi Lowell

I tried ur example wt u posted but my problem is in my database i am having data like 30.6.1 so how to...

Sergiy (5/11/2011)

---

Your assumption is onviously wrong.

Look at...

it's the left join that is confusing you.

in the first query, the left table has all rows, and matching records from the second table get joined.

after that, you are filtering...

you should avoid(actually...i say never) trying to move data to another database or another server from within a trigger; the trigger could fail and rollback if the database/network/latency issues arise....

slash-r is for the RETURN of CrLf, very typical from unix/linux-sourced files: slash-n is CrLf, which you were already aware.

vbCrLf = CHAR(13) + CHAR(10) = \n

vbCr = CHAR(13)...

Aaron you want to change it a little so your lookup tables get populated by a SELECT featuring the DISTINCT clause:

----INSERT INTO WorldTable using Select

INSERT INTO World (Description)

SELECT DISTINCT World

FROM...

my only suggestion is going to echo Mike; show us what you have so far; if the columns are variable length, I'd end up writing a program instead of trying...