Pages

Tuesday, May 20, 2014

Permit Number generation and Increment in the Infopath form via webservice and sharepoint designer



  1. Implement the Permit number code in the Infopath submit button
  2.   Create one custom column name as Newnumber and set NewNumber = LoadNumber after first approval button
  3. Create a web service and getmaxnumber as New Number
  4. kindly follow the below screen shots

























Please post your comments here if you have any questions  or issues.

Wednesday, April 2, 2014

how to recall sent message to anyone in the Outlook email

1.Go to Sent items in the Inbox



2.click on the specific mail to recall and open that email

 


3.Click on the File menu and click on Resend or Recall

 4.Then click on the radio button either
Delete unread copies of this message
or Delete unread copies and replace with a new message


5. Click on the check box Tell me if recal succeeds or fails for each recipent,click ok

6.Finally you got message to recall success or failed message



Monday, March 10, 2014

Command to map an orphaned user for SQL Server Login id and Database user id


After restoring the SQL Server Database from one server to another server, SQL Server Login id and Database user id does match, so it look like a orphaned user, to fix the issue then follow the commands


-Script to view difference in SID

USE MASTER
GO
SELECT name as SQLServerLogIn,SID as SQLServerLogInSID FROM sys.syslogins
WHERE [name] = 'TestUser3'
GO

USE AdventureWorks
GO
SELECT name DataBaseUserID,SID as DatabaseUserSID FROM sysusers
WHERE [name] = 'TestUser3'
GO

--Command to generate list of orphaned users

USE adventureWorks
GO

sp_change_users_login @Action='Report'
GO


--Command to map an orphaned user

USE AdventureWorks
GO

sp_change_users_login @Action='update_one',
@UserNamePattern='TestUser1',
@LoginName='TestUser1'
GO