Stack Overflow
Stack Overflow

Questions tagged [sql-server-2000]

Use this tag for questions specific to the 2000 version of Microsoft's SQL Server. Note that as of April 9, 2013, Microsoft no longer supports this version of SQL Server, to the point that even security patches are no longer created.

SQL Server 2000 (codename Shiloh, version 8.0), released in September 2000, is the successor to SQL Server 7.0.

2588 questions
1
vote
1 answer

CREATE FUNCTION SQL Server 2000

I'm creating a SQL Server function in SQL Server 2000. My syntax is about like this: ALTER FUNCTION dbo.test() RETURNS TABLE AS RETURN ( DECLARE @A VARCHAR(100) DECLARE @B VARCHAR(100) SELECT @A='abc', @B='bca' SELECT A=@A, B=@B ) I'm…
Willy Lazuardi
  • 1,806
  • 4
  • 26
  • 41
1
vote
2 answers

SQL-DMO: You must use SQL Server 2005 management tools to connect to this server

Getting an error in SQL Server 2000 Enterprise manager - Please see in the attached screenshot! Kindly help how to overcome the issue
venkat
  • 5,648
  • 16
  • 58
  • 83
1
vote
1 answer

How to check if a SQL script is compatible with sql server 2000

I wrote a lot of scripts for SQL Server 2005, but now I have to rewrite those original scripts to make them work on SQL Server 2000. I don't remember all the differences between 2005 and 2000. For instance, CTE was announced only in 2005 - and I…
Vadim Loboda
  • 2,431
  • 27
  • 44
1
vote
3 answers

How to get a total of recent date

Using SQL Server 2000 I want to get the max(date) of total for each id. ID Date Total 01 02/01/2012 500 01 01/02/2012 1000 01 02/03/2012 350 02 17/01/2012 250 02 15/02/2012 150 03 01/12/2011 225 ... ... I want to get max(date) of total for each…
JetJack
  • 978
  • 8
  • 26
  • 51
1
vote
3 answers

Label.Text change being blocked?

I am attempting to use a Microsoft.SqlServer.Management.Smo.Restore object to restore a SQL Server 2000 database. Just before I begin the restore operation, I change the text of a label so that the user knows what is going on. However, the changed…
Donut
  • 110,061
  • 20
  • 134
  • 146
1
vote
3 answers

Copy table data from SQL Server 2000 to SQL Server 2008

I have a SQL Server 2000 database with 7 tables. I want to copy the table data from this database to another database running on a SQL Server 2008 instance. The tables will be exactly the same, I just need to copy the data from one to…
SOLDIER-OF-FORTUNE
  • 1,634
  • 5
  • 39
  • 66
1
vote
1 answer

Send dbMail from SQL Server 2000 with Tabular structured data?

I am trying to achieve this kind of formatted data from my select statement and have it send via database mail in SQL SERVER 2000. I know how to do this in SQL 2008. Column1 | Column 2 ------------------ Value 1 | Value 2 Value 1 | Value 2 Value 1 |…
Zeus
  • 3,091
  • 6
  • 47
  • 60
0
votes
0 answers

Difference between partition metadata and COUNT(*) in a partitioned table

Partitioned the table based on the column to improve the performance, For a particular partition the rows count is 1 in sys.partition table. However the actual table holds the data please look in to the screen shoot. SELECT …
VIJAY
  • 849
  • 11
  • 22
0
votes
1 answer

If exists then update else insert not working properly in SQL Server Enterprise Edition

I know it might be a duplicate question but it is really making me frustrated now. I have to insert/update shipper information and I wrote a stored procedure like this: IF EXISTS (SELECT * FROM sysobjects WHERE…
vpv
  • 920
  • 2
  • 20
  • 46
0
votes
1 answer

view when table or view last altered, sql server 2000

Is there a an easy way to see(timestamp) when a database was last altered within a sql 2000 instance? Apparently the solution is not as simple as 2005 where i can query the "sys.tables."
MG.
  • 883
  • 9
  • 19
  • 39
0
votes
1 answer

Determining with C# Whether a SQL Backup File is Password Protected

How would I go about using C# to programmatically determine whether a SQL Server 2000 backup file has been password protected?
Donut
  • 110,061
  • 20
  • 134
  • 146
0
votes
1 answer

Error while running DTS package: SQL Server 2000

could any one help me to resolve this issue. I'm executing a DTS package on my system from SQL Server Enterprise Manager by connecting to the Database Server (Remote server). The execution completes with the error message…
Murty
  • 79
  • 2
  • 9
0
votes
1 answer

Reading through a table row by row in SQL Server 2000

I have a table that I want to read row by row to search for a specific match. Here are the result of my table and the columns. Pos_Scan represents what is scanned at the point of sale and how many UniqueID INGREDINETID KITCHENITEMID …
user1285279
  • 1
  • 1
0
votes
2 answers

Error converting data type varchar to numeric

I am getting an error in the following query: insert into ProductStone ( Pieces, Weight, CutChg, LotID, CatID, OrnID, StoneID, ShadeID, CutID, ChgType, SetID) values ( '10', '0.3', 'null', '601', 'H', '101', …
Syed Muhammad Mubashir
  • 966
  • 6
  • 23
  • 51
0
votes
3 answers

SQL function CONTAINS() does not return expected results?

I have a table 'Asset' with a column 'AssetDescription'. Every row of it has some group of words/sentences, seprated by comma. row1: - flowers, full color, female, Trend row2:- baby smelling flowers, heart Now if I put a search query like:- select…
Kings
  • 1,551
  • 12
  • 32
  • 52
1 2 3
…
99 100