For more information about the site, see the
Certifications for Access and SQL Server
Query database from VB app or SQL Server?
A better way to search
Is SQL Server 2000 NUMA-aware?
Getting the error: D:MSSQL7Binnisqlw.exe is not valid
Problems inserting dates
Exporting a list of images in a document
Determining the physical space occupied by database tables
Backing up a single table, not the database?
Returning a value from a stored procedure to an ASP Web page
Using a string list as a parameter in a stored procedure
Moving objects to the correct filegroup
Resetting automumber fields to begin at 1
Lock problems and slow performance
Converting Access database to SQL Server
Getting information about stored procedures
Removing duplicate records
Limiting the ranges of columns returned
Query to find cities, including nearby locations
MOD() function in SQL 7.0
Differences between SQL server 7 and 2000
Validating online backups
Data from Fortran programs to SQL Server?
Date format in SQL Server
Creating a view to retrieve data from more than one database
Is there a way to shrink the transaction log?
Displaying all of one person's phone numbers in one column
Best method to copy a database with all of its properties without data
Errors running 16- and 32-bit programs
Any equivalent to Oracle's ROWNUM?
Is it possible to execute a stored procedure in Oracle from SQL Server 6.5?
Adding data into SQL Server 7 from Visual Basic
Suddenly can't view databases from Enterprise Manager
Incrementing record id without using identity
Best way to add login names and passwords to user info table
Error with SQL Server driver: Shared memory; connection open
@@identity problem on converted SQL code
Full text queries in SQL Server 6.5
Changing interface to point from MS Access to SQL Server
Generating a Word doc containing database info
System stored procedure to determine current database users
What does SELECT PLATFORM() do?
Calling a stored procedure from a stored procedure in COBOL
Access vs. SQL Server: performance and migration issues
Order of WHERE predicates and performance
Help with tools to create database diagram
Problem getting recordset in VB from a stored procedure
Triggering an update on one server from another
What is the difference between these two queries?
Data's physical location managed like in Oracle?
Importing/exporting to SAP
Restoring a database backed up on SP1 to SP3
Can DISTINCT be used on only one field in a query?
Updating a table with a text file
Time data being converted unintentionally
Not getting a result set when executing a stored procedure
Cost comparison of client servers and non-distributed systems
Downloading SQL Server 2000 Personal Edition
Scheduling jobs to run on alternate Saturdays
Tools for a seamless export from Oracle to SQL Server
SQL Server vs. Visual FoxPro
Executing distributed queries
Sorting vs. indexing
Problem with connection between IIS Web server and SQL Server
Preventing specific hosts from connecting to SQL Server
Using arrays in stored procedures
SQL Server 7.0's interpretation of dates
Table partition support
Copying the _WA_sys indexes/statistics
Restoring the database only using the mdf file
Preparing for the 70-029 exam
Replicating and backing up logs without overwriting previous ones
Deleting the SQL Server icon
Resources for upgrading from 6.5 to 7.0
Future for triggers
Identifying exact lock escalation and the criteria used to determine it
Returning values with more than two digits to the right of the decimal point
Database not completing restore process, remaining in loading mode
Retrieving data via an HTML document through IIS
BCP utility explained
Localserver dependent on Internet connection
Creating a view between servers
Query to show duplicate customers only once
Comparing Microsoft SQL Server to Oracle
SQL Server's limitations
Microsoft SQL Learning Edition?
Checking for NULL records in all columns in Access
Connecting Access and SQL Server 2000
Moving from Access to SQL Server
The now() function equivalent
Placing and retrieving comments on tables and columns
Creating standby servers
Creating installation program to create new database
Renaming instance after upgrade
What is SQL?
Per processor licensing
Installing Enterprise Manager and the SQL Server Utilities
Capturing recordsets generated by stored procedures