Browse by Tags

• database
• error
• kba
• login
• security
• self
• server
• sp_help_revlogin
• SQL Server
• wizard

• SP_HELP_REVLOGIN for SQL Server 2005

  SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure Read More... Posted Tuesday, September 04, 2007 11:54 PM from SSQA.net | (Comments Off) Filed under: security, SQL Server, self, server, login, copy, sp_help_revlogin

• FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005

  Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification , Contents: New and Major Modifications FIX: Error message when you use the Copy Database Read More... Posted Tuesday, August 21, 2007 6:33 AM from SSQA.net | (Comments Off) Filed under: SQL Server, error, database, kba, copy, wizard