Top "Sql-server-2000" questions

Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.

Install Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A on Windows 10 (x64)

I need to install MSDE 2000 Release A on Windows 10. The installation window pops up and then immediately closes without an …

sql-server-2000 windows-10 msde
What Causes "Internal connection fatal errors"

I've got a number of ASP.Net websites (.Net v3.5) running on a server with a SQL 2000 database backend. For …

asp.net sql-server iis-6 sql-server-2000 asp.net-3.5
SQL Server: How to make server check all its check constraints?

It seems that some scripts generated by Enterprise Manager* (or not, it doesn't matter) created check constraints WITH NOCHECK. Now …

sql-server sql-server-2000 check-constraints database-integrity sp-msforeachtable
How do you deal with transport-level errors in SqlConnection?

Every now and then in a high volume .NET application, you might see this exception when you try to execute …

c# sql-server tsql ado.net sql-server-2000
How do I disable errors on string truncation in SQL Server?

How can I tell SQL Server not to raise an error if I insert or update a string longer than …

sql-server-2000
Regular Expressions in SQL Server servers?

Is it possible to make efficient queries that use the complete regular expression feature set. If not Microsoft really should …

sql-server regex sql-server-2005 sql-server-2008 sql-server-2000
Subqueries are not allowed in this context. Only scalar expressions are allowed

My customer is running MS SQL Server 2000. I completed a project, but I failed to realize that MS SQL Server 2000 …

sql sql-server-2000 coldfusion-10
SQL Server: ORDER BY in subquery with UNION

i have two queries being combined with a UNION ALL1: --Query 1 SELECT Flavor, Color FROM Friends   --Query 2 SELECT Flavor, (SELECT …

sql-server sql-server-2000 sql-order-by union union-all
How do I set the default database in Sql Server from code?

I can't seem to figure out how to set the default database in Sql Server from code. This can be …

sql-server database sql-server-2000
how to search Sql Server 2008 R2 stored procedures for a string?

I'm migrating a legacy SQLS2k to 2008R2, and it seems all data access was done through stored procs, and …

sql-server sql-server-2008 join sql-server-2000 outer-join