This tag is specifically for the 2000 version of Microsoft SQL Server
3
votes
0answers
111 views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
2
votes
0answers
31 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
183 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
69 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
166 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 ...
2
votes
0answers
100 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
...
1
vote
0answers
234 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 ...
1
vote
0answers
81 views
Pull replication stuck on Microsoft SQL Server 2000. What is the safest way to get it running again?
I believe the steps necessary would be:
Generate scripts to "create or enable" (including replication jobs) by right clicking the subscription in question in "local subscriptions" and saving the ...
1
vote
0answers
145 views
Is there a way to use a SQL Server 2000 database in SSIS 2012?
I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and ...
0
votes
0answers
6 views
Syncronization with transformation
I have the following scenario: a database in SQL Server 2012 that must replicate changes in a transactional way to a SQL Server 2000 database. Since the schemas of two databases differ, a ...
0
votes
0answers
64 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
25 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 ...
0
votes
0answers
53 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
0
votes
0answers
47 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
76 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 ...
