February 2, 2012 at 9:01 am
Went to rollback a transaction from a script I started with Begin Transaction and the result was an error stating basically..."There is no associated Begin Transaction" My question is What is the rule when running a Begin Transaction at the start of a script that could cause such an error?
Below is the script for adding logins for you to scrutinize. I know I did something wrong, im just not sure what.
Begin Trans
Use Master
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'johnw')
Create login [johnw] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [johnw] for login [johnw]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'anth')
Create login [anth] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [anth] for login [anth]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'egenti')
Create login [egenti] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [egenti] for login [egenti]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'hernandez')
Create login [hernandez] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [hernandez] for login [hernandez]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'riggs')
Create login [riggs] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [riggs] for login [riggs]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'welcome')
Create login [welcome] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [welcome] for login [welcome]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'zaccheus')
Create login [zaccheus] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [zaccheus] for login [zaccheus]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'guiterrez')
Create login [guiterrez] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [guiterrez] for login [guiterrez]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'marquez')
Create login [marquez] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [marquez] for login [marquez]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'jacquet')
Create login [jacquet] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [jacquet] for login [jacquet]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'calderon')
Create login [calderon] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [calderon] for login [calderon]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'amaya')
Create login [amaya] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [amaya] for login [amaya]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'martinez')
Create login [martinez] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [martinez] for login [martinez]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'darton')
Create login [darton] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [darton] for login [darton]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'stewart')
Create login [stewart] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [stewart] for login [stewart]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'lira')
Create login [lira] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [lira] for login [lira]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'msegundo')
Create login [msegundo] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [msegundo] for login [msegundo]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'qhernandez')
Create login [qhernandez] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [qhernandez] for login [qhernandez]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'areal')
Create login [areal] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [areal] for login [areal]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'chapman')
Create login [chapman] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [chapman] for login [chapman]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'morales')
Create login [morales] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [morales] for login [morales]
go
Use Master
go
IF NOT EXISTS
(Select loginname from syslogins
where loginname = 'garcia')
Create login [garcia] with password = N'1234'
, default_database = [PRODDB]
, default_language = [us_english]
, check_policy = off
, check_expiration = off
USE PRODDB
Create user [garcia] for login [garcia]
go
Begin Transaction
USE PRODDB
Go
INSERT INTO [PRODDB].[dbo].[User]
([User ID] ,[Password],[Name],[Expiration Date])
VALUES ('anth' ,'','ALFRED HILL','1753-01-01 00:00:00.000')
,('egenti' ,'','EGENTI','1753-01-01 00:00:00.000')
,('hernandez','','HERNANDEZ','1753-01-01 00:00:00.000')
,('riggs','', ' RIGGS','1753-01-01 00:00:00.000')
,('welcome','',' WELCOME','1753-01-01 00:00:00.000')
,('zaccheus','',' ZACCHEUS','1753-01-01 00:00:00.000')
,('guiterrez','','GUITERREZ','1753-01-01 00:00:00.000')
,('marquez','','MARQUEZ','1753-01-01 00:00:00.000')
,('jacquet','',' JACQUET','1753-01-01 00:00:00.000')
,('calderon','',' CALDERON','1753-01-01 00:00:00.000')
,('amaya','',' AMAYA','1753-01-01 00:00:00.000')
,('martinez','','ARTINEZ','1753-01-01 00:00:00.000')
,('darton','','DARTON','1753-01-01 00:00:00.000')
,('stewart','',' STEWART','1753-01-01 00:00:00.000')
,('MSEGUNDO','','MSEGUNDO','1753-01-01 00:00:00.000')
,('qhernandez','','HERNANDEZ','1753-01-01 00:00:00.000')
,('areal','',' VILLAREAL','1753-01-01 00:00:00.000')
,('chapman','','CHAPMAN','1753-01-01 00:00:00.000')
,('morales','',' MORALES','1753-01-01 00:00:00.000')
,('garcia','',' GARCIA','1753-01-01 00:00:00.000');
GO
commit
Begin Transaction
INSERT INTO [PRODDB].[dbo].[Member Of]
([User ID] ,[Group ID] ,[Company] )
VALUES ('anth' ,'ALL_READ' ,'PROD DB')
,('egenti','ALL_READ' ,'PROD DB')
,('hernandez','ALL_READ' ,'PROD DB')
,('riggs','ALL_READ' ,'PROD DB')
,('welcome','ALL_READ' ,'PROD DB')
,('zaccheus','ALL_READ' ,'PROD DB')
,('guiterrez','ALL_READ' ,'PROD DB')
,('marquez','ALL_READ' ,'PROD DB')
,('jacquet','ALL_READ' ,'PROD DB')
,('calderon','ALL_READ' ,'PROD DB')
,('amaya','ALL_READ' ,'PROD DB')
,('martinez','ALL_READ' ,'PROD DB')
,('darton','ALL_READ' ,'PROD DB')
,('stewart','ALL_READ' ,'PROD DB')
,('MSEGUNDO','ALL_READ' ,'PROD DB')
,('qhernandez','ALL_READ' ,'PROD DB')
,('areal','ALL_READ' ,'PROD DB')
,('chapman','ALL_READ' ,'PROD DB')
,('morales','ALL_READ' ,'PROD DB')
,('garcia','ALL_READ' ,'PROD DB');
GO
--Commit Transaction
--Rollback Transaction
Begin Transaction
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'johnw',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'anth',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'egenti',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'hernandez',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'riggs',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'welcome',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'zaccheus',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'guiterrez',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'marquez',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'jacquet',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'calderon',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'amaya',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'martinez',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'darton',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'TSTWEART',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'MSEGUNDO',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'qhernandez',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'areal',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'chapman',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'morales',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'garcia',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
Insert Into [dbo].[PROD DB$User Setup]
( [User ID],[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID],[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval]
,[Unlimited Purchase Approval],[Substitute],[E-Mail],[Request Amount Approval Limit],[Unlimited Request Approval]
,[Allow FA Posting From],[Allow FA Posting To] ,[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter],[Service Resp_ Ctr_ Filter]
,[Direct Telephone],[Direct Fax],[Restrict Sales Quote View],[Allow to View Salesperson],[Company Address Code],[Customer Modify Allowed]
,[Modify Sales Orders],[Restrict Sales Price & Cost],[Ship-to Address Modify],[Allow Hold Sales Order],[Allow Hold Purch_ Order],[Allow View Employee Vendors]
,[Not Allow Change Expected Date],[Allow View Confidential Vendor],[Allow Change Location Code],[Allow Change Acknowledge]
,[Allow Change IC Disc],[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc],[xxSales Layout Profile],[xxSO Subform Layout Set],[xxSO Suform No Pane Layout Set],[xxPurchase Layout Profile]
,[xxPO Subform Layout Set] ,[User Type for Form Layout],[Allow to Email Invoice by Matr],[Allow to Run Daily Inv_ Report]
,[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc],[Allow Create SO for Rest_ Loc]
,[Allow to View Customer],[Allow to Change Fgt Billables]
)
Select 'ASTANFORD',[Allow Posting From],[Allow Posting To],[Register Time],[Salespers__Purch_ Code],[Approver ID]
,[Sales Amount Approval Limit],[Purchase Amount Approval Limit],[Unlimited Sales Approval],[Unlimited Purchase Approval],[Substitute]
,'info@company.com' ,[Request Amount Approval Limit] ,[Unlimited Request Approval] ,[Allow FA Posting From]
,[Allow FA Posting To],[Sales Resp_ Ctr_ Filter],[Purchase Resp_ Ctr_ Filter] ,[Service Resp_ Ctr_ Filter]
,'944-812-5000' ,'944-812-5007',[Restrict Sales Quote View] ,[Allow to View Salesperson] ,[Company Address Code]
,[Customer Modify Allowed] ,[Modify Sales Orders] ,[Restrict Sales Price & Cost] ,[Ship-to Address Modify]
,[Allow Hold Sales Order] ,[Allow Hold Purch_ Order] ,[Allow View Employee Vendors] ,[Not Allow Change Expected Date]
,[Allow View Confidential Vendor] ,[Allow Change Location Code] ,[Allow Change Acknowledge] ,[Allow Change IC Disc]
,[Allow Change Base UOM],[Allow Delete Sales Order],[Allow View Change Log],[Allow Reverse Transactions]
,[Credit Card Group],[Receive Station],[Packing Station],[E-Mail User Rule],[Is Manager],[Allow Hold Released SO]
,[Allow Upload Help Doc] ,[xxSales Layout Profile] ,[xxSO Subform Layout Set] ,[xxSO Suform No Pane Layout Set]
,[xxPurchase Layout Profile] ,[xxPO Subform Layout Set] ,[User Type for Form Layout] ,[Allow to Email Invoice by Matr]
,[Allow to Run Daily Inv_ Report],[Allow to View Transfer Req],[Allow Edit Tax Liable on PO],[Allow Create TO for Rest_ Loc]
,[Allow Create SO for Rest_ Loc] ,[Allow to View Customer] ,[Allow to Change Fgt Billables]
From [dbo].[PROD DB$User Setup]
Where [User ID] = 'LINDAM'
--Commit Transaction
USE master
ALTER LOGIN [johnw] DISABLE
ALTER LOGIN [anth] DISABLE
ALTER LOGIN [egenti] DISABLE
ALTER LOGIN [hernandez] DISABLE
ALTER LOGIN [riggs] DISABLE
ALTER LOGIN [welcome] DISABLE
ALTER LOGIN [zaccheus] DISABLE
ALTER LOGIN [guiterrez] DISABLE
ALTER LOGIN [marquez] DISABLE
ALTER LOGIN [jacquet] DISABLE
ALTER LOGIN [calderon] DISABLE
ALTER LOGIN [amaya] DISABLE
ALTER LOGIN [martinez] DISABLE
ALTER LOGIN [darton] DISABLE
ALTER LOGIN [stewart] DISABLE
ALTER LOGIN [MSEGUNDO] DISABLE
ALTER LOGIN [qhernandez] DISABLE
ALTER LOGIN [chapman] DISABLE
ALTER LOGIN [morales] DISABLE
ALTER LOGIN [garcia] DISABLE
ALTER LOGIN [areal] DISABLE
February 2, 2012 at 10:07 am
"Trans" is not a keyword.
The syntax is:
BEGIN { TRAN | TRANSACTION }
So, you can either use:
BEGIN TRAN
--or
BEGIN TRANSACTION
Since you have GO's in your script, the first batch (up to the first GO) failed, then all subsequent batches ran without being contained in a transaction as none was ever started
February 2, 2012 at 12:01 pm
Got it. thanks Howard. I usually look out for the inellisense to pick up those mistakes but for some reason I didn't notice.
February 6, 2012 at 1:40 am
For example:
USE AdventureWorks;
GO
BEGIN TRANSACTION;
BEGIN TRY
-- Generate a constraint violation error.
DELETE FROM Production.Product
WHERE ProductID = 980;
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber
,ERROR_SEVERITY() AS ErrorSeverity
,ERROR_STATE() AS ErrorState
,ERROR_PROCEDURE() AS ErrorProcedure
,ERROR_LINE() AS ErrorLine
,ERROR_MESSAGE() AS ErrorMessage;
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION;
END CATCH;
IF @@TRANCOUNT > 0
COMMIT TRANSACTION;
GO
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply