SQL Server () DBA

T-SQL () *.ldf *.mdf Service Broker

T-SQL Service Broker

DBName Service Broker (GUID) Service Broker GUID sys.databases (GUID)

Cannot enable the Service Broker in database DBName because the Service Broker GUID in the database (GUID) does not match the one in sys.databases (GUID).

Service Broker T-SQL ( ENABLE_BROKER )

ALTERDATABASE[YourDBName]SETSINGLE_USERWITHROLLBACKIMMEDIATE

GUID Service Broker Service Broker T-SQL ( NEW_BROKER )

ALTERDATABASE[YourDBName]SETSINGLE_USERWITHROLLBACKIMMEDIATE

SQL Server 2012 Express LocalDB (SqlLocalDB)

SQL Server 2012 Express LocalDB SQL Server Express Visual Studio

SQL Server VHD sysprep SQL Server …

Visual Studio 2008Visual Studio 2008 SP1Visual Studio 2010 Visual Studio 2010 SP1 …

An experiment – The Azure Cloud Shell at the…

A new Console for Windows – Its the open sou…

Did I leave the garage door open? A no-code p…

(1) (2) (3) (4)