2542 Users read it.
Undocumented Stored Procedures in SQL Server 2000
(November 21, 2007)
This article presents several useful undocumented stored procedures in SQL Server 2000
28038 Users read it.
HOW TO: Configure SQL Server Security for .NET Applications
(December 16, 2003)
This article describes how to configure the SQL Server for .NET applications. By default, the SQL Server denies access to user accounts that have not explicitly been granted access to a database, a table, or a view. By default, ASP.NET applications run in the context of the ASPNET user account. Unless you permit access to the ASPNET user account, an ASP.NET application cannot read and cannot update data in an SQL Server database. This article describes the process that you can use to permit an ASP.NET application to have permissions to an SQL Server 2000 database.
Note You must give the ASPNET user account only minimal permissions to run. This limits the potential damage that may result to an ASP.NET application that is compromised by a malicious attacker.
Note You must give the ASPNET user account only minimal permissions to run. This limits the potential damage that may result to an ASP.NET application that is compromised by a malicious attacker.
4294 Users read it.
Using SQL in .NET
(July 28, 2003)
I usually see code samples using SELECT SQL queries but I don't see many articles using other SQL queries. In this article, I will show you how to execute SQL queries from your VB.NET applications.
15448 Users read it.
Data Transfer from SQL Server to Excel
(July 24, 2003)
The Interoperability services help our life very easy to work with COM Applications like Excel. .NET platform provides necessary services to use existent application written in visual basic, C++ and so on. In this application, we will see how we can transfer data from Microsoft SQL Server into Excel spreadsheet. To use the Excel in your .NET application.
