The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
3answers
533 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
358 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
122 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
430 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
325 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
414 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
282 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
376 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
28 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
69 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
192 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
190 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
82 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
120 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
176 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
298 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
842 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
112 views

SQL Trace Profiler Not Capturing All Connections

I'm trying to run a profiler trace on a server to track any unused databases. I'm seeing connections through 'Audit Login', however for certain active databases there's nothing showing up on the ...