Don't Panic: MERGE is just a fancy way to do what you've already done a zillion times:, but as separate steps...INSERT new rows, UPDATE matching rows, DELETE rows that were...

dumb question...

for me the big question is the number of rows moved;

when your procedure was running once a day, what did it do? MERGE statement? drop and recreate the data?...

is an error returned, or just no data?

check the schema of the underlying objects inside the view;

for example, lets say dbo.View1 & 3 are accessing items under the same schema,...

browsers ignore whitespace...tabs, CrLf and more than one space in a row; that's part of the html definition

if you need to visualize whitespace, you'll need to html-ize the results...either by...

how about adding a column to your records to have an opt out date and optional reason in the database row for the emails; then when select FROM YourTable where...

it's syntax: remove the word "SELECT" just before EXEC;

looks like an artifact from trimming the code.

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...