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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Sgraph Infotech
Imran Ghani
Post New Web Links

SQL 2000 server has an issue after an unidentifed event and began running at a snails pace.

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

One of our SQL 2000 servers has an issue after an unidentifed event and began running at a snails pace.

     I know SQL 2000 is no longer supported.

We are running IIS on the same server and no connection can be made to the SQL server on the same machine.

     Microsoft OLE DB Provider for ODBC Drivers error '80004005'

     Specifed driver could not be loaded due to system error 5 (SQL Server).

A std query from outside the server works fine until a  Join is added then it runs forever.

A backup and restord did nothing as well as reindexing, shrinking and optimizing. 

After restoring the database on another SQL 2000 server we compared the speeds.

Bad server 4:22 minutes good server less then 1 second.

Any sugguestions??????  r.morrison@gerresheimer.com




View Complete Post


More Related Resource Links

Query to list currently running queries on the sql server 2000

  
Hi all Who to check, what all queries are running curently on the sql server 2000, I need to list who all logged in and what queries are getting executed and how long its running. Thanks in advance. shan  

microsoft management console issue in SQL Server 2000

  

Hi Team,

I have an issue starting the management console (enterprise manager), Installed SQL Server 2000 and when i try to open the enterprise manager got a pop-up Microsoft management console the selected file cannot be found.

more info installed using my username but am not the admin of the machine is this causing the issue, though i didn't face any issue in the installation and i haven't restarted the server after installation.

Any help would be greatly appreciated!!

Regards,

Eshwar.


Running SSIS on 64-bit server - dll issue

  

Hi,

We have a SSIS package which refreshes an Excel 2007 file using a script task - references the Microsoft.Office.Interop.Excel.dll

Runs Ok on 32-bit dev PC - returns this error on server: "Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x80040154): Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154.

at ST_351c98ccd83b4e988e50f7e36003277f.vbproj.ScriptMain.RefreshExcel()

at ST_351c98ccd83b4e988e50f7e36003277f.vbproj.ScriptMain.Main()

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, Cul

sp4 Sql server 2000 version issue

  

I have two sql servers one with version 2000.8.00.2050 and another with 2000.8.00.2055.

I want to upgrade 2050 to 2055. How can I do that.? I thought it is matter of sp4. so I installed a file [SQL2000-KB884525-SP4-x86-ENU.EXE] from

http://www.microsoft.com/downloads/en/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en.

But this makes no difference to version.

Do I need to apply some hotfixes?

Thanks!


ODBC connection issue to SQL 2000 SP4. [TCP/IP Sockets]Specified SQL server not found

  

Server: Stand alone Windows 2003 R2 Enterprise x64 Edition Service Pack 2

The server has 4 quad-core processors with 32Gb RAM

SQL: 2 instances of SQL Server 2000 Enterprise Edition SP4 with cumulative update version: 8.00.2040

I am trying to connect to the named instance of SQL Server with an ODBC connection. I am a local admin on the server and a sysadmin on both the default instance and the named instance. I get the error message

Connection failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

My users are trying to connect via SQL login and are also receiving the same error message.

The default instance is listening on port 1433. The named instance is listening on port 1464. There is no Windows firewall installed on the server.

The annoying thing is that if I click on the button called "Client Configuration" when using the "ODBC Data Source Administrator" dialogue wizard, and I un-tick the radio box called "Dynamically determine port", and hardcode the port 1464 into the dialogue box, everything works as it should do.

Unfortunately this

ODBC connection issue to SQL 2000 SP4. [TCP/IP Sockets]Specified SQL server not found.

  

Server: Stand alone Windows 2003 R2 Enterprise x64 Edition Service Pack 2

The server has 4 quad-core processors with 32Gb RAM

SQL: 2 instances of SQL Server 2000 Enterprise Edition SP4 with cumulative update version: 8.00.2040

I am trying to connect to the named instance of SQL Server with an ODBC connection. I am a local admin on the server and a sysadmin on both the default instance and the named instance. I get the error message

Connection failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.

My users are trying to connect via SQL login and are also receiving the same error message.

The default instance is listening on port 1433. The named instance is listening on port 1464. There is no Windows firewall installed on the server.

The annoying thing is that if I click on the button called "Client Configuration" when using the "ODBC Data Source Administrator" dialogue wizard, and I un-tick the radio box called "Dynamically determine port", and hardcode the port 1464 into the dialogue box, everything works as it should do.

Unfortunately this

Issue in SQL server agent job running SSIS package containing a batch script.

  

I have a package that I have created that runs locally and as package on the server that has a batch script with in it and it run correctly when manually run. But when I create a sql server agent job it runs the job but doesn't execute the package but returns with a successful run. I have setup a proxy account trying to run it with this. I have given the permission to the batch script to the file that the SQL service account. I have tried everything I can think of even setting the package creator to the same name as the service account in the package, and even doing a dtexec command from the SQL job. If I run the dtexec from a cmd prompt the package runs. Need help please thanks.

 

 


sql server 2000 vs 2005

  

i would like to ask what the difference between sql server 2000 and 2005 


Word Automation Issue in Windows Server 2008 Hosting

  

Hi,

The problem I am posting here is that I was facing nearly 2 weeks around. Any body comes with this stuff please help.

Word Automation in sample ASP.NET(C#) application.

I am using Microsoft.Office.Inetrop.Word Assembly for automation. Here I am reading a XXX.dot template file and fill the contents with dynamic data.

When i am executing my code in localhost:someportnumber the automation is working fine and I could get expected result and when I am hosting in my inetmgr(Windows XP is my OS) it is also working fine.

But the problem is that when I am hosting in my production server(Windows Server 2008 Standard Edition) I am not able to perform automation and results in the following error.

Data: System.Collections.ListDictionaryInternal
Message: Word has encountered a problem.
Source: Microsoft Word

The code gets failed in the following line:

ApplicationClass wordApp = new Microsoft.Office.Interop.Word.ApplicationClass();

Document wordDoc = wordApp.Documents.Add(ref oTemplate, ref oFalse, ref oMissing, ref oMissing); // Error in this line

I cannot able to proceed further. Can anybody please help me in solving this issue?

Thank you.


With Regards,

Ashok



Team System: Team Foundation Server Event Service

  

Use the Team Foundation Server EventService to create and manage event subscriptions or create a Web service to receive and process events.

Brian A. Randell

MSDN Magazine May 2008


Data Points: XML Features in SQL Server 2000

  

SQL ServerT 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML. For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or even modify data in the database.

John Papa

MSDN Magazine June 2005


OLAP: Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP

  

Many organizations analyze their business-critical data using Online Analytical Processing (OLAP) technology. OLAP-based data mining provides a way to query multidimensional data sets and drill down into the data to find patterns. ASP.NET and the Microsoft Office Web Components (OWC) enable Web-based OLAP reporting. The OWC controls include PivotTable and Chart components that can be embedded in a Web page and scripted by programmers. In this article, the authors build a Web-based OLAP reporting app using ASP.NET, OWC, and SQL Server 2000 Analysis Services to illustrate the process.

Jeffrey Hasan and Kenneth Tu

MSDN Magazine October 2003


Metadata: Create a Database Schema Repository with Meta Data Services in SQL Server 2000

  

SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.

Alok Mehta and Ricardo Rodriguez

MSDN Magazine May 2003


Scripting SQL: VBScript Interfaces in SQL Server 2000 Let You Transform Data and Provide Reports to

  

Application service providers often must send information to clients automatically rather than on-demand. For example, a manufacturer may want to know each day how many of their products were sold by a retail chain. While SQL Server is ideal for maintaining this type of database, you have to write scripts to get the data out in a client-friendly format. Here you will see how you can use Data Transformation Services (DTS), a powerful tool in SQL Server, to automate the retrieval and formatting of data from SQL Server 2000 and make the process of pushing data to your users a lot easier.

Alok Mehta and Daniel Williams

MSDN Magazine August 2002


SQLXML 3.0: Build Data-Driven Web Services with Updated XML Support for SQL Server 2000

  

XML is becoming the ubiquitous data format on the Web, and XML support in SQL Server is evolving to meet the additional demand. Using XML, SOAP, HTTP, and SQL Server, you can now build powerful Web Services easily. To show just how simple it is with SQLXML 3.0, this article walks the reader through the process step by step, from setting up a virtual directory enabling data access via HTTP to executing queries and building Web Services. Finally, the author illustrates the creation of two Web Services clients-one with C# that works with the Microsoft .NET Framework and one with the SOAP Toolkit 2.0 for anyone still using earlier development tools.

Christian Thilmany

MSDN Magazine May 2002


SQL Server 2000 and XML: Developing XML-Enabled Data Solutions for the Web

  

Using XML for data access allows you to separate the data from the presentation, and promotes reuse, extensibility, and division of labor. XML also has a simplified data model, which promotes easier testing. This article presents and compares five data access approaches, using a variety of technologies including ASP and ADO, XSLT, and DirectXML. Once built, the solutions are compared on the basis of their speed and efficiency.

Scott Howlett and Darryl Jennings

MSDN Magazine January 2002


BizTalk and XML: Add E-Commerce to Your App with XML and SQL Server 2000

  

XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information. The sample app presented here uses updategrams to make the database updates. To accomplish this, the mapping and usage of updategrams is explained. In this example, BizTalk is used to illustrate the XML capabilities of SQL Server 2000.

Christian Thilmany

MSDN Magazine January 2002


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