there's a logonproperty function that lets you pull things like the last time the password was changed;

with this query, you could find items older than 180 days, and issue a...

maybe something more along the lines of this?

With MyClients(ClientID,UserID)

AS

(

SELECT 111,5656 UNION ALL

SELECT 222,5656 UNION ALL

SELECT 333,5656

)

--INSERT INTO document (documentTitle,actualFileName,clientID,documentDescription,documentCategoryLV,updateKey,savedUserID,savedDateTime,contentType,url,effectiveBeginDate,effectiveEndDate,featureYN,language,imageID,sequence,effectiveShowAsNewDate,javascriptURL,homePageYN,enrollmentYN,bestFitVideoYN,benefitPlanTypeID,eeMarqueeUntilDate,imageName,thumbnailImageName,thumbnailImageID)

SELECT 'Health informational video','',ClientID,'Health Rovion Video',16,1,UserID,GETDATE(),3,'<a href="#this" onclick="try{playThisVideoNow(''20110824181720e66FsHYTkWv'');}catch(e){}">View Video on...

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