here's teh puedocode that I currently use for something similar:

add one more column to your tracking table, a flag or field to signify "NotificationSent' or something.

now create a job that...

there is no change for the users; remember that their logins and permissions are mapped to roles in each of databases on the machine. Esentially their permissions are stored in the...

without more information, I don't believe you can.

is there an identity column in the tabe? is there a datetime field for creation or updated?

if the primary key might be (Accountno,AdmissionReason), then...

i looked at sp_addalias, and it looks like any users that are aliased as dbo would have the sid for sa/dbo (which is always 1):

    -- INSERT SYSUSERS ROW --

   ...

there's a difference between changing a machine name, and changing a named instance.

for example, if my machine is named DEVPLATFORM, and I want to rename it as DEVELOPER, I right...

since all three of these tables (sr_srvc_request_v,sr_note_v,sr_activity_v) are joining on the srvc_request_num column, all three might also benefit from an index on their srvc_request_num column;

I'd look at the execution plan...

it looks like your batch number is arbityary...can it be based on the workID?

select 'us' + RIGHT('000' + (convert(varchar,(workID / 100) + 1)),3)

select 'us' + RIGHT('000' + (convert(varchar,(1 / 100)...

good catch and sorry for the typo;

check to see if there is an index on ra_review_t.srvc_request_num ;

all three joins use that for this query, and it might speed up if one...

as a developer will this allow them to see the text?

SELECT TEXT FROM SYSCOMMENTS WHERE ID=object_id('USP_IE_GET_INVOICES_BY_USER_ID')

if that does work, you could create your own proc and grant them...

something like this might help you; note i limited it to top 100 because this can be a huge result set on some db's: the columns in the sqlstatmenet are...

if (SELECT     COUNT(*)

FROM        inserted INNER JOIN

                      tblInternalEduModule ON [inserted].[Quiz Name] = tblInternalEduModule.Quiz

WHERE     (tblInternalEduModule.Category = 'WIN') ) !=@@rowcount

that looks invalid to me. select count(*) from inserted will set @@rowcount...

in enterprise manager, expand the views and drill in till you see the table that contains the column you wish to change.

right click on the table>>Choose "Design Table"

A list of...

no need;

you can simply insert these user tables back into the current master; you can use either DTS to copy the tables, or sql commands

I assume you restored or attached...

try something like this: i've moved the counts you are comparing into two subselect tables instead;

I've found this improves performance for me:

SELECT rev.srvc_request_num AS serviceRequestId,

               rev.reviewed_dt AS "review.lastUpdatedDate",

               rev.reviewed_by AS...

actually very helpful Colin thanks for the response; I had suspected views of views sucked, glad to hear a confirmation.

I was hoping to simply prune the complexity of some of...