SAMPLE: Mapsids.exe Helps Map SIDs Between User and Master Databases When Database Is Moved (298897)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q298897

SUMMARY

The Mapsids.exe sample provides two stored procedures, sp_sidmap and sp_prefix_sysusersname, which will help you to map the security identification numbers (SIDs) between the user database and the master database after a database moves between two different SQL Server servers as the result of a detach followed by an attach or a backup followed by a restore.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

240872 INF: How to Resolve Permission Issues When a Database is Moved between SQL Servers

MORE INFORMATION

The following file is available for download from the Microsoft Download Center:

Mapsids.exe

Release Date: AUG-13-2001

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How To Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.
The Mapsid.exe file contains the following files:

File nameSize
sp_sidmap.sql21 KB
Readme.txt7 KB
Modification Type:MinorLast Reviewed:8/5/2004
Keywords:kbdownload kbdownload kbfile kbinfo KB298897
©2004 Microsoft Corporation. All rights reserved.