April 2006 - Posts

• sp_help_revlogin - 'LOGINPROPERTY' is not a recognized function name.

  The Microsoft Knowledge Base Article 246133 - How to transfer logins and passwords between instances of SQL Server details how to create the Stored Procedure sp_help_revlogin. This stored procedure is used to transfer logins from one SQL Server instance Read More... Posted Wednesday, April 26, 2006 7:04 PM by admin | (Comments Off)

• DMO to Check if Database is Suspect

  One of the emails I received whilst on leave was asking if it is possible to check if a database has been marked suspect using SQLDMO. Below is a VBScript snippet of how the database status can be checked to determine if the database has been marked suspect Read More... Posted Tuesday, April 25, 2006 3:33 PM by admin | (Comments Off)

• I'm Back...

  After almost four weeks touring northern Italy with Jay Dee I have returned from leave refreshed and now knowing what my wife actually looks like. During this trip we came up with some great ideas for WARDY IT, so watch this space over the next couple Read More... Posted Tuesday, April 25, 2006 3:23 PM by admin | (Comments Off)