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.

2591 questions
0
votes
1 answer

page refresh only when new records are inserted in database

What i want to do is whenever, a row is inserted into the database table by another service, the page that is accessing the database should refresh automatically, instead of using timer calls to check, is there a way to do it. i wanted to in 2…
Ali Hasan
  • 1,015
  • 4
  • 16
  • 42
0
votes
1 answer

How to make a select Query with And

I want to make a select query with an and condition. dept, divi, comp as string Deparment = dept Division = divi company = comp Tried this query: Select * from table where department = '" & dept & "' and division = '" & divi & "' and Company…
Gopal
  • 10,888
  • 47
  • 141
  • 225
0
votes
2 answers

How to delete the Duplicate rows

Table1 ID Date 001 23/02/2009 001 24/02/2009 001 24/02/2009 002 25/02/2009 002 25/02/2009 ... I want to delete the duplicate rows from the above table. Expected Output ID Date 001 23/02/2009 001 24/02/2009 002 25/02/2009 ... Need Query Help
Gopal
  • 10,888
  • 47
  • 141
  • 225
0
votes
2 answers

Make a normal query from a stored procedure

Using VB6 and SQL Server 2000 I want to convert a stored procedure to normal query Stored procedure: Alter PROC [dbo].[proc_New] @CCODE VARCHAR(100), @EmpCode VARCHAR(100) AS BEGIN DECLARE @ID VARCHAR (5) DECLARE @Des…
Gopal
  • 10,888
  • 47
  • 141
  • 225
0
votes
3 answers

Sql collation issues when deploying live

History: I had a deployment the other night which involved executing a script that creates a stored procedure. However when running the script, an error occurred about the collation of the DB. The Problem: With the help of our friend Google, I…
Steven
0
votes
1 answer

SQL Server 2000 Enterprise Manager: Unable to view columns in tables added to View designer

I have a SQL Server 2000 database that will not display the column list for any tables in the View "designer" in Enterprise Manager This problem exists when either designing a new view or when editing existing views. All that is displayed for each…
Craig L
  • 117
  • 1
  • 1
  • 6
0
votes
1 answer

MySql syntax in SQL Server to set display length of datatype

We got some SQL scripts, some of them are using Syntax like : Create procedure procABC(...) as begin ... ... 'ColA'= CONVERT(smalldatetime(10),ColB,103), ... ... End Same kind of syntax we also have for INTEGER…
AjayK
  • 363
  • 3
  • 16
0
votes
1 answer

Restoring SQL Server 2000 database on a 2008 R2 is creating a new logical file

I have a database on SQL Server 2000. There are only two logical files in the PRIMARY file group: the data file and the log file. However, when restoring the database to SQL Server 2008 R2, there is now a new logical file named ftrow_Table1Field1…
HardCode
  • 6,049
  • 4
  • 28
  • 53
0
votes
1 answer

can i use full text search on the view of a table

i am using sql server 2000 can i use full text search on the view of a table..
saurabh
  • 259
  • 1
  • 6
  • 18
0
votes
1 answer

refine the result in full text search

i am using the freetexttable in my search but i am not getting the exact results how can i get the exact results....
saurabh
  • 259
  • 1
  • 6
  • 18
0
votes
1 answer

How to delete the last record

Using SQL Server 2000 Table ID Date Value 001 23-02-2009 300 001 24-02-2009 400 001 25-02-2009 150 002 23-02-2009 300 002 24-02-2009 400 003 23-02-2009 150 ..... ..... From the above table i want to delete the last date for each id. How to make a…
Gopal
  • 10,888
  • 47
  • 141
  • 225
0
votes
2 answers

Getting all table keys with types

I've managed to cobble together this query from various examples to get all table keys: select tbl.name,idx.name as indexname,t1.*,col.name as colname from dbo.sysindexkeys as t1 LEFT JOIN dbo.sysindexes as idx on (t1.id=idx.id and…
Brad Mace
  • 26,280
  • 15
  • 94
  • 141
0
votes
2 answers

How do write the following sql fragment for SQL Server 2000

Can Someone please help to how to write the below code in SQL Server2000? Thanks WITH cte AS (SELECT *, ( Row_number() OVER(ORDER BY productid, transactionid, statusdate DESC) …
K.S
  • 13
  • 4
0
votes
2 answers

No transaction active Error message in a distributed transaction while MSDTC is enabled

I have a linked server from server1 to server2. server1 operating system: windows server2003 sp2 SQL server: SQL server 2008 R2 server2: operating system: windows server2003 R2 SQL server: SQL server 2k Sp3 MSDTC is enabled on both pcs, but when I…
Raymond Morphy
  • 2,316
  • 8
  • 49
  • 86
0
votes
2 answers

why does a sql server query take too long in stress test

Sql server query takes 1 second when run in query analyzer with single user. I started stress tool written by Adam Machanic with same query and run that for 200 users and in parrallel I ran the same query in query analyzer it takes more than when 20…
Ron
  • 227
  • 1
  • 4
  • 11
1 2 3
…
99
100