|
|
|
|
|
using NT Authentication to login into SQL
|
Total Hit (1169) |
This is for using NT authentication (NT users already setup in the Domain)
So you need to get the correct spelling of each user in User Manager for Domains.
Then it will get the user from NT when they log in and bingo they have permissions to the SQL server database too.
....Read More |
Rating
|
|
|
|
|
|
Sysprocesses table definition
|
Total Hit (792) |
The sysprocesses table holds information about processes running on Microsoft® SQL Server™. These processes can be client processes or system processes. sysprocesses is stored only in the master database.
|
Rating
|
|
|
JOIN Fundamentals
|
Total Hit (735) |
Very often we need to pull data from 2 or more sources (tables or views) and combined them into 1 logical unit.
There is often a bit of confusion on when and how to use them.
I will first describe each JOIN type and how it works with the 2 tables involved. The major JOIN types are color cod
....Read More |
Rating
|
|
|
|
|
Tutorial : Using DLLs and The Windows API
|
Total Hit (2378) |
Windows provides a number of function calls, in the form of DLLs, that are useful to VB programmers. You can also co-opt DLLs from other programs to do work for you. We'll concentrate on using the Windows DLLs here, but what we learn is widely applicable
....Read More |
Rating
|
|
|
Creating and using your own VC++ dlls
|
Total Hit (1007) |
Using the Windows API is a wonderful way to speed up your applications when they need to perform processor intensive tasks like graphics manipulation. However, the Windows API doesn’t always provide all the functionality you need for your application. Perhaps some 3rd party control does what you wan
....Read More |
Rating
|
|
|
Tutorial : Drawing & Animation
|
Total Hit (1565) |
These tutorials are were originally developed as part of a VB Game Programming for beginners book Soren and I were working on. For a variety of reasons the book idea never came to fruition and so we decided to post the material that is finished as a series of tutorials in the hopes that you would fi
....Read More |
Rating
|
|
|
Tutorial : Sound & Games
|
Total Hit (1746) |
These tutorials are were originally developed as part of a VB Game Programming for beginners book Soren and I were working on. For a variety of reasons the book idea never came to fruition and so we decided to post the material that is finished as a series of tutorials in the hopes that you would fi
....Read More |
Rating
|
|
|
Using the Joystick, Mouse and Keyboard
|
Total Hit (2214) |
So far we have learned how to move, animate and do some other stuff to sprites. We have also looked into the area of sound playback in games. This is all very nice if you want to create a game with no human interaction. Since this is most likely not the kind of game you want to make, then you need t
....Read More |
Rating
|
|
|
Get Disk Information for any Machine In the selected Domain
|
Total Hit (1190) |
This is a project that enumerates drive details on remote NT systems, but is not limited by GetDriveSpace's 2.0 GB limit. It uses GetDriveSpaceEx and the Currency Data Type (multiplied by 10000) to accurately return large drive sizes. It enumerates all NT workstations and servers and propagates a se
....Read More |
Rating
|
|
|
Enumrate Local or Remote Disks
|
Total Hit (1772) |
VB example of using the NetServerDiskEnum API call from within VB. It returns a list of disk drives on a machine (local or remote).
Author: Michael S. Jones
|
Rating
|
|
|
|
GetLastErr
|
Total Hit (1047) |
This code snippet returns any error codes from net related functions and system related functions.
Author: Elvio Serrao
|
Rating
|
|
|
|
|
|
|
|
|
A better Soundex code
|
Total Hit (1118) |
Terms that are often misspelled can be a problem for database designers. Names, for example, are variable length, can have strange spellings, and they are not unique. American names have a diversity of ethnic origins, which give us names pronounced the same way but spelled differently and vice versa
....Read More |
Rating
|
|
|
|
How do I set up and configure SQL Mail?
|
Total Hit (1261) |
SQL Mail provides a way to send EMail from Micosoft SQL Server. The focus of this FAQ is configuration of SQL Mail. There are other ways to send Email from SQL Server. Links to articles about these alternatives to SQLMail are listed at the end of this FAQ.
....Read More |
Rating
|
|