Help me, please.
I'm trying to get just updated or inserted data from the tables of SQL Server 2005 by Integration Services.
How can I do it?
View Complete Post
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
Hi, I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).
1. The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line
response.StatusDescription; // this has value of "OK"
2. How can I debug the server code side where to receive the request from client side who posts the data ?
The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.
Client side codes: // also run on my local computer
public string PostIntegrationXml(XmlDocument xmlSubmitDoc)
Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.
MSDN Magazine August 2010
New spatial data support in SQL Server 2008 opens the door to mapping and querying geometric and geographic data, allowing you to build exciting new applications.
MSDN Magazine February 2009
Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.
MSDN Magazine September 2008
Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.
MSDN Magazine July 2008
SQL Server 2005 gathers a lot of useful data that you can use to identify areas where database performance can be improved. Here's what you need to improve performance.
MSDN Magazine January 2008
SQL Server Management Objects offer developers a robust toolset for backing up and restoring databases, and issuing DDL commands, as John Papa explains.
MSDN Magazine June 2007
Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.
MSDN Magazine February 2007
Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.
MSDN Magazine October 2006
Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.
MSDN Magazine July 2006
Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.
MSDN Magazine June 2006
SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.
MSDN Magazine May 2006