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.

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

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

Sharepoint sites always prompts for login password

Processing

Copy Sharepoint Designer 2007 Workflows in a few minutes

How to copy SPD from your test machine to production
machines