I spoke too soon..

when I run gails script

IF EXISTS (select 1

from dynamicsgp_utilities.dbo.V_sfvouchers

where (sfid like 'EM-%' or sfid like 'EXP-REP%') and sfid not in

(

select pordnmbr from lpb..pm30200 where doctype...

I spoke too soon..

when I run gails script

IF EXISTS (select 1

from dynamicsgp_utilities.dbo.V_sfvouchers

where (sfid like 'EM-%' or sfid like 'EXP-REP%') and sfid not in

(

select pordnmbr from lpb..pm30200 where doctype...

Awesome...I see the error in my way..

Thanks everyone!

Good karma to you both.

declare @cnt smallint

Select @cnt = count(*)

, glaccount, 'ACCOUNT NOT FOUND' ErrorReason

from dynamicsgp_utilities.dbo.V_sfvouchers

where (sfid like 'EM-%' or sfid like 'EXP-REP%') and sfid not in

(

select pordnmbr from lpb..pm30200 where doctype =...

SQLRNNR -

I made your changes and got the error

Msg 102, Level 15, State 1, Line 8

Incorrect syntax near 'EM'.

The original query works fine -

This statement -

select distinct glaccount, 'ACCOUNT NOT FOUND' ErrorReason

from dynamicsgp_utilities.dbo.V_sfvouchers

where (sfid like 'EM-%' or sfid like 'EXP-REP%') and sfid not in

(

select pordnmbr from...

Hi Gail

I need to email notification if there are any records returned from that query.

So once the top part is working I need to do something like -

If @cnt >...

Thanks Steve

You mean I have to stop the SQL service, correct?

The SQL storage is on a NAS device - so they are moving to a larger device.

Which means they will copy and paste onto the new drives.

Does it matter which...

Thanks guys for all the good info.

Good karma to you.

found one..thanks anyway..

-This script will script the role members for all roles on the database.

--This is useful for scripting permissions in a development environment before refreshing

...

Kinda figured....

Thanks Gail

I'm creating only the DB mapping, the user is still there.

the mapping to the dbis what goes away

oh wait that's not gonna work that user already exists....