Wednesday, August 28, 2013

[SQL 2012] ms sql server 2012 - locks

[SQL 2012] ms sql server 2012 - locks

ms sql server 2012 - locks

Posted: 28 Aug 2013 12:36 AM PDT

Hello guys,don't you know how to find out the reason why the update statement isn't able to finish a job? It seems to me that lock is wait to be granted. But why? The blocking_session_id = '-2' means it's ME? resource_type resource_subtype resource_database_id resource_description resource_associated_entity_id resource_lock_partition request_mode request_type request_status request_reference_count request_lifetime request_session_id request_exec_context_id request_request_id request_owner_type request_owner_id request_owner_guid request_owner_lockspace_id lock_owner_addressRID 5 1:26915:5 72057594067156992 0 U LOCK WAIT 1 0 57 0 0 TRANSACTION 160027 00000000-0000-0000-0000-000000000000 0x000000017F3DE1C0:1:1 0x000000017BB16600resource_type resource_database_id resource_associated_entity_id request_mode request_session_id blocking_session_idRID 5 72057594067156992 U 71 57RID 5 72057594067156992 U 67 57RID 5 72057594067156992 U 57 -2Really thanks for help! I tried to make everything possible, but...I am still in troubles.

SQL Server 2012 Installation failing at ~85%

Posted: 28 Aug 2013 12:30 AM PDT

Me and colleagues are getting the same error when trying to install a MS SQL Server 2012 SP1 Developer Edition on a Windows 7 machine via Remote desktop.The installation runs fine, until it gets to "SqlEngineDBStartConfigAction_install_configrc_Cpu32".The error message that pops up during installation is; "Het aangevraagde besturingselement is niet geldig voor deze service.", translated to English; The requested control element is not valid for this service.Below the log part of Detail.txt which should explain the exception more, but i can't find a solution anywhere.Trying to deinstall/remove subsequently fails, so we're using new Windows 7 images every time. I'm new here , but I see a lot of simular issues solved on this forum, so i hope you can help us out because it has already taken us a lot of time/days & grey hairs!Thanks![code="plain"](01) 2013-08-28 10:51:46 SQLEngine: --SqlEngineSetupPrivate: Remove: ShutdownInstance : Engine Configuration(01) 2013-08-28 10:51:46 SQLEngine: --SqlEngineSetupPrivate: Stopping SQL Server Service(01) 2013-08-28 10:51:46 SQLEngine: --SqlServerServiceSCM: Attempting to stop SQL Server service: Microsoft.SqlServer.Configuration.Sco.Service(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to open service handle for service MSSQLSERVER(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to close service handle for service MSSQLSERVER(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:46 SQLEngine: : Checking Engine checkpoint 'CheckServerStatus'(01) 2013-08-28 10:51:46 SQLEngine: --SqlServerServiceSCM: Checking if service is running:(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to open service handle for service MSSQLSERVER(01) 2013-08-28 10:51:46 Slp: Invoking QueryServiceStatus Win32 API(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to close service handle for service MSSQLSERVER(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:46 SQLEngine: --SqlServerServiceSCM: Checking if service is running: StartPending(01) 2013-08-28 10:51:46 SQLEngine: --SqlServerServiceSCM: Stopping SQL Server Service and dependents(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to get service process id for service MSSQLSERVER(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to open service handle for service MSSQLSERVER(01) 2013-08-28 10:51:46 Slp: Invoking QueryServiceStatusEx Win32 API(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to close service handle for service MSSQLSERVER(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:46 Slp: Sco: Returning service process id 4164(01) 2013-08-28 10:51:46 SQLEngine: : Checking Engine checkpoint 'GetSqlServerProcessHandle'(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to stop service with wait MSSQLSERVER, timeout 600, stop dependents True(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to stop service with wait SQLSERVERAGENT, timeout 600, stop dependents True(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to stop service SQLSERVERAGENT, stop dependents False(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to open service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:46 Slp: Invoking ControlService Win32 API(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to close service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:46 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:46 Slp: Sco: Service SQLSERVERAGENT aleady at stop state(01) 2013-08-28 10:51:46 Slp: Sco: Service SQLSERVERAGENT stop request issued... Sleeping 1 second before next status check(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to open service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:47 Slp: Invoking QueryServiceStatus Win32 API(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to close service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:47 Slp: Sco: Service SQLSERVERAGENT stopped in less than 1 seconds(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to stop service MSSQLSERVER, stop dependents False(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to open service handle for service MSSQLSERVER(01) 2013-08-28 10:51:47 Slp: Invoking ControlService Win32 API(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to close service handle for service MSSQLSERVER(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:47 SQLEngine: --SqlServerServiceSCM: Exception happens at stop SQL Service attempt 1. Exception: Het aangevraagde besturingselement is niet geldig voor deze service. Call stack Het aangevraagde besturingselement is niet geldig voor deze service.(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to stop service with wait MSSQLSERVER, timeout 600, stop dependents True(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to stop service with wait SQLSERVERAGENT, timeout 600, stop dependents True(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to stop service SQLSERVERAGENT, stop dependents False(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to open service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:47 Slp: Invoking ControlService Win32 API(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to close service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:47 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:47 Slp: Sco: Service SQLSERVERAGENT aleady at stop state(01) 2013-08-28 10:51:47 Slp: Sco: Service SQLSERVERAGENT stop request issued... Sleeping 1 second before next status check(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to open service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:48 Slp: Invoking QueryServiceStatus Win32 API(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to close service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:48 Slp: Sco: Service SQLSERVERAGENT stopped in less than 1 seconds(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to stop service MSSQLSERVER, stop dependents False(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to open service handle for service MSSQLSERVER(01) 2013-08-28 10:51:48 Slp: Invoking ControlService Win32 API(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to close service handle for service MSSQLSERVER(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:48 SQLEngine: --SqlServerServiceSCM: Exception happens at stop SQL Service attempt 2. Exception: Het aangevraagde besturingselement is niet geldig voor deze service. Call stack Het aangevraagde besturingselement is niet geldig voor deze service.(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to stop service with wait MSSQLSERVER, timeout 600, stop dependents True(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to stop service with wait SQLSERVERAGENT, timeout 600, stop dependents True(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to stop service SQLSERVERAGENT, stop dependents False(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to open service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:48 Slp: Invoking ControlService Win32 API(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to close service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:48 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:48 Slp: Sco: Service SQLSERVERAGENT aleady at stop state(01) 2013-08-28 10:51:48 Slp: Sco: Service SQLSERVERAGENT stop request issued... Sleeping 1 second before next status check(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to open service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:49 Slp: Invoking QueryServiceStatus Win32 API(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to close service handle for service SQLSERVERAGENT(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:49 Slp: Sco: Service SQLSERVERAGENT stopped in less than 1 seconds(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to stop service MSSQLSERVER, stop dependents False(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to open SC Manager(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to open service handle for service MSSQLSERVER(01) 2013-08-28 10:51:49 Slp: Invoking ControlService Win32 API(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to close service handle for service MSSQLSERVER(01) 2013-08-28 10:51:49 Slp: Sco: Attempting to close SC Manager(01) 2013-08-28 10:51:49 SQLEngine: Copying 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG' to 'C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130828_104932\SQLServer_ERRORLOG_2013-08-28T10.51.49.txt' ...(01) 2013-08-28 10:51:49 Slp: Sco: File 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG' does not exist(01) 2013-08-28 10:51:49 SQLEngine: Could not copy non-existant SQL Server Error Log: C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG(01) 2013-08-28 10:51:49 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing Validation and scenario Validation.(01) 2013-08-28 10:51:49 Slp: Failed to shutdown the instance with process ID 4164. Error encountered: Microsoft.SqlServer.Configuration.Sco.ScoException: Het aangevraagde besturingselement is niet geldig voor deze service. ---> System.ComponentModel.Win32Exception: Het aangevraagde besturingselement is niet geldig voor deze service. bij Microsoft.SqlServer.Configuration.Sco.Service.ControlService(UInt32 dwControlCode) bij Microsoft.SqlServer.Configuration.Sco.Service.StopService(Boolean bStopDependents) bij Microsoft.SqlServer.Configuration.Sco.Service.StopServiceWait(Int32 dwTimeOut, Boolean bStopDependents) --- Einde van intern uitzonderingsstackpad --- bij Microsoft.SqlServer.Configuration.Sco.Service.StopServiceWait(Int32 dwTimeOut, Boolean bStopDependents) bij Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServer().(01) 2013-08-28 10:51:49 Slp: The configuration failure category of current exception is ConfigurationValidationFailure(01) 2013-08-28 10:51:49 Slp: Configuration action failed for feature SQL_Engine_Core_Inst during timing Validation and scenario Validation.(01) 2013-08-28 10:51:49 Slp: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException: Failed to shutdown the instance with process ID 4164. Error encountered: Microsoft.SqlServer.Configuration.Sco.ScoException: Het aangevraagde besturingselement is niet geldig voor deze service.(01) 2013-08-28 10:51:49 Slp: ---> System.ComponentModel.Win32Exception: Het aangevraagde besturingselement is niet geldig voor deze service.(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.Sco.Service.ControlService(UInt32 dwControlCode)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.Sco.Service.StopService(Boolean bStopDependents)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.Sco.Service.StopServiceWait(Int32 dwTimeOut, Boolean bStopDependents)(01) 2013-08-28 10:51:49 Slp: --- Einde van intern uitzonderingsstackpad ---(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.Sco.Service.StopServiceWait(Int32 dwTimeOut, Boolean bStopDependents)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServer().(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServer()(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServerIfNeeded(Boolean mustExist, Boolean fShutdownAllRANUInstances)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Remove_ShutdownInstance(EffectiveProperties properties)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Remove(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)(01) 2013-08-28 10:51:49 Slp: The following is an exception stack listing the exceptions in outermost to innermost order(01) 2013-08-28 10:51:49 Slp: Inner exceptions are being indented(01) 2013-08-28 10:51:49 Slp: (01) 2013-08-28 10:51:49 Slp: Exception type: Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException(01) 2013-08-28 10:51:49 Slp: Message: (01) 2013-08-28 10:51:49 Slp: Failed to shutdown the instance with process ID 4164. Error encountered: Microsoft.SqlServer.Configuration.Sco.ScoException: Het aangevraagde besturingselement is niet geldig voor deze service.(01) 2013-08-28 10:51:49 Slp: ---> System.ComponentModel.Win32Exception: Het aangevraagde besturingselement is niet geldig voor deze service.(01) 2013-08-28 10:51:49 Slp: (01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.Sco.Service.ControlService(UInt32 dwControlCode)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.Sco.Service.StopService(Boolean bStopDependents)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.Sco.Service.StopServiceWait(Int32 dwTimeOut, Boolean bStopDependents)(01) 2013-08-28 10:51:49 Slp: --- Einde van intern uitzonderingsstackpad ---(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.Sco.Service.StopServiceWait(Int32 dwTimeOut, Boolean bStopDependents)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServer().(01) 2013-08-28 10:51:49 Slp: HResult : 0x851a0018(01) 2013-08-28 10:51:49 Slp: FacilityCode : 1306 (51a)(01) 2013-08-28 10:51:49 Slp: ErrorCode : 24 (0018)(01) 2013-08-28 10:51:49 Slp: Data: (01) 2013-08-28 10:51:49 Slp: SQL.Setup.FailureCategory = ConfigurationValidationFailure(01) 2013-08-28 10:51:49 Slp: WatsonConfigActionData = UNINSTALL@VALIDATION@SQL_ENGINE_CORE_INST(01) 2013-08-28 10:51:49 Slp: WatsonExceptionFeatureIdsActionData = System.String[](01) 2013-08-28 10:51:49 Slp: Stack: (01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServer()(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServerIfNeeded(Boolean mustExist, Boolean fShutdownAllRANUInstances)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Remove_ShutdownInstance(EffectiveProperties properties)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineSetupPrivate.Remove(ConfigActionTiming timing, Dictionary`2 actionData, PublicConfigurationBase spcb)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlConfigBase.PrivateConfigurationBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlConfigBase.SqlFeatureConfigBase.Execute(ConfigActionScenario scenario, ConfigActionTiming timing, ConfigBaseAction action, Dictionary`2 actionData, PublicConfigurationBase spcbCurrent)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.ExecuteAction(String actionId)(01) 2013-08-28 10:51:49 Slp: bij Microsoft.SqlServer.Configuration.SqlConfigBase.SlpConfigAction.Execute(String actionId, TextWriter errorStream)(01) 2013-08-28 10:51:49 Slp: Watson Bucket 1 Original Parameter Values (01) 2013-08-28 10:51:49 Slp: Parameter 0 : SQL Server 2012@RTM@ (01) 2013-08-28 10:51:49 Slp: Parameter 1 : Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServer (01) 2013-08-28 10:51:49 Slp: Parameter 2 : Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServer (01) 2013-08-28 10:51:49 Slp: Parameter 3 : Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException@1306@24 (01) 2013-08-28 10:51:49 Slp: Parameter 4 : Microsoft.SqlServer.Configuration.SqlEngine.SqlEngineConfigException@1306@24 (01) 2013-08-28 10:51:49 Slp: Parameter 5 : SqlEngineConfigAction_remove_validation (01) 2013-08-28 10:51:49 Slp: Parameter 6 : UNINSTALL@VALIDATION@SQL_ENGINE_CORE_INST (01) 2013-08-28 10:51:49 Slp: Final Parameter Values (01) 2013-08-28 10:51:49 Slp: Parameter 0 : SQL Server 2012@RTM@ (01) 2013-08-28 10:51:49 Slp: Parameter 1 : 0x2484742C (01) 2013-08-28 10:51:49 Slp: Parameter 2 : 0x2484742C (01) 2013-08-28 10:51:49 Slp: Parameter 3 : 0xBE03358B@1306@24 (01) 2013-08-28 10:51:49 Slp: Parameter 4 : 0xBE03358B@1306@24 (01) 2013-08-28 10:51:49 Slp: Parameter 5 : SqlEngineConfigAction_remove_validation (01) 2013-08-28 10:51:49 Slp: Parameter 6 : 0x624A5E9A (01) 2013-08-28 10:51:50 Slp: Sco: Attempting to write hklm registry key Microsoft SQL Server to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130828_104932\Registry_SOFTWARE_Microsoft_Microsoft SQL Server.reg_(01) 2013-08-28 10:51:50 Slp: Sco: Attempting to write hklm registry key Uninstall to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130828_104932\Registry_SOFTWARE_Microsoft_Windows_CurrentVersion_Uninstall.reg_(01) 2013-08-28 10:51:50 Slp: Sco: Attempting to write hklm registry key MSSQLServer to file C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20130828_104932\Registry_SOFTWARE_Microsoft_MSSQLServer.reg_(01) 2013-08-28 10:51:52 Slp: Failed to shutdown the instance with process ID 4164. Error encountered: Microsoft.SqlServer.Configuration.Sco.ScoException: Het aangevraagde besturingselement is niet geldig voor deze service. ---> System.ComponentModel.Win32Exception: Het aangevraagde besturingselement is niet geldig voor deze service. bij Microsoft.SqlServer.Configuration.Sco.Service.ControlService(UInt32 dwControlCode) bij Microsoft.SqlServer.Configuration.Sco.Service.StopService(Boolean bStopDependents) bij Microsoft.SqlServer.Configuration.Sco.Service.StopServiceWait(Int32 dwTimeOut, Boolean bStopDependents) --- Einde van intern uitzonderingsstackpad --- bij Microsoft.SqlServer.Configuration.Sco.Service.StopServiceWait(Int32 dwTimeOut, Boolean bStopDependents) bij Microsoft.SqlServer.Configuration.SqlEngine.SqlServerServiceSCM.StopSqlServer().(01) 2013-08-28 10:51:52 Slp: Watson bucket for exception based failure has been created(01) 2013-08-28 10:52:03 Slp: Error: Action "SqlEngineConfigAction_remove_validation_Cpu32" failed during execution.(01) 2013-08-28 10:52:03 Slp: Completed Action: SqlEngineConfigAction_remove_validation_Cpu32, returned False(01) 2013-08-28 10:52:03 Slp: ---- Flush datastore cache before calling configuration action 'FulltextConfigAction_remove_validation_Cpu32'[/code]

Keyword mapping

Posted: 27 Aug 2013 02:28 PM PDT

I have two tables setup where one contains a list of keywords and category The second table contains actual data description. By mapping the keywords on the Data description column, we will have to update the respective category.Can we achieve the same using a Query or we have to write a Procedure?

SQL 2012 alias name

Posted: 27 Aug 2013 07:11 PM PDT

Hi,I have installed a SQL 2012 cluster, I can connect to it using Networkname\InstanceName.but I wanted everyone(including application) to connect to it with a alias name, lets say "SQL2012".how can I do that?thanks

Generate railroad diagrams from Books Online

Posted: 27 Aug 2013 07:39 AM PDT

Hello All,Have you ever wanted to generate railroad diagrams from the Books Online grammar? That is, convert[code="sql"]CREATE TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name { AS FILETABLE | ( { <column_definition> | <computed_column_definition> |<column_set_definition> | [ <table_constraint> ] } [ ,...n ] } ) [/code]to[img]http://www.colindaley.com/translator/graphics/screenshots/create_table_corrected.png[/img]?Well, now you can! Just go to http://www.colindaley.com/translator/. It's free as in free beer. Let me know what you think.

Loading Infobright with SSIS in SQL Server 2012

Posted: 12 Jul 2013 07:54 AM PDT

I am playing around with Infobright but am having some problems with populating it using SSIS.Infobright uses the MySQL 3.5.1 ODBC driver and to external applications appears as if it is MySQL.Using the ADO.NET Destination I can load data from SQL Server into Infobright provided the population mode is set to row-by-row rather than batch.Populating a column store database row by row is s...l...o...w.Has anyone else tried populating Infobright with SSIS and if so what did you do to get it to work in an acceptable manner?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog