Browse by Tags

How to access SQL Server when you've forget the password

There is a little known feature of SQL Server 2005 is that when you start SQL Server in single user mode local administrators of the server have sysadmin access to the sql server. You may feel this a security concern, but if a user can get local admin of your server, and restart your service then having...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 22 2007
Native Command Substitution is not supported

In response to a recent support incident we raised we got a response about use of detours in SQL Server. A detour is a means by which you can change what SQL Server does. This is used by Litespeed to change native backup commands into Litespeed backup commands. Whilst I always thought this a neat idea...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 5 2006

Page 1 of 1 (2 items)

SQL Server Blogs