Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.
I need to create an application for monitoring SQL Server 2000 Agent Job status and info when Job occur same as …
c# sql-server-2000 sql-server-agentIs there a way to query the database and retrieve a list of all stored procedures and their parameters? I …
sql-server stored-procedures sql-server-20002 FEB is the 33rd day of the year, for example. Is there a built-in T-SQL function that returns the day-of-year (…
sql-server tsql sql-server-2000In order to perform a case-sensitive search/replace on a table in a SQL Server 2000/2005 database, you must use the …
sql sql-server-2005 sql-server-2000 collationI want to search a table for all rows that contain a non-alphanumeric and non-space character in a specific field. …
sql sql-server-2000 non-alphanumericHow do I generate scripts for all tables with a single stroke in SQL Server 2000?
sql-server sql-server-2000I'm trying to update a date dimension table from the accounting years table of our ERP System. If I run …
tsql initialization sql-server-2000 case-statementIs there a printf-like function in Sql Server? I want the same features as the RAISERROR function, but instead of …
sql-server sql-server-2000How will you find last sunday of a month in sql 2000?
sql sql-server tsql sql-server-2000I am looking for a quick-and-dirty way to import CSV files into SQL Server without having to create the table …
sql-server sql-server-2000 bulkinsert create-table openrowset