This tag is specifically for the 2000 version of Microsoft SQL Server

learn more… | top users | synonyms

0
votes
2answers
251 views

SQL Server 2012 linked server to SQL Server 2000

I am trying to select through an linked server from SQL Server 2012 to SQL Server 2000. The linked server has been setup and I can browser the target database through the linked server which ...
2
votes
1answer
397 views

DBCC loginfo contains thousands of VLF entries with status 2

I've inherited this huge SQL Server 2000 prod database and suddenly the transaction log ran out of space. The transaction log gets backed up every hour but I think over the weekend some existing jobs ...
3
votes
0answers
197 views

How unsafe is it to change the data source of repl_distributor on a publisher

I have a long story that I will condense to a few bullet points that leads up to my question Reporting Server (SQL 2008) is distributor/subscriber cluster for a SQL 2000 Transactional Publication ...
2
votes
0answers
44 views

Can I open a table twice using different recordsets and update the second without affecting the first?

Context: Windows 7, SQL Server 2000, JScript. I have a recordset opened as follows: var cmd = "SELECT * FROM Table1 WHERE Field1 = 9 AND Field2 = 0;"; var oRS = new ActiveXObject("ADODB.Recordset"); ...
2
votes
0answers
284 views

Tables not shown in SQL Server Enterprise Manager

For some reason 3 tables which are clearly in use by the application are not listed in the Tables view in SQL Server Enterprise Manager. It's SQL Server 2000. When generating a diagram, a popup ...
2
votes
0answers
75 views

Optimizations for new SQL Server 2000 database that will act as email queue AND API database

Due to limitations put on me I've got to put my outgoing Email Queue in the same database as my customer information. What are some optimizations I can make, specifically to the Email portion that ...
2
votes
0answers
262 views

DTS error when a parameter is added to an Execute SQL Task

I have an Execute SQL Task that is (hopefully) going to receive a global variable called startDate, which is set to a Date type. A shortened version of the code looks like this: DECLARE @startDate ...
1
vote
0answers
194 views

Unable to insert into or update table

A have the following table in a SQL Server 2000 database (service pack 2), with about 600,000 rows: Id [int, primary key] Form [int] Element [int] Data [char(8000)] MoreData [varchar(8000)] ...
1
vote
0answers
489 views

SQL pre-login handshake connection failure

I'm having an intermittent problem with one of my old SQL 2000 servers. Every once in a while it stops accepting logins. I fix the problem by bouncing sqlservr.exe and then it starts working properly ...
0
votes
0answers
21 views

sql server 2000: no longer able to expand jobs in sql server agent

In SSMS on a Windows 7 machine, while connecting to a server running SQL Server 2000, I am no longer able to click on the Jobs to see the Object Explorer Details. Previously, this was not an issue, ...
0
votes
0answers
21 views

Database migrated to SQL Server 2005 with 80 compatibiltiy from SQL Server 2000 experiencing locks

I am supporting an application whose code my company did not write, and was originally developed back in 2000-2002, by a company that no longer exists. The code, while not great to maintain, ...
0
votes
0answers
44 views

linked server to a network csv file

I am trying to create linked servers from SQL 2000 and 2005 to a network share csv file. I am using Microsoft Jet 4.0 OLE DB Provider with "text" as the provider string. With regards to security, I ...
0
votes
0answers
29 views

sql server 2000 linked server works locally but not from remote machine

sql server 2000 linked server works locally but not from remote machine ,i am not able to use linked server remotely (from my desktop). i enabled TCP/IP for the sql Server and i enabled win&sql ...
0
votes
0answers
124 views

Query should yield result but doesn't

I need to get data from a remote SQL 2000 server and store it in a new MySQL server. I am using the FreeTSD module for php 5.3 to connect to the SQL 2000 server. I can connect without problems. ...
0
votes
0answers
107 views

SQL Server 2000 database attach error to SQL Server 2005

I have a SQL Server 2000 database (mdf and ldf). When I try to attach it, using SQL Server Management Studio Express 2005, I get this error: Attach database failed for Server 'XXXXX\SQLEXPRESS'. ...
0
votes
0answers
98 views

Msg 15064, 15275, and 15235 when running sp_spaceused

I have a database on SQL Server 2000 (no, I can't upgrade right now) where I'm trying to run sp_spaceused on each table. I'm getting the messages below. Any given table may have any, all, or none of ...