you cannot append values, or assign variables to the parameters in line:

--not allowed

@subject ='Number of unprocessed records on SQL1 ' + cast(@recordcount as varchar(10));

--the replacement

DECLARE @mysubject...

i see two case statements. one with 20+ evaluations for the CTLGRP alias , and the other one for your postflag alias.

so the individual evaluations are not considered columns, if...

i've had this bookmarked for years:

http://www.databaseanswers.org/data_models/

thejordans21 (7/28/2014)

---

I don;t know how to set that up. Iout the plant and plant desc into another temp table and I am trying to use that to popllaute the orginal...

the beauty of SQL server is set based operations.

that means you affect all records, without a loop, as long as they meet a specific criteria.

IF OBJECT_ID('tempdb.[dbo].[#MyData]') IS NOT NULL

DROP...

object definitions like procedures, views and functions can become invalid if the underlying objects they use have been altered or dropped after being created.

I created this script a while ago...

here's the basics of it: generate the orphans from the meta data:

/*--Results

ALTER USER [z_AppDB_reports] WITH LOGIN = [z_AppDB_reports];

ALTER USER [medical] WITH LOGIN = [medical];

*/

SELECT 'ALTER USER ' + quotename(dbloginz.name)...

certainly possible.

remember linked servers are slow, especially if you are joining the data together with local or other rmeote data.

the reason is if you did something like this:

SELECT * From...

I had never trippeed over this before either; it's good to know.

Thanks guys for confirming , evne when it's not what i wanted to here.

Just as you suggested, I've got a specific domain user to use for this now, it just...

an example with rowversion, where the WHERE statement needs to take into consdieration teh last version;

that makes the update jsut a bt more complex.

IF OBJECT_ID('[dbo].[Samples]') IS NOT NULL

DROP...

i'm thinking it might be the current database for the login might be affecting the rights?

if my current database context was master, for example, could that affect the permissions if...

multiple...

on the notifications Tab, if you select "When the job completes", that will send the email you are after, and the message will have whether it was successful or with...

this tells you the issue is not with SQL database mail but with the mail server.

that the...