SQL Server - (no subject)

Thanks, I didn't really need to do it but while solving another problem
the question occurred to me because it would have made the solution to
my problem trivial.  The actual solution was pretty simple too so it
wasn't a big deal.  I was just curious.

Andrew

  sloan replied...

Since you changed the subject, no one knows which thread this originally
belonged to.

2010-09-13 15:04:56 Requested action: Install Log with failure: C: \ Program Files \ Microsoft SQL Server \ 100 \ Setup Bootstrap \ Log \ 20100913_144043 \ sql_engine_core_inst_Cpu32_1.log Exception help link: http: / / go.microsoft.com / fwlink?LinkId = 20476&ProdName = Microsoft+SQL+Server&EvtSrc = setup.rll&EvtID = 50000&ProdVer = 10.0.1600.22 Machine Properties: Machine ASSVCACCOUNT: <empty> ASSVCPASSWORD: * ** ** ASSVCSTARTUPTYPE: Automatic ASSYSADMINACCOUNTS: <empty> ASTEMPDIR: Temp BROWSERSVCSTARTUPTYPE: Disabled CONFIGURATIONFILE: C: \ Program Files \ Microsoft SQL Server \ 100 \ Setup Bootstrap \ Log \ 20100913_144043 \ ConfigurationFile.ini ENABLERANU: True ERRORREPORTING: False FEATURES: SQLENGINE empty> FTSVCACCOUNT: NT AUTHORITY \ LOCAL SERVICE FTSVCPASSWORD: * ** ** HELP: False INDICATEPROGRESS: False INSTALLSHAREDDIR: c: \ Program Files \ Microsoft SQL Server \ INSTALLSHAREDWOWDIR: C: \ Program Files \ Microsoft SQL Server \ INSTALLSQLDATADIR: <empty> INSTANCEDIR: C: \ Program Files \ Microsoft SQL Server \ INSTANCEID: SQLExpress INSTANCENAME: SQLEXPRESS ISSVCACCOUNT: NT AUTHORITY \ NetworkService ISSVCPASSWORD: * ** ** ISSVCSTARTUPTYPE: Automatic MEDIASOURCE: c SQLUSERDBDIR: <empty> SQLUSERDBLOGDIR: <empty> SQMREPORTING: False TCPENABLED: 0 X86: False Configuration file: C: \ Program Files \ Microsoft SQL Server \ 100 \ Setup Bootstrap \ Log \ 20100913_144043 \ ConfigurationFile.ini Detailed results: Feature: Database Engine Services

Net security code group node: MSVCM80 01 / 21 / 2009 07:05:55.463 Processing entry ("MICROSOFT.SQLSERVER.CHAINER.SETUP", "Native") 01 / 21 / 2009 07:05:55.463 Attempting to create .Net security code group node: MICROSOFT.SQLSERVER.CHAINER.SETUP 01 / 21 / 2009 07:05:55.463 Processing entry MICROSOFT.SQL.CHAINER.PACKAGE", 01 / 21 / 2009 07:05:55.463 Attempting to create .Net security code group node: MICROSOFT.SQL.CHAINER.PACKAGE 01 / 21 / 2009 07:05:55.463 Processing entry ("MICROSOFT.SQLSERVER.CHAINER.INFRASTRUCTURE", "Native") 01 / 21 / 2009 07:05:55.479 Attempting to create .Net security code group node: MICROSOFT.SQLSERVER.CHAINER.INFRASTRUCTURE 01 / 21 / 2009 07:05:55.479 Processing entry ("MICROSOFT.SQLSERVER.CONFIGURATION.BOOTSTRAPEXTENSION", "Native") 01 / 21 / 2009 07:05:55.479 Attempting to create .Net security code group node: MICROSOFT.SQLSERVER.CONFIGURATION.BOOTSTRAPEXTENSION 01 / 21 / 2009 07:05:55.479 Processing entry ("MICROSOFT.SQLSERVER.SETUP

the isntall. I thought ok, I will try installing the actual MSDE application direct from Microsoft. So, I downloaded the MSDE for SQL 2000 (which is msde2000a.exe), set my switches appreciated! Thanks. hi, the "traditional" problem related to this event is described in http: / / support.microsoft.com / kb / 816499 / en-us please try having a look at the referenced KB article. . regards - - Andrea Montanari (Microsoft MVP - SQL Server) http: / / www.asql.biz DbaMgr2k ver 0.21.1 - DbaMgr ver 0 troubleshooting the faling installation. . additional manual uninstall / cleanup instructions can be found at http: / / support.microsoft.com / kb / 320873 / EN-US / and http: / / support.microsoft.com / kb / 290991 / EN-US / regards - - Andrea Montanari (Microsoft MVP - SQL Server) http: / / www.asql.biz DbaMgr2k ver 0.21.1 - DbaMgr ver 0 apply any updates, completely bare bone. I downloaded a fresh copy of the MDSE from Microsoft at http: / / www.microsoft.com / downloads / details.aspx?FamilyId = 413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang = en#filelist I am

System.Windows.Forms.StatusBar.StatusBarPanelCollection.Add(System.Windows.Forms.StatusBarPanel value) + 0x2b bytes SQLEditors.dll!Microsoft.SqlServer.Management.UI.VSIntegration.Editors.QEStatusBarManager.TransitionIntoOnlineMode(string serverNameText = "(local) (9.0 SP2)", string userNameText = SQLEditors.dll!Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.UpdateUIForNewConnection(Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo ci Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo}, System.Data.SqlClient.SqlConnection sqlConn = {System.Data.SqlClient.SqlConnection}) + 0x3a5 bytes SQLEditors.dll!Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.OnScriptGotNewConnection(Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo ci = {Microsoft.SqlServer.Management.Smo.RegSvrEnum.UIConnectionInfo}, System.Data.IDbConnection conn = {System.Data.SqlClient.SqlConnection}) + 0x10f bytes SQLEditors.dll!Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.Connect() + 0x22c bytes SQLEditors.dll!Microsoft.SqlServer.Management.UI

SQL Server SQL 2005 Performance Dashboard Hi, I downloaded SQL 2005 Performance Dashboard from Microsoft and I installed it. However, while running setup.sql I got the following errors. Why exist or you do not have permission. Here is the script that was provided by Microsoft: - - Script must not be run in a transaction SET IMPLICIT_TRANSACTIONS OFF IF @@TRANCOUNT > 0 ROLLBACK fn_hexstrtovarbin(@plan_handle), @stmt_start_offset, @stmt_end_offset) as p select @xml_plan = convert(xml, @plan) ;WITH XMLNAMESPACES ('http: / / schemas.microsoft.com / sqlserver / 2004 / 07 / showplan' AS sp) insert into @output select nd.node_id, x.parent_node_id just show the statement type if available if @@rowcount = 0 begin ;WITH XMLNAMESPACES ('http: / / schemas.microsoft.com / sqlserver / 2004 / 07 / showplan' AS sp) insert into @output (stmt_text) select isnull(@xml_plan.value max) declare @table nvarchar(256), @alias nvarchar(256), @column nvarchar (256) ;WITH XMLNAMESPACES ('http: / / schemas.microsoft.com / sqlserver / 2004 / 07 / showplan' AS sp) select @alias = @node_data.value('(. / sp:ColumnReference / @Alias)[1 as begin declare @output nvarchar(max) declare @count int, @ctr int ;WITH XMLNAMESPACES ('http: / / schemas.microsoft.com / sqlserver / 2004 / 07 / showplan' AS sp) select @output = N'', @ctr = 1, @count = @node_data.value iterate over each element in the list while @ctr < = @count begin ;WITH XMLNAMESPACES ('http: / / schemas.microsoft.com / sqlserver / 2004 / 07 / showplan' AS sp) select @output = @output + case when @ctr > 1 then node_data xml) returns nvarchar(max) as begin declare @output nvarchar(max) ;WITH XMLNAMESPACES ('http: / / schemas.microsoft.com / sqlserver / 2004 / 07 / showplan' AS sp) select @output = convert(nvarchar(max), @node_data.query('for