SQL Server (RSS)

SQL Server

New Article: SQL Server Disaster Recovery

SQL Server Disaster Recovery
By Microsoft Team
This bulletin gives an introduction on how to go about developing a disaster recovery strategy for SQL Server. Also included is a case study demonstrating typical considerations when designing a disaster recovery strategy. (Monday, December 08, 2003)

Read More     Discuss in the Forums     See More Articles

Whole Mess of New SQL Server Article on SqlJunkies

Featured:

Running Stored Procedures

By Wayne Freeze
In this article, you’ll learn how to extract a list of stored procedures from a database, plus information about the parameters associated with the stored procedure. Finally, you’ll see how to take this information and use it to call a stored procedure on the fly. (Monday, December 01, 2003)

Read More     Discuss in the Forums     See More Articles

Troubleshooting and Debugging SQL Web Services Configurations (Monday, November 24, 2003)
In this article, over 20 frequently asked questions about SQL endpoint configuration, the Windows HTTP API driver, and Web Services authentication are answered.

Merge Modules and MSDE (Sunday, November 23, 2003)
Merge modules are a feature of Windows Installer that provide a standard method for delivering components, insuring that the correct version of a component is installed. A merge module contains a...

Moving Tables and Indexes between Filegroups (Sunday, November 23, 2003)
In this bulletin, two frequently asked questions centered around moving data between various database files are discussed.

SQL Mail (Sunday, November 23, 2003)
SQL Server provides the ability to send and receive e-mail by using SQL Mail. SQL Mail has stored procedures and extended stored procedures that can be used to manipulate data, process queries...

New SqlJunkies Articles (Including Yukon Beta 1)

We published the following articles on SqlJunkies.com today:
 
Yukon Demo: AdventureWorks Contacts
By Jason Stowe - An Example Using SQLCLR Stored Procedures with HTTP Endpoint using HttpWebRequest/HttpWebResponse and Generated Proxy Classes
 
SQL WebBench is a stand alone browser based application that demonstrates Native SQL Web Services in Microsoft® SQL Server™ Yukon Beta 1. SQL Web Bench allows for HTTP SOAP endpoint manipulation and the ability to invoke remote SQL web services right from your browser via a WSDL XSL transform. SQL Web Bench demonstrates and exposes the raw SOAP that is sent and received from the server.
 
This step-by-step article describes how to move a database diagram that was created in SQL Server Enterprise Manager. Database diagrams are contained in the dtproperties system table of the database.
 
This article describes how to implement a callback function during the installation of the SQL Server 2000 Desktop Engine (MSDE 2000) and also discusses all the conditions that must be met to make sure the callback function runs properly.
 
Using the sp_fixindex Stored Procedure
This article discusses how to use the undocumented sp_fixindex system stored procedure to correct problems in the indexes of SQL Server system tables.
 
When you query a linked server, you frequently perform a pass-through query that uses the OPENQUERY, OPENROWSET, or OPENDATASOURCE statement. You can view the examples in SQL Server Books Online to see how to do this by using pre-defined Transact-SQL strings, but there are no examples of how to pass a variable to these functions. This article provides three examples of how to pass a variable to a linked server query.