The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
3answers
670 views

Retrieve MS SQL database or table structure in XML

Is there a way to export the database schema in well formed XML of a MS 2000 SQL Server. I'm looking for just the structure not the data and the more detailed the better. The XML may be used in a ...
2
votes
2answers
380 views

Benchmark tests for MSSQL 2000 VS MSSQL 2008.. (thinking for upgrade)

How much of a difference will there be (for speed and other benchmark results) for a database about 5 and even 10 GB to move from MSSQL 2000 to MSSQL 2008? It's running on a Windows 2003 VMWare guest ...
0
votes
2answers
126 views

Diagnosing intranet performance issues

I'm attempting to figure out why our intranet is having performance issues. From some basic troubleshooting, I'm leaning towards the issue being our SQL server, which is hosted on a separate server. ...
0
votes
2answers
433 views

Connectivity with SQL Server Express 2008 r2 and SQL Server 2000 on same machine

At first glance this may same a duplicate of Installing both SQL Server 2000 and SQL Server 2008 on the same machine, but it is not. I have SQL Server 2000 and SQL Server 2008 R2 installed on the ...
0
votes
2answers
104 views

SQL 2000 Backup/Export Process - Can't find SQL 2000 Enterprise Manager, Can't use Mgmt Studio Express

I need to make a backup of a client's SQL 2000 database, however there are a few issues preventing me from doing so using the traditional methods. I've tried using SQL Management Studio Express, but ...
0
votes
2answers
328 views

Sql 2000 Connect From Domain PC to WorkGroup PC using Windows Authentication

Sql 2000 - I am trying to connect from a PC w/ client tools that is on a domain, to a Sql Server 2000 box that is NOT on the domain using Windows Authentication. I thought I had done this in the ...
2
votes
1answer
434 views

How to create a shared lock blocking an intent exclusive lock

As I understand it, a SELECT statement will place a shared lock on the rows that it will return. While that SELECT is running, if an UPDATE statement comes along and needs to grab an intent exclusive ...
1
vote
1answer
301 views

SQL server 2000, replication over WAN

I seem to have big difficulties setting up the first replication ever between two SQL2000 instances. They both run in seperate WAN's (IP with port assigned for SQL-remote) but I have been able to ...
1
vote
1answer
383 views

linked-server sql - access

I have a SQL server 2000 and an Access database mdb connected by Linked server on the other hand I have a program in c # that updates data in a SQL table (Users) based data base access. When running ...
0
votes
1answer
78 views

SQL Reporting service unable to start after restoring on new hardware

I have a SQL server that the hardware is failing. As a solution we restored the image of the server on a multicore (more less new) server. The problem is that SQL 2000 cannot be started if number of ...
0
votes
1answer
93 views

Setup was unable to validate logged in user

I'm trying to upgrade SQL Server 2000 to SP4, so I can upgrade it to 2008 later, but I'm getting this error. I tried with windows login that have administrator privileges, and with sa password as ...
0
votes
1answer
289 views

How can i find what's using the RAM in the server?

I am dealing with 32bit Windows 2003 server which was once a physical box, but now is virtualized in vmware. There are two SQL Server instances running. One is 2000 Standard, another is 2008 R2 ...
0
votes
1answer
218 views

SQL Server 2000 unable to apply cumulative update 8.00.2187

Windows Server 2003 SP2, SQL Server 2000 SP4 (8.00.2039 - according to Add/Remove programs) but with patch 8.00.2055 applied according to 'select @@version' When I try to apply the cumulative update ...
0
votes
1answer
85 views

Transactional Replication from SQL Server 2008 to 2000

I has transactional replication from my server1 (MS SQL 2000) to server2 (MS SQL 2000) in another company (and on different network) and it worked OK. Instead of using real name of server2, I used ...
0
votes
1answer
159 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
0
votes
1answer
211 views

SQLSTATE 42000 on Restore after restoring native backup from NetBackup tape

My environment is Windows Server Standard 2003 SP2, SQL Server 2000 SP4 with a few additional patches, NetBackup Admin console 7.1 and NetBackup Client 6.5.3. I take nightly full backups that restore ...
0
votes
1answer
321 views

SQL Server 2000 Memory Status

I'm trying to get a better idea of how my SQL 2000 instance is using it's memory. I've run DBCC MEMORYSTATUS and I'm hoping someone can give me a better idea of how to interpret the output. My main ...
2
votes
0answers
22 views

SQL Upgrade Adviser for win2k

I'm trying to upgrade a SQL Server 2000 instance to SQL Server 2008 R2. SQL Server 2000 resides on an old win2k box, and the new SQL instance is being run on a Server 2008 R2 platform. I am attempting ...
2
votes
0answers
1k views

Weird bug when copying from sql server management studio to excel in windows 7

I run a query in SQL management studio (results to grid), then select all results and copy with headers. Then I paste into Excel. The result: two specific records are put together on one row in ...
0
votes
0answers
31 views

Migrating SQL Server 2000 from Physical to Virtual

My team will be tasked with a Physical-to-Virtual migration of SQL Server 2000. The main requirement will be: Minimization of downtime and minimization of impact on operation. The action plan is as ...
0
votes
0answers
25 views

SQL Server 2000: Monitor replication

starting with (Microsoft) SQL Server 2005, there are stored procedures available to monitor replication (http://www.g-productions.nl/index.php?name=sp_replmonitorhelppublication) But as we are a bit ...