Take SQL Database out of Read Only/Stand By

Run this command

RESTORE DATABASE <db-name> WITH RECOVERY

Technorati Tags: sql-server,sql,tsql

Categories: sql

Be the first to rate this post

08.20.2010 05:24 by Danny Gershman | Comments (0) | Permalink

Making a user a Site Collection Administrator in MOSS 2007 via the SQL database I had inadventenly locked myself out of Sharepoint by removing myself as site administrator. But, ...Search for text in SQL database procs/functions declare @searchString varchar(100) Set @searchString = '%word_to_find%' SELECT ...Combining Database IDs There was a interesting requirement recently that came up. It was to basically modify and ex...

Add comment

Name*
E-mail* (Will show your Gravatar icon)
Website

Enter Numbers In Image Above: b i u quote

Notify me when new comments are added