.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

SQL server 2008 - Unable to tune a query with DTA

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
 
We are on:Verison: SQL 2008 [10.0.2531] on windows server 2008. Both are enterprise editions.When I highlight the query and right-click, then select Analyze Query in Database Engine Tuning Advisor, then click "Start Analysis",  I get the following error in the "Message" column of "Progress" tab of DTA: Cannot initialize tuning. [.Net SqlClient Data Provider] If I click on this, it displays this message: "Cannot find either column 'msdb' or the user-defined function or aggregate 'msdb.dbo.fn_DTA_unquote_dbname', or the name is ambiguous. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count=0, current count=1. (Microsoft SQL Server Error: 4121)Please let me know if you guys have any ideas on this error. Thanks,Sam. 


View Complete Post


More Related Resource Links

Query on XML datatype in SQL Server 2008

  
Hi All, In table I have column with XML datatype. I can able to read the below XML tag. SET   @Title = CAST(@XMLContent.query('data(root/chemicalName)') AS VARCHAR(50)) <root><chemicalName>Sulphuric acid</chemicalName></root> but how can I read (in SQL Server 2008) with multiple rows in it, and how to know the list of child nodes and data of it dynamically? <Root> <Row> < CurrencyCode>GBP</CurrencyCode> < CurrencyName>POUND (STERLING)</CurrencyName> </ Row> <Row> < CurrencyCode>INR</CurrencyCode> < CurrencyName>Rupee</CurrencyName> </ Row></

Unable to install SQL Server 2008 Express R2 after installing .NET 4.0

  
Hi experts, I intend to redistribute SQL Server 2008 Express R2 in my installer. I've extracted the setup files from SQLEXPR32_x86.exe and pass in the appropriate command line parameters during the setup. Recently, I noticed if I applied the following Windows Update: .NET 4.0 Client Profile, I will hit into the following error when I installed SQL express. .NET Runtime 4.0 Error Reporting EventType clr20r3, P1 setup100.exe, P2 10.50.1600.1, P3 4bb67524, P4 mscorlib, P5 4.0.0.0, P6 4ba1da6f, P7 44f0, P8 32, P9 system.security.security, P10 NIL. .NET Runtime Application: setup100.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Security.SecurityException Stack: at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() at Microsoft.SqlServer.Chainer.Setup.Setup.Main() Running the setup.exe from a file server will give these errors but if I copied the entire setup files to a local folder and run setup.exe from there, it runs fine. May I know what am I missing? I definitely need to support to install SQL express running from a file server location. Thanks, MK  

Unable to create Web Folders in Windows Server 2008 R2

  
Hi, We are unable to create web folder from a Windows Server 2008 R2 system as we do in Windows XP. The web url cannot be identified. The web url is an oracle repository application built in 32-bit OS and now we need this to be added in Windows Server 2008 R2 machine. Kindly help.  

SQL server management studio 2008 freezes when running a query to Grid result

  
Hello, I've got problems when I run a Query to a grid result using SQL server management studio 2008 under W7 pro. When I execute the query, the first part of the grid returns, but then it freezes. The query should present a double resultset and contains approx 6100 records, devided over 2 grids. Strange enough, the query runs fine when I export to TXT or to a file. It seems though that the problem is building the grid. When it occurs I cannot end the application bij shutting down de SSMS window, but have to kill the Ssms.exe. In task manager I see only 25% CPU usage and approx 20% memory usage. Nothing exiting there I guess. Suggestions anybody? Microsoft SQL Server Management Studio      10.0.2531.0 Microsoft Analysis Services Client Tools      10.0.3798.0 Microsoft Data Access Components (MDAC)      6.1.7600.16385 Microsoft MSXML      3.0 4.0 5.0 6.0 Microsoft Internet Explorer      8.0.7600.16385 Microsoft .NET Framework      2.0.50727.4952 Operating System      6.0.6001 regards, Pim

Unable to connect SQL Server 2008

  
Hi, I have recently installed a trial copy of SQL Server 2008 from MS web but I am not able to connect to the SQL Database Engine locally using Windows Authentication. Whenever, I tried I got the following error message: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)" Just to inform you, I have OS Win7.  And I want to establish local connections only on my laptop.

SSMS 2008 Activity Monitor Activity Monitor is unable to execute queries against server (SQL Server

  
I get the following error when running SQL Server SSMS 2008 (32-bit) on my (Windows 7 64-bit) workstation against our SQL Server 2005 (32-bit) development server running Windows Server 2003 (32-bit): TITLE: Microsoft SQL Server Management Studio ------------------------------ The Activity Monitor is unable to execute queries against server <my server\instance name>. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. ------------------------------ ADDITIONAL INFORMATION: Unable to find SQL Server process ID 2256 on server VTX-DEV-01 (Microsoft.SqlServer.Management.ResourceMonitoring)   I can expand the panes and all display data except Overview and Data File I/O. This is true for all instances on that server. The SSMS 2005 Activity Monitor (also on my workstation) works fine when connected to that server. I checked for the registry setting to disable the performance counters on both my machine and the server, and it was not there. I started the Performance Counter DLL Host on my machine, but that made no difference. I can see all Processor counters on the server from my local Performance Monitor. I ran "lodctr /R" on both systems, but that didn't help. The only SQL counters I see on the server (from my workstation) are SQLServer:SSIS Pipeline and SQLServer:SSIS

Unable to start T-SQL debugging SQL Server 2008

  
I'm getting exactly the same problem described here: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/dcc851e7-35d7-492a-b15c-7dffe47110ed --------------------------- Microsoft SQL Server Management Studio --------------------------- Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'myserver'. Click Help for more information. --------------------------- OK   Help   --------------------------- I've followed advice with regards to Windows Firewall, however it's disabled on both client and server.  I've tried using a SQL Server account but haven't had any more success.  I've also checked the windows event logs on both the client and the server and can't find anything.. Lastly (not sure if this is useful or not) I tried attaching to the Ssms.exe process from Visual Studio 2008 and I get the following output when I try debugging:  ... C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.CommonIDE\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.CommonIDE.dll: Cannot find or open the PDB file. C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.DataWarehouse.VsIntegration.dll: Cannot find or open the PDB file. 'Ssms.exe': Loaded 'C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SQLDE.dll' First-chance exception at 0x7c812a6b in Ssms.exe: 0

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

  
I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

query with locks not working in sql server 2008

  
I have a select query with join on some view and locks as (readpas,updlock) after executiong this query it executes the same query with little modification( no locks etc). This sequence of query executes fine in SQL server 2000/2005.   When I am executing same seq in sql server 2008 through application, I am getting timeout for second query. Can someone please suggest what can be the reason? I cannot post the query.Cheers!!! Vatsa

Unable to install SQL Server 2008

  
HI, I am uable to install SQL SERVER 2008 in my machine. The setup checks in the pre requisites and it fails for a server reboot. It prompts me to reboot the machine. I have already rebooted my machine thrice but still its prompting me for a reboot. Can anyone guide me through this?     Regadrds, Shannid

sql 2008: the activity monitor is unable to execute queries against server

  
Installed sql server 2008 entrprise edition on VM server windows 2008 (64bit). When launch Activity Monitor, get:

The Acityvity Monitor is unable to execute queries against server <server name>.
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.

Additional information:
   Unable to find SQL Server process ID xxxx on server <server name>
   (Microsoft.SqlServer.Management.ResourceMonitoring)



Tried to "use he context menu in the overview pane to resume the Activity Monitor" and got the same error again.

Installed sql 2008 in my XP machine, I can use Activity Monitor (AM) for local instance but cannot launch it for the instance on the server (same error).

Used windows authentication with sysadmin role for connection from my machine. On the server used domain\administrator that the account created the instance.

Please help.

SQL Server 2008: unable to grant server roles

  

SQL Server 2008 Enterprise (10.0.2531.0) installed on SQL Server 2003 R2 SP2.

I am logged in as sa and I try to grant sysadmin (or any server role) to a new account (either windows or sql authentication) and it fails without an error. If I use the gui in the management studio it says okay but when you check the role is not granted. If I use t-sql command (sp_addsrvrolemember) it doesn't generate an error but again nothing happens. The role is not granted.

Help.


Unable to connect Excel 2003 from linked server in sql 2008 64 bit

  
Hi ALL,

I was unable to connect to excel 2003 with linked server created in sql server 2008 64 bit. This was working fine with sql server 2005 32 bit.

I know that there no 64 bit drivers for JET drivers, but i am looking for some alternative ways to do the same job.

I dont want to migrate to Excel 2007.

Thanks in advance for all your help.

Thanks,
Loknath

Unable to change autogrowth properties of SQL Server 2008 data and log files

  

I have used the GUI and the CLI to attempt to change SQL Server 2008 log file autogrowth property all to NO avail. In other words, there are NO error messages of any kind, indeed the CLI reports that the command completed successfully. But re-examining the database properties shows that NO change was effected.

For the CLI command, I have used the following with dots filled in for my database and logfile:


ALTER DATABASE ... MODIFY FILE ( NAME = ..., FILEGROWTH = 10%)

Why doesn't this work? How to make it work?

Thanks


SSRS 2008 SP1 Unable to get cataloge items from server.

  

When I access the report server locally I can access the report builder 1.0 click-once application without problems and it is able to show me a list of the reports.  When I access the same report server via our load balancer that does SSL off-loading I get the error message "Unable to get cataloge items from server." the details of which are below:

An existing connection was forcibly closed by the remote host
----------------------------
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
----------------------------
The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.

I had to enable basic authentication and allow anonymous access to the report builder so my client could access it from their computers on their domain.  They have accounts on my domain which they are prompted for and enables them to access the reports website and the report builder application.  Its only when they try to open a report with the report builder that they get this error message about being able to get the catalog.

SQL Server 2008 SP1
Windows Server 2008

Any ideas?


Looking for Client Query Analyzer (SQL Server 2008) or Equivalent Reporting Tools

  

I've recently upgraded from SQL Server 2000 to SQL Server 2008.  My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports.  Unfortunately Query Analyzer is now bundled into the management studio.  That's a bit too much software for this level of power users.

Is there a client-side query analyzer for SQL Server 2008?  I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too.  Looking for something simple that will:

1.  Show users the database tables and/or views

2.  Run queries

Perhaps query analyzer isn't the way to go and my team needs a different reporting system.  If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need?  They will still need to look at raw data to build Crystal Reports though.


Query execution failed using SQL Server 2008 R2 (RTM)

  
I have a reporting services application that is returning an error running a report which uses an MDX query. This same report is running successfully on other systems using Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64). But this system returning the error is using this version: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64). I'm inclined to think that R2 is using different rules for the parameter because the position indicated below (4,33) is date parameter (@Date), and the same report is running fine in SP1.

When I run the report via the report manager, this syntax below returns the error shown at position (4,33) which is the position of @Date.

 

linkmember(StrToMember(@Date).parent.lag(4).firstChild,[Origination Date].[Date])

 

ApplicationException: Error processing alert report ...: System.Web.Services.Protocols.SoapException: An error has occurred durning report processing. --> Microsoft .ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. --> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset '...'. --> Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseExceition: Query(4,33) Parser: The syntax for 'Date' is incorrect.

At Microsoft.ReportingServi
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend