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
0
votes
1 answer

Playframework-1.2.4 Entity and SQL Server 2000, return 462 records instead of 8800 :S

I have a problem with SQL Server 2000, I has been using jtds-1.2.5, I have 2 connections, Mysql is the principal, but I need access to MSSQL Info. The problem is when I make a "List alumnos = Salumnos.findAll();", this return 462 records instead of…
ivmx
  • 1
  • 1
0
votes
3 answers

How to display one rows from the two rows

I have type column in my table, type column value is HOT andNOT. from that i want to display HOT and NOT values of the column in to one line. Example Table1 Period ID Total 11/2011 101 250 12/2011 102 350 11/2011 103 450 .... Table2 Period ID…
Gopal
  • 11,712
  • 52
  • 154
  • 229
0
votes
1 answer

How to find sql2000 databases info using Sqlserver SMO

How to Find sqlserver2000 databases info using SQLSERVER-SMO
Cute
  • 13,643
  • 36
  • 96
  • 112
0
votes
2 answers

Is it possible to log the text of each query executed on SQL Server?

We have this recurring situation where several times a week our application stops responding. What I would like to do is be able to view the text of the query running on SQL Server. I can use sp_who to see the open connections, but, it does not…
OpenCoderX
  • 6,180
  • 7
  • 34
  • 61
0
votes
1 answer

Database connection failed: unable to create ado connection: [DBNETLIB][ConnectionOpen](Connect)

we are getting an error while logging in to our legacy system. Couldnt think about what the problem is. The people who developed the system seems unreachable. Its not happing every time and its intermittently.
Joshua
  • 2,275
  • 7
  • 41
  • 57
0
votes
1 answer

Problems when migrating from SQL Server 2000 to SQL Server 2008

I have a primary key and identity issues when migrating databases and tables from SQL Server 2000 to SQL Server 2008. In SQL Server 2000, some tables have primary key ID and I set Identity yes. When I export to SQL Server 2008 a few tables already…
Irfani Firdausy
  • 41
  • 4
0
votes
1 answer

Syncing SQL server 2000 with 2005 -- will DTS still work?

we have a local staging server running sql server 2000 and a remote public version also running sql server 2000. The remote version will be upgraded to 2005 and I am wondering if the DTS packages we have in place will continue to function between…
aaandre
  • 2,502
  • 5
  • 33
  • 46
0
votes
2 answers

Zero should not save in the table

FlexGrid While saving the flexgrid empty cell values, it is saving as 0 in table For Example Flexgrid ID Value1 Value2 001 1 002 .... Saving... Query With flexgrid insert into table1 values (NULLIF('" & .TextMatrix(i, 0) & "', '0'), NULLIF('"…
Gopal
  • 11,712
  • 52
  • 154
  • 229
0
votes
1 answer

Alternative option for case condtion in sql

How to check the column value zero or not I want to insert 50 column values, each column i want to check whethere the value is 0 or not. If the value is 0 then it should be null Query insert into table1 values (Case when column1 = '0' then null else…
Gopal
  • 11,712
  • 52
  • 154
  • 229
0
votes
3 answers

how can i delete a record in sql using more than 1 table

I'm having a problem in sql, can anyone help me I have 3 tables sublocation, postingdetail and employee I have to delete sublocid from sublocation table but first i have to check that is there any employee working on that sublocation from…
zain kamali
  • 11
  • 4
0
votes
1 answer

Linq-to-SQL using stored proc in SQL Server 2000 missing mapping

I using SQL Server 2000 and running SQLMetal to generate my Mappings.xml and my DataContext code This all works fine for CRUD to a table. Now I need to use stored procedures to perform my CRUD to the table with the same structure. I know how to do…
Coppermill
  • 6,676
  • 14
  • 67
  • 92
0
votes
1 answer

How to insert a record with date validation

Table1 ID Month datefrom dateto reason 001 12/2011 01/12/2011 10/12/2011 Leave 001 12/2011 18/12/2011 25/12/2011 Holiday ..... datefrom, dateto datatype is datetime, datefrom & dateto format is (dd/mm/yyyy) Before inserting…
Gopal
  • 11,712
  • 52
  • 154
  • 229
0
votes
1 answer

How to reset the identity field after some numbers

How to reset the identity field Query DBCC CHECKIDENT('table1', RESEED, 0) The above query is reseting all identity field, but i want to reset from 5001 onwards. Table1 id value 1 100 .. .. 5000 430 6501 232 6501 343 ... From 5001 to 6500…
Gopal
  • 11,712
  • 52
  • 154
  • 229
0
votes
2 answers

User Login time restriction

I have shifts in my application. I want to restrict the time that a user can log in to their defined log in time span. Shift 1 which is AM to PM is working fine, but PM to AM check is creating problems. This is because the second shift starts at…
nbhatti2001
  • 353
  • 2
  • 7
  • 33
0
votes
4 answers

Can SQL Sub-query return two/more values but still compare against one of them?

I have this query: SELECT Items.Name, tblBooks.AuthorLastName, tblBooks.AuthorFirstName FROM Items WHERE Items.ProductCode IN ( SELECT TOP 10 Recommended.ProductCode FROM Recommended INNER JOIN Stock ON Recomended.ProductCode =…
RoguePlanetoid
  • 4,516
  • 7
  • 47
  • 64
1 2 3
…
99 100