My database when to suspect mode.... Now I changed it to emergency mode how can I recover it...
Need detail help... not that familuer with sql ...
View Complete Post
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.
MSDN Magazine June 2005
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
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
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.
MSDN Magazine May 2002
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
The Web Storage System (WSS) in Exchange 2000 is a Web-accessible database that stores any type of data such as e-mail, contacts, appointments, threaded discussions, and multimedia files, and renders the data in HTML in any browser. WSS is based on Internet standards, therefore data can be accessed through URLs, an Exchange OLE DB provider, drive mapping, XML, and Web Documenting and Versioning (WebDAV). This article discusses the WSS schema and how to extend the default schema for custom data. A sample application that uses a custom schema and a custom form to display WSS data is available for download.
MSDN Magazine May 2001
The way you choose to transfer data is vitally important in a distributed application. Windows 2000 provides several new features that allow you to transfer data more efficiently. Lightweight handlers allow you to write smart proxies that can cache results and perform buffered reads and writes, minimizing the number of network calls. Windows 2000 also allows you to use pipe interfaces to transfer large amounts of data efficiently through a read-ahead facility. This article illustrates several ways to improve data transfer in Windows 2000 using these new features. It also reports the results of transfer time tests and provides recommendations for transferred buffer sizes.
MSDN Magazine September 2000
i am upgrading 2000 olap cube to 2005. i built an ssas project and deploy to the server.
the 2000 olap cube store it's data in partitions - one for each month.
the face table delete it's data and store data for only the last 13 month so basically most of the data
is store onle in the 2000 cube.
while upgrading the cube and processed it , a lot of information had lost.
i know that i cant restore the fact from the partiotn data but is there a way to copy the partition has is
from olap 2000 to 2005?
How to Import data from sql server 2008 to sql server 2000 ? (i don't have any idea about SSIS, expect this any chance is there? i was try with import functionality some records are copy after it was faild i have nearly 80 Lacks records)
Please help me how to solve this issue this is very urgent form me...
we have a SSRS report which was working till few weeks backs on all the ie and started to show Diagnose the Internet connection error on ie6 and permission denied on ie7. although the report is running fine on ie8 and firefox with same security settings.
There has been no recent changes done to the report. tried it through fiddler but gives a 200 status for http. IS also connecting to URL and is making connect to the DB. HAve tried to check the script and activex settings also and found nothing absurd which
can stop the functionality.I have tried reducing the security to low also but with success. Can someone please help.
ExpiryDate column in Table Data Type is NVARCHAR , storing Dates ONLY without time as 2/10/2010 , 12/10/2010 IN DD/MM/YYYY FORMAT.
NOW IT IS REQUIERD TO RETRIEVE ALL RECORDS WHERE EXPIRYDATE BETWEEN USER PASSED START MONTH,START YEAR AND END MONTH, END YEAR.
USING SQL SERVER 2000
SUM(CASE WHEN CONVERT(datetime,a.expirydate,103) >= (CONVERT(datetime,'2010-01-07',103)) AND
CONVERT(DATETIME,a.ExpiryDate,103) < dateadd(month,1,(convert(datetime,'2010-01-09', 103))) THEN 1 ELSE 0 END) AS Expired
Your help is greatly appreciated. Spent hours to get this resolved.
We have Windows Advanced Server 2000 and SQL Enterprise Edt. 2000. Our application is client-server application.
On server we have Server Components they use - IIS, COM+, message queueing and SQL.
On client side is VB 6.0 client. Client sends XML request to our IIS.
Now, we are trying to do migration from 2000 to 2008 Environment (x32).
We install Windows Enterprise Edt. 2008 and SQL Enterprise Edt. 2008 R2.
DBA did conversion of our 2000 database, and now it is on SQL 2008 R2.
On server we also install Server Components they use IIS 7, COM+, message queueing and SQL.
We have problems with big quantity of data.
On server, through SQL Analyser - when we send a query - it works - very quickly.
On client when we send same search it fails. It depend on question, client sometimes failed after 30 sec, sometimes after 50 sec.
I don't know where to start looking?
I check IIS 7, time out, etc.
- could it be that SQL 2008 R2 sends some other type of data, then client expects?
- could it be some xml parser error?
- or somewhere on Windows 2008 or IIS ?
This looks for me like "cloudy" question, but pls if anyone have some idea let me know.
thank you for your time,