For more information about the site, see the Site Index

• 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
• Licensing question
• 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
• Rounding numbers
• 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



• More