1
vote
1answer
73 views

Password case sensitivity when upgrading from SQL Server 2000 to 2005

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem. So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...
0
votes
2answers
279 views

Killing a cross server SELECT query has lead to an indefinite KILLED/ROLLBACK process. What's going on here?

A long running query was being run on a SQL Server 2005 database which referenced tables on a SQL Server 2000 database. Both instances of SQL Server are running on the same machine. It was only a ...
2
votes
2answers
99 views

Backwards-compatible (to SQL 2000) server version and compatibility version check

I have a script which uses features not present in SQL Server 2000. Specifically, the script creates a stored procedure which uses a data type added in SQL Server 2005. I need to use conditional ...
0
votes
2answers
145 views

SQl 2005-2008 vs. SQL 2000 maintenance

At my company we've been using SQL Server for quite a while and have followed the recommended upgrade path. I've noticed that over the last couple of years I'm spending way more time rebuilding ...
2
votes
1answer
423 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 ...
0
votes
1answer
693 views

MSSQL 2005 > Linked Server Connection Fails > MSSQL 2000

At the company I work for, we currently are running 3xSQL 2005 servers and 1xSQL 2000 server. All of the 2005 servers can communicate with each other, however they cannot communicate with the 2000 ...
2
votes
2answers
354 views

Equivalent of SQL 2005's SQLAgentOperatorRole (msdb ) in SQL 2000?

Can anyone tell me what is the Equivalent of SQL 2005's SQLAgentOperatorRole (msdb ) in SQL 2000? I want to grant a login ability to disable a job in SQL 2000. Thanks in advance....
0
votes
1answer
152 views

MS SQL dts to ssis migration error

I have migrated some DTS packages to SSIS 2005 using "Migration" wizard. When I tried to run it, it fails saying you need a higher version of SSIS even though the destination SSIS server is on ...
2
votes
2answers
566 views

SQL Server 2000/2005 query list user access

is there a query to list database user access and related source IPs on SQL Server 2000 and 2005? Please note that reporting service is not installed. Thank you all for help.
1
vote
6answers
64 views

SQL Server 2000 tables

We currently have an SQL Server 2000 database with one table containing data for multiple users. The data is keyed by memberid which is an integer field. The table has a clustered index on memberid. ...
0
votes
1answer
65 views

Can I run a pull DTS package on SQL 2000 to copy data from SQL 2005 (compatibility level 90) to SQL 2000?

Can we still run our DTS package on SQL 2000 to pull data from a SQL 2005 database with compatibility level set to "SQL Server 2005 (90)" ??
0
votes
2answers
75 views

why does my sql2000 database perform worse in sql2005

We have a sql 2000 database thats about 1.2 gb big and a website pointing at said database. We are looking to upgrade to sql 2005 and are in the process of testing this transition. we took the mdf and ...
3
votes
1answer
100 views

What replication options exist between SQL Server 2000 and 2005?

We have a business partner that is still on SQL Server 2000, and we would like to replicate a couple databases to one of our SQL Server 2005 instances. The business partner databases that we need to ...
0
votes
2answers
5k views

How to change the default instance of SQL Server?

we have a dev server. First we had SQL 2000 (default instance), when SQL 2005 came out, we installed it as a named instance. Nowadays we barely use the SQL2000 instance, but this is the default. We ...
4
votes
2answers
132 views

Virtualisation and SQL server

The sysadmins where I work are looking to re-organise our servers and they have suggested that we put the main production SQL DB on a virtualised server. Is there anything they need to consider when ...
2
votes
5answers
1k views

How to install SQL Server 2000, SQL Server 2005 and SQL Server 2008 on a single machine

I'm in the process of migrating development databases from an old (soon to be decommissioned) database server to a VMWare-hosted virtual machine running Windows 2008 x64. The old server runs SQL ...
0
votes
5answers
567 views

Improvement (not new) Features Between SQL Server 2005 and 2008

Here are the givens: you are going to want to scream about this question this is an Oracle shop and will continue to be all current environments are MSSQL 2000 Standard Edition the answer(s) will ...
3
votes
1answer
157 views

Smarter SQL 2000 and 2005 maintenance plans?

Should SQL 2000 and 2005 maintenance plans be resilient to a database being detached or offlined? I detached / offlined a few databases, and now the maintenance plans are failing in their entirity ...
2
votes
3answers
950 views

Migrating SQL server 2000 database to SQL server 2005

Can any one suggest variou ways of migrating a database from SQL server 2000 to 2005. How do I make sure all constraints, primary keys and indexes are preserved. Is there any migration tool that ...
6
votes
4answers
17k views

SQL Server 2Kx: How to move a database to a different partition in the local file system?

SQL Server creates its databases in the system program files directory structure. I want to separate the database files away from the system partition. Assuming the database is already created and ...
8
votes
8answers
29k views

SQL Server restore a backup results in an error

I have a database in dev (SQL Server 2005 on Windows Server 2008) that I need to move to prod (SQL Server 2000 on Windows Server 2003). My process is as follows: Login to dev, open SQL Server ...