What's New
One months of additions are listed here.
Monday 7 June
Thursday 3 June
Wednesday 2 June
Tuesday 1 June
Monday 31 May
- How do I install NT Workstation
4.0?
- How do I install NT Server?
- I want to install DOS and Windows
NT, how should I do this?
- Installation hangs when detecting
the hardware.
- Is it possible to install NT without
using boot disks or temp files?
- Does NT have to be installed on the
C drive?
- There is a file
\Support\Deptools\<system>\ROLLBACK.EXE. What is it?
- I have NT installed, how do I
install DOS?
- How do I convert NT Workstation to
NT Server?
- I have bought a new disk, how do I
move NT to this new disk?
- Can I upgrade from Windows95 to NT
4.0?
- How do I remove NT from a FAT
partition?
- How do I remove NT from a NTFS
partition?
- How do I install the Iomega
Parallel Disk Drive?
- How do I install at tape drive on
NT Server?
- How do I install the NEC 4x4 CD
changer?
- What are symbol files, and do I
need them?
- How do I install NT and Linux?
- How do I install NT over the
network?
- Is it possible to use Disk
Duplication to Distribute Windows NT?
- How do I perform an unattended
installation?
- Is it possible to specify unique
items during an unattended install?
- How do I automatically install
applications as part of the unattended installation?
- Install detects the wrong video
card and locks the installation.
- How do I upgrade from NT 3.51 to
NT 4.0?
- When I use an unattended
installation, how do I avoid the Yes at the license agreement?
- I have NT installed, how do I
install Windows95?
- How do I remove Windows95/Dos from
my NT system?
- I can't create a NTFS partition
over 4GB during installation.
- I cannot upgrade my 4.0 NT
installation with the NT 4.0 upgrade CD.
- How do I create the NT
installation disks?
- How can I use a Network card that
is not one of those shown with Network Client Administrator?
- How can I make domain users
members of local Admin group during an unattended install?
- I have problems running a program
as part of the unattended installation?
- I have Windows NT installed, how
do I install Windows 98?
- I have Windows 98 installed, how
do I install NT?
- I have Windows NT 5.0 installed
but when I try to install Windows NT 4.0 the install fails.
- I want to install Windows 98 and
NT, what file system should I use?
- How do I manually install SCSI
drivers before the autodetect of installation?
- During installation of Windows NT
Server 5.0 the type of server cannot be set. -
Windows 2000 only
- How do I delete the recycle bin as
part of an unattended installation.
- During an unattended installation
I am prompted for an IP address if 0 is specified.
- How do I map a network drive
during an unattended installation?
- How can I install Windows 2000 on
a machine with less than 64MB of memory? - Windows
2000 only
- How do I disable the Installation
of Exchange during installation?
- My evaluation period has expired
on my NT installation, why?
- How do I install on a disk larger
than 8GB?
- How can I stop the installation of
My Briefcase during NT installation?
- How can I control which
accessories are installed during an unattended installation?
- How do I use SmartDrv?
- How can I upgrade a NFR NT
installation to full Retail?
- How can I stop IE 2.0 being
installed as part of installation?
- How can I remove the Linux LILO
Boot Manager?
- How can I recreate the Windows NT
installation disks?
- I have Windows 98 installed on C:
with FAT32, how do I install NT?
- How can I stop the 'Welcome to
Windows NT' screen during setup?
- I receive an error message "The System is not fully
installed", what can I do?
- How do I add a Network Install tab to Windows NT 4.0?
- How can I disable the 'Configure Server Wizard' in Windows 2000?
- How do I install the Remote Installation Service?
- How do I move the distribution point for Remote
Installation Services?
- How do I create a bootable Remote Installation
Service client disk?
- What operating systems can I clone?
- How do I install SQL Server 6.5?
- How do I register a SQL Server with SQL
Enterprise Manager?
- How can stop and start the SQL
services?
- How do I modify the sa password for
SQL?
- How do I visually edit/view data in a SQL
database?
- I am getting a message 'dbprocess dead or
not enabled' running my query.
- How can I add/amend/delete columns?
- I am getting a blue screen / completely hung
machine / server restart on my SQL Server/client.
- Where are the cascade update/delete
functions in SQL Server?
- How can I issue a SQL command that uses a
variable for the tablename, columns etc?
- Why does my transaction-log fill up when I
use fast-bcp?
- Why can't I backup/restore my SQL Server
database to the network?
- Can I do a SQL backup to a tape drive on
another server?
- I have a query that seems to lock other
users out of the system.
- Should I apply SQL SP4?
- How do I transfer data from another
DBMS/format to SQL Server?
- Why can't I get at a network file when I
run a program from xp_cmdshell?
- Is MS SQL Server Y2K compliant?
- How can I change the owner of an object in
SQL?
- I've just changed NT domain for my SQL
Server/clients and am unable to connect.
- Are there any "easter eggs" in
SQL Server?
- How do I encrypt fields in SQL Server?
- What tools are available to produce entity
relationship diagrams for SQL Server?
- Where is the SQL Server FAQ?
- Which SQL net-lib is the fastest?
- I'm having trouble installing SQL
Server.
- I am missing the whole of MSDB, or just
some tables - how do I create them?
- Why do my device sizes appear as negative
values in SQL EM?
- How do I do row-level locking on SQL
Server?
- How many bytes can I fit on a page in SQL
Server and why?
- I am getting a gpf/registry error
installing SQL Server - what is happening?
- How do I change the sort-order or
character set for a SQL Server database?
- What SQL servicepack am I running?
- My SQL Server database has been marked
"suspect" - what can I do?
- How do I remove the tempdb database from
master?
- What are the changes/differences between
vX and vY of SQL Server?
- How can I speed up SQL Server applications
running over slow links?
- How can I fix a corruption in a system
table?
- Why can't I connect Enterprise Manager to
my local copy of SQL Server?
- What is the limit on the number of tables
in a query in SQL Server?
- I'm doing a transfer using the SQL EM
transfer tool, and not only is it not transferring the objects.
- What registry entries does SQL Server
use?
- How can I view the SQL Server log?
- How can I upgrade the 120-day evaluation
version to the full SQL version?
- I'm not seeing anything in the current
activity screen in SQL EM.
- How can I output records/messages to a
flat file from inside a SQL Server TSQL script?
- My SQL Server database is showing as
"recovering".
- I am getting a SQL Server error message
"login failed".
- Can I run SQL Server on the same machine
as Oracle, Exchange etc.?
- Why do my SQL Server identity values get
out of synch causing gaps/duplicates etc.?
- How can I restrict access to my SQL Server
so that it only allows certain machines to connect?
- How can I restrict access to my SQL Server
so that it only allows certain programs to connect?
- How does SQL Server clear up orphaned
connections?
- Why does the SQL Server Database
Maintenance Wizard warn about databases greater than 400Mb?
- Why does my SQL Server log show that it's
still full? - I have truncated it.
- How do I connect to SQL Server from a
non-microsoft machine?
- How can I completely uninstall SQL
Server?
- What does dbcc traceon(208) mean in SQL
Server?
- How do I install SQL Mail?
- I've got a problem/query with the beta of
SQL Server 7.0. Where can I get help?
- Why do I have problems revoking
permissions on some tables with SQL Server?
- What hardware/software can I run SQL
Server on?
- Why is a SQL Server restore (LOAD
DATABASE) so much slower than a dump database?
- What are the *.DMP files that appear in
the SQL Server log directory?
- Can I do an NT defrag on a SQL Server .DAT
device/file?
- Can I compress a SQL Server .DAT
device/file?
- Why can't I install SP4 for SQL Server to
my Win95 machine like the readme says I can?
- I'm getting an error 1117 in SQL Server.
Can I rebuild the extents somehow?
- Why can't I get at a network file when I
run a program with xp_cmdshell from SQL Server?
- I am having problems with SQL Server
running bcp from xp_cmdshell.
- How do I store/retrieve text and image
data in SQL Server?
- How can I amend the system tables in SQL
Server?
- I am having problems installing a SQL
Service pack.
- How can I move a SQL Server device from
one disk to another, or rename it?
- How can I recover a SQL Server database
when all I have left is the .DAT device?
- How can I re-install SQL Server without
losing any data under a new version of NT I have installed?
- How can I install SQL Server client tools
in unattended mode?
- How can I access data across two separate
databases in SQL Server?
- How can I transfer SQL Server data between
an Intel box and an Alpha?
- I can't run SQL Server Enterprise
Manager.
- I've put tempdb in ram and now I can't
restart my SQL Server.
- How do I transfer data between SQL Server
databases / across servers?
- What packages are available to do source
control on SQL Server SP's, DDL etc.?
- Where can I get the ANSI92 SQL information
from.
- How do I connect to SQL Server through a
firewall?
- I'm getting a sort failed 1501 message on
SQL Server - what's going on?
- I'm getting a 1112 error on SQL Server -
what's going on?
- Why do I get the message WARNING: Process
being freed while holding Dataserver semaphore in SQL Server.
- What are good SQL Server books? And other
sources of reference.
- Where can I get SQL Server hot-fixes
from?
- How can I create a user-defined function
in SQL Server?
- How can I pass an array of values to a SQL
Server stored-procedure?
- How can I delete duplicate rows from a SQL
Server table?
- My SQL Server errorlog is filling up with
entries. How can I switch or truncate it?
- Which sort-order should I choose for my
SQL Server for the fastest performance?
- Why is my application locking up in SQL
Server?
- Where can I get the SQL Server Programmers
Toolkit?
- I'm getting an error 80004005 message
connecting to SQL Server - what's going on?
- Is it safe to clear down the
msdb..sysbackuphistory table in SQL Server?
- I'm having problems getting more than x
connections from a 16-bit client to SQL Server
- How can I restrict the number of rows
returned to my query in SQL Server?
- I can't use a tape-drive with SQL
Server, but it works ok with NT Backup. Why?
- SQL Mail keeps hanging - meaning I have
to restart SQL Server to clear it.
- How can I convert a string to
"proper" case in SQL Server?
- Where can I get Embedded SQL for SQL
Server?
- Does SQL Server support Unicode?
- Where can I download SQL Server
utilities, service packs etc.?
- How can I disble the dial-up remote
network prompt with the SQL Server GUI tools?
- Error message : Failed to obtain
TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE.
- Should I amend the SQL Server
"Backup Buffer Size"?
- What is SQLHDTST.EXE for SQL Server and
where do I get it?
- How can I install the 32-bit SQL Server
client for NT or Windows 9x?
- I am getting a message
GetOverLappedResult() from a SQL Server query.
- What does the SQL Server error message
Lazywriter: WARNING, couldn't find slot, 8/8, scanned 8 mean?
- I have a corrupt SQL Server table that I
can't drop. What can I do?
- Why can't I BCP a Unix file into SQL
Server? I get UNEXPECTED EOF messages.
- What can't I do with SQL Enterprise
Manager under Win9x?
- I am getting a message "Protocol
error in TDS Datastream" from a SQL Server query.
- Why is SQL Server slower than
Access/FoxPro/DBase etc.
- Can I turn SQL Server logging off?
- What tools are available to debug
stored-procedures under SQL Server?
- Why do I get an error "Error: 702,
Severity: 20, State: 1" running a SQL Server query?
- What do the bufwait and writelog errors
in SQL Server mean?
- Who are Microsoft Product Support
Services?
- What is a "SQL Server MVP" and
how do I become one?
- I'm getting an access denied or
CreateFile message when connecting to SQL Server.
- How can I automate the scripting of a
database/objects in SQL Server?
- Why is the date I get via select
getdate() wrong in SQL Server?
- Where is the pointer to master stored in
SQL Server? How can I move the master database?
- Why do I see page faults/sec above 0
when I have a dedicated SQL Server machine?
- How do I configure a connection to use
tcp-ip sockets with SQL Server?
- How can I do a crosstab function using
standard TSQL in SQL Server?
- How can I run an external (non-SQL)
program/dll etc. from within a TSQL SQL Server script?
- What specification hardware do I need to
run SQL Server for good performance?
- How can I stop a SQL Server process?
- I get an ODBC error.
- I've forgotten the sa password for SQL
Server - what can I do?
- Why does my SQL Server code sometimes
respond slower than normal when I haven't changed anything?
- Should I apply SP5? Will it cause more
problems than it fixes?
- Do I really need 166Mhz Pentium
processors to run SQL Server 7.0?
- Does SQL Server run under
Win2000/NT5?
- How do I change the name of SQL
Server?
- Why has my tempdb in SQL Server filled
up?
- Mail messages are stuck in my outbox
with SQL Mail.
- I am getting an error "Msg 2503,
Level 16, State 1 Table Corrupt" on my SQL Server - what can I do?
- I am getting an error 2521 on my SQL
Server - what can I do?
- I am getting an error 605 on SQL Server
- what can I do?
- I get an error #610 - Maximum number of
databases that may be accessed by a transaction is x.
- I'm getting a "bad token"
error message from SQL Server - what causes this?
- Why do I get slow or no connections to
SQL Server using IPX from my Win3x and Win9x clients?
- I'm getting the following error with SQL
7 regarding DTS inability to transform data.
- With SQL Server should I get more
processors or faster processors?
- How can I get ISQL.EXE to return a DOS
errorlevel for me to test?
- Does SQL Server have any built-in
functions to work with julian dates?
- Why can I connect to SQL Server with the
tcp-ip sockets netlib and not named-pipes
- Should I apply NT 4.0 SP4 to my SQL
Server system?
- Are there any resources or tools to aid
in an Oracle PL/SQL to SQL Server TSQL conversion.
- What is a reproduction (repro) script
that I need to produce for a SQL Server bug?
- Do SQL Service Packs have to be applied
in order or can I just apply the latest one?
- Is there an Access upsizing wizard to
SQL Server 7.0?
- Why can't I see master, msdb etc. in SQL
7 EM? Also I can't see the system tables in user databases.
- What versions of SQL 7 are there and
what are the differences?
- When SQL Executive starts I get the
error id 109.
- What tools are available to
stress/benchmark SQL Server?
- Why can't I stop/start SQL from SQL
Enterprise Manager?
- Should I use tempdb in ram?
- Does SQL 7 support tempdb in ram?
- I am getting an error 4409 selecting on
a view ever since I applied SP5 to SQL 6.5.
- I am getting an error 603 on database
recovery in a SQL 6.0 system.
- Why do I get an error "SQL Server
Assertion : File:<xxx.c> Line=yyy Failed Assertion='zzz'?
- How can I overwrite expired backups on a
disk device to save on space and still keep a rolling x days there?
- Should I set "boost priority"
to 1 or "SMP" to -1 on SQL Server?
- What are all the dbcc commands for SQL
Server?
- How can I see how many objects are
actually open in SQL Server?
- How can I get the hardware spec of a SQL
Server remotely?
- How can I tell what columns in my SQL
Server database are identity columns?
- I get an errot trying to load a trace
file into the SQL 7 Profiler/Index Tuning Wizard.
- How do I install the SQL Server Internet
Connector Software?
- Can I use a Worm/MO/CD-Rom jukebox with
SQL Server?
- When I run the MDAC setup routine that
comes with SQL Server SP5(a) why does it re-invoke the SP setup?
- How can I replace/change/delete
characters in a SQL Server column?
- Does SQL Server support row numbers like
Oracle does?
- When I do a SQL Server trace I see
sp_cursoropen and sp_cursorfetch commands being sent
- Does SQL 7 support db-lib?
- Why do I get a 6.5 group in my SQL 7.0
MMC list of servers?
- Can I run SQL 6.5 and SQL 7.0 on the
same machine?
- How can I check whether SQL 6.5 or SQl
7.0 is installed without connecting to SQL and logging on?
- I'm running a stored-proc from VB. Why
does it return control before the SP has finished?
- Can I install SQL on a Terminal Server
machine?
- How can I report a SQL Server bug to
Microsoft?
- Why do I get the SQL Server error
"Msg 8412 - Schemas differ" when doing a LOAD TABLE?
- Why do I get an error message when I try
to run SQL 7 EM - "MMC - Snap-in failed to initialize"?
- Why is the week number returned by SQL
Server wrong?
- How can I un-install a SQL Server
servicepack and go back to the original version?
- How can I transfer database diagrams
from one SQL 7 server to another?
- Why is SQL Server 7 slower than 6.5 at
running some of my sp's?
- How can I modify the SQL 7 unattended
install script?
- Is there an Access upsizing wizard to
SQL Server 7.0?
- Do I really need a 166Mhz Pentium
processor to run SQL Server 7.0?
- Why do I get an error 'Bad pointer
0xABCDEF encountered while remapping stored procedure' in SQL Server?
- Why does sp_processmail fail with
'Supplied datatype for set_user is not allowed, expecting 'varchar''?
- How can I pad an integer value in SQL
Server with zeroes?
- Where can I get a JDBC driver for SQL
Server?
- Why is SQL Server better/worse than
Oracle?
- A query produces this error in SQL 7
'Internal Query Processor Error'.
- Any known issues with IE5 and SQL Server
7.0?
- How can I programmatically get the next
free device number (vdevno) in SQL 6.5 and below?
- How can I get random numbers from SQL
Server? Using rand() I always get the same sequence.
- What is the precedence of the SET
commands, database options, session options etc. in SQL Server?
- Why am I seeing entries in sysindexes
(or sp_helpindex) for indexes I have not created?
- I'm getting #deleted entries in resultsets from ODBC since installing SQL 7,
why?
- How can I use SQL 7's HDQ facilities to get at NT domain or Exchange information?
- How can I tell if my code is ANSI-92 compliant?
- How can I automate the scripting/transfer of a database/objects in SQL Server?
- If I lose my data file (MDF) in SQL 7 I can't backup the log to recover to a point in time - why not?
- What does the SQL Server error message "sort: bob write not complete after xx seconds." mean?
- How can I run a DTS package from within SQL Server - e.g. a stored-procedure?
- Where can I get Embedded SQL for SQL Server?
- How can I get file information using SQL Server?
- My SQL Server database has been marked "loading" - what can I do?
- How can I connect to SQL Server from a Macintosh?
- I am getting problems with ODBC apps since upgrading to SQL 6.5 SP5a or installing SQL 7.
- How do I configure multi-protocol net-lib to force encryption of packets in SQL Server?
- How can I ORDER BY different fields based on a variable in SQL Server?
- Can I upgrade SQL 4.x to 7.0 directly?
- How can I programmatically kick off a SQL dump and get the stats on how far through it is back dynamically?
- Where does the list of SQL Server's come from in registration/dialog boxes?
- Can I add comments to SQL Server's schema like I can with Access?
- How can I pass an array of values to a SQL Server
stored-procedure?
- How does SQL Server clear up orphaned connections?
- How do I configure the debugger in Visual Studio to work with SQL 7?
- How can I connect from Delphi to SQL 7?
- Why does my copy of SQL Server say it is the 120 day eval edition when it is the full commercial copy?
- Why do I get a "variable is not declared" inside my EXEC statement?
- What is the equivalent of the IIF command in SQL Server?
- What does the red zig-zag line next to a server name in SQL Enterprise Manager mean?
- Why do I get the error 'An unknown full-text failure
(80004005)'?
- Why does the tcp-ip net-lib not appear as an option in SQL Setup?
- How much longer will MS support SQL 6.5 for?
- How can I tell whether a table is a system (Microsoft) table in SQL 7?
- Where can I get SQL 7.0 SP1?
- Why do I get "SQL Server has run out of locks" error message with SQL 7 - I thought it dynamically allocated them?
- How do I configure the client query time-out for SQL Server?