Atlanta Custom Software Development 

 
   Search        Code/Page
 

User Login
Email

Password

 

Forgot the Password?
Services
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
Programming
VB VB (1648)
VB.net VB.net (736)
C# C# (15)
ASP.net ASP.net (779)
ASP ASP (41)
VC++ VC++ (25)
PHP PHP (0)
JAVA JAVA (4)
JScript JScript (5)
  Database
» SQL Server (708)
» ORACLE (5)
» MySQL (0)
» DB2 (0)
Automation
» C/C++/ASM (11)
» Microcontroller (1)
» Circuit Design (0)
OS/Networking
» Networking (5)
» Unix/Linux (1)
» WinNT/2k/2003 (8)
Graphics
» Flash (0)
» Maya (0)
» 3D max (0)
» Photoshop (0)
Links
» ASP.net (2)
» PC Interfacing (1)
» Networking (4)
» SQL Server (4)
» VB (23)
» VB.net (4)
» VC (3)
» HTML/CSS/JavaScript (10)
Tools
» Regular Expr Tester
» Free Tools

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )

This is a link to a different site Embedding MSDE SQL Engine in a Visual Studios .Net Setup application
Total Hit (1069) This document is a step by step description of adding SQL server to an Windows Application and embedding the MSDE engine into the application setup and installer program. By doing this you will automate the installation of the SQL server, the mounting of the datafiles and granting access to your app ....Read More
Rating
Estimate the table size (Data + Index) for a given # of rows
Total Hit (1940) Ever tried to estimate the table total size which include data and index in calculation ? Believe me its not easy job to estimate the size of a table for a give # of rows. Here is the kool SP which does it for you. Full credit goes to Sharon Dooley for his excellent Job. «code LangId=6»if exis ....Read More
Rating
Error : "The provider could not support a row lookup position....."
Total Hit (4360) Sometimes when you try to do update/delete or insert on linked server you might get the following error. «font color=red»Server: Msg 7306, Level 16, State 2, Line 1 Could not open table '"Mydb"."dbo"."myTable"' from OLE DB provider 'SQLOLEDB'. The provider could not support a row lookup po ....Read More
Rating
Tutorial - Introduction to Microsoft.net
Total Hit (7931) «a name=#L1»«/a» «big»Introduction«/big» This tutorial series is intended to initiate the reader into the world of .NET. I will try to cover most of the important .Net features. This tutorial will be useful for anyone with a programming background, especially for those who know VB. There ar ....Read More
Rating
This is a link to a different site How To Enable ODBC Connection Pooling in a Visual Basic ADO Application
Total Hit (1904) By default, ADO uses OLEDB session pooling to maintain a pool of connections to the database. In some cases, you might want to use ODBC connection pooling instead of OLEDB session pooling. This article describes what is necessary to enable ODBC connection pooling from a Visual Basic/ADO application. ....Read More
Rating
Get list of installed ODBC drivers using ODBC API.
Total Hit (6048) Here is a small code snippet to list all installed ODBC Drivers (name and attribute). On my machine I got the following output. «code LangId=0» SQL Server UsageCount=3 : SQLLevel=1 : FileUsage=0 : DriverODBCVer=02.50 : ConnectFunctions=YYY : APILevel=2 : CPTimeout=60 -------------------------- ....Read More
Rating
Get List of User/System DSN on your local machine using ODBC API
Total Hit (5229) «b»Step-By-Step Example«/b» - Create a standard exe project - Add the following code in form1 - Press F5 to run the project «code LangId=1»Option Explicit Private Declare Function SQLDataSources Lib "odbc32.dll" _ (ByVal hEnv As Long, _ ByVal fDirection As Integer, _ ....Read More
Rating
sp_CrossTab : Stored Procedure to create cross tab output in SQL Server
Total Hit (11221) We know that SQL Server does not have TRANSFORM function or similar functionality which you have in MS Access but here is the stored procedure to make your life easy. «code LangId=6»Use master go drop proc sp_CrossTab go CREATE PROC sp_CrossTab @table AS sysname, -- Table to crosstab @onrow ....Read More
Rating
How can I run Apache and IIS on the same Windows NT server?
Total Hit (4258) I just installed ORACLE 9i on my Windows 2000 server (With IIS) and I noticed that Apache web server couldn't start so I was not able to run iSQL Plus. The reason was both IIS and Apache were trying to listen on port 80 and since IIS starts first it locks the port 80 so Apache couldn't listen on def ....Read More
Rating
This is a link to a different site Oracle's LogMiner - Part 1: Getting Started
Total Hit (2645) Oracle's LogMiner utility has been around for several years now, and it originally appeared as a new feature (as opposed to being an improvement of something else). Each major release of Oracle typically ushers in a new set of features, some of which are actually useful and can make your job as a DB ....Read More
Rating
Search/Replace text in text, ntext datatype column
Total Hit (2562) In SQL Server anything text longer than 8000 characters can be stored in TEXT or NTEXT datatype column but when you use TEXT or NTEXT datatype is not same as regular char, varchar, nchar or nvarchar datatype. You can not use string function like ltrim, rtrim, replace etc... Then how do you search an ....Read More
Rating
Very simple Encryption/Decryption code using VB
Total Hit (2440) This code will show you how to encrypt/decrypt a string. Copy/Paste the following code in your VB form and press F5 to run. «code LangId=1»Const ENCRYPTION_KEY = "MySecreteKey123" Private Sub Form_Load() Dim txt As String, enctxt As String txt = "Your password is : asd$223" ....Read More
Rating
RC4 Encryption/Decryption Algorithm as a UDF to encrypt/decrypt sensitive data in SQL Server
Total Hit (8377) This code is written by Brad Baker and Mike Arney «code LangId=6»SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GO if exists (select * from sysobjects where id = object_id(N'[dbo].[fn_string_helper]') and (OBJECTPROPERTY(id, N'IsTableFunction') + OBJECTPROPERTY(id, N'IsInlineF ....Read More
Rating
This is a link to a different site Learning SQL Server 2005
Total Hit (774) Everyone wants to get ahead of the curve with SQL Server 2005, but many people don't have the time or desire to dig through a Google search. Steve Jones has gotten quite a few requests for resources, so here is a compiled list of some places that might help you get started. ....Read More
Rating
This is a link to a different site Backup/Restore or Move DTS package(s) using DTSBackup 2000
Total Hit (1534) This small application allows you backup DTS Packages by saving them to COM-structured storage files. This can be done for both server based packages and those stored in the repository.
Rating
This is a link to a different site Writing Secure Transact-SQL
Total Hit (488) There are plenty of good sources of information about how to deploy SQL Server in a secure fashion. However, these resources are often targeted at database administrators tasked with securing already developed applications. In addition, there is a rich body of information that discusses writing secu ....Read More
Rating
This is a link to a different site PRB: "The specified Web server is not running ASP.NET version 1.1" error message when you create an ASP.NET 1.1 application and you have both ASP.NET 1.1 and ASP.NET 1.0 installed
Total Hit (608)
Rating
This is a link to a different site Including a CheckBox Control Inside an ASP.NET DataGrid...
Total Hit (609) CheckBox controls can be very useful inside a DataGrid. They make user choices easier in many cases and are not terribly difficult to implement.
Rating
How to enable SSL encryption for SQL Server 2000
Total Hit (2018) This step-by-step article demonstrates how to install a certificate on a computer that is running SQL Server 2000 by using Microsoft Management Console (MMC) and describes how to enable SSL Encryption at the server, or for specific clients. «a href='http://support.microsoft.com/?id=316898'»http:/ ....Read More
Rating
Case insensitive replace in .net
Total Hit (9814) Sounds easy right.... but sometimes it can take your entire day how to do that using String Replace method. By default .Net string operations are case sensetive. In order to do case insensitive you need to use Strings.Replace method this is another replace method provided for VB programmers. «co ....Read More
Rating
This is a link to a different site Free - Query Analyzer for SQL Server with several Kool features
Total Hit (1219) Query Analyzer Tool (QAT) functions similarly to the standard SQL Server Query Analyzer application. The main feature of QAT is that it allows you to view plans in a hierarchical tree and save them for future reference. It is often the case that when you are analyzing the execution plans of a co ....Read More
Rating
How to find tablesize and estimated rows for all tables
Total Hit (2370) Since there is no easy way using Enterprise Manager to know size and rows for all tables you need to write your own query. Run the following Query to see the result «code LangId=6»USE Northwind Go SELECT a.Name , SUM(b.RowCnt) EstRowCount , SUM(b.Used) * 8 TableSize_KB , (SU ....Read More
Rating
How to add/configure a new Linked server using T-SQL
Total Hit (7130) Here is the T-SQL script to add linked server using sp_addlinkedserver SP. Once you add linked server you can add login using sp_addlinkedsrvlogin. By default current login is mapped with linked server means remote machine must have exact same login with same password in order to get access to the l ....Read More
Rating
How to start SQL Server Agent automatically when SQL Server starts.
Total Hit (3043) When you install SQL Server by default SQL Server Agent Service is set to Start Manual mode and some times this can stop your scheduled jobs. Its also possible that you stop Agent and forget to turn it on. This article will show you how to create a SP which can start SQL Server Agent service if i ....Read More
Rating
This is a link to a different site Automatically Upgrade Your .NET Applications On-the-Fly
Total Hit (989) Rich client, (or in .NET terminology, "Windows Forms") applications provide a great user experience in terms of functionality, usability, operating system and inter-application integration. Unfortunately, they have also suffered from a relatively high total cost of ownership compared to browser-base ....Read More
Rating
This is a link to a different site Microsoft .NET Framework FAQ
Total Hit (565)
Rating
This is a link to a different site Installing Service during Setup using Custom Action
Total Hit (1825) This article will show you how to use Custom Action to install/uninstall service using custom action
Rating
This is a link to a different site Custom Actions - Part 1
Total Hit (1534) Custom Actions are deployment projects .NET programs written by your team that execute near the end of the installation process. You can use them to perform installation shores hard to implement with the existing features exposed by the setup project, in this order of ideas a custom action can insta ....Read More
Rating
This is a link to a different site Custom Actions - Part 2
Total Hit (1474) Custom Actions are deployment projects .NET programs written by your team that execute near the end of the installation process. You can use them to perform installation shores hard to implement with the existing features exposed by the setup project, in this order of ideas a custom action can insta ....Read More
Rating
eBooks
Total Hit (1381) «a href='ftp://ftp.netz.ru/Books/'»ftp://ftp.netz.ru/Books/«/a»
Rating


(Page 8 of 133) 3968 Result(s) found  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ...

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.