Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2005]

Microsoft's SQL Server is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This tag is for questions on the 2005 version

1072 questions
6
votes
2 answers

Data from a table in 1 DB needed for filter in different DB

I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. The next hurdle I am trying to tackle is adding…
Refracted Paladin
  • 345
  • 7
  • 19
6
votes
12 answers

Move SQL-Server Database with zero downtime

Is it possible to move a sql server 2005 db to a different server running sql server 2008 without any downtime? The system is 24/7 and has to be moved to a different server with different storage. We tried copying the database, but that does not…
kcode
  • 1,805
  • 4
  • 19
  • 21
6
votes
2 answers

What are the basic tasks that need to be done to keep an SQL Server 2005 database healthy

I have a SQL Server 2005 database that is large in every sense. It is complex, it has a lot of data (relatively, but given the lack of blobs, it is still quite large) and it is heavily accessed. What are the basic administration tasks that need to…
Yishai
  • 708
  • 1
  • 6
  • 15
5
votes
6 answers

Sql Server huge tables with no rows

I have a Sql Server database that has a few tables with zero row count but take up a combined 10 GB of space. I can see this by doing right-click/properties on the tables in question (data space is huge, between 1 and 6 GB, and row count is zero on…
Mike Gates
  • 185
  • 1
  • 3
5
votes
2 answers

Using SQL Server 2008 Management studio to connect to SQL Server 2005 databases

I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio. I log on with SQL Server authentication (username+password). When I…
Kjensen
  • 1,009
  • 9
  • 28
  • 39
5
votes
5 answers

Login failed--password of account must be changed--error 18488

I failed to connect to a production SQL server. My administrator reset my password, and told me what it was. SQL Server Management Studio gives me this error: Login failed for user 'Bill'. Reason: The password of the account must be changed.…
Bill Paetzke
  • 855
  • 4
  • 12
  • 19
5
votes
2 answers

SQL Server - list all tables without a primary key

Is it possible to produce a list of all tables within a specified database that don't have a primary key? This is SQL Server 2005.
Martin
  • 552
  • 4
  • 14
  • 25
5
votes
2 answers

Running SQL server 2005 and 2008 on same machine?

Running SQL server 2005 and 2008 on same machine ? Is this possible/practicable ? It's only for developers and not very resource intensive - is there anyone out there who's done it ? Would be interested to hear of experiences or known gotchas. (I…
shearichard
  • 153
  • 1
  • 5
5
votes
3 answers

How to search an entire MS SQL 2005 DB for a value?

How can I search an entire MS SQL 2005 DB for a value? For example 'ABC12345'. Thanks.
Techboy
  • 1,540
  • 7
  • 31
  • 49
5
votes
3 answers

Can't see all catalogs on a MSSQL Linked Server

On SqlServer 2000 I have created a Linked Server to a SqlServer 2005 machine, with "Server type" set to "SQL Server" (first radio button), and the linked server name set to the remote machine's hostname. But SqlServer 2000 can only see ONE of the…
Chris Wenham
  • 179
  • 1
  • 1
  • 8
5
votes
2 answers

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still waiting to hear back on whether it's a full edition…
link470
  • 75
  • 3
  • 7
5
votes
4 answers

Upgrading Sql Server 2000 to 2008

At my place of employment we have been thinking about upgrading from SQL Server 2000 to the latest (2008). We know that the DTS packages will have to be dealt with since the newer server software no longer supports them. Has anyone done this…
Terry
  • 1,073
  • 1
  • 11
  • 17
5
votes
3 answers

Discover intended Foreign Keys from JOINS in scripts

I'm inheriting a database that has 400 tables and only 150 foreign key constraints registered. Knowing what I do about the application and looking at the table columns, it's easy to say that there ought to be a lot more. I'm afraid that the current…
Jason Kleban
  • 786
  • 3
  • 8
  • 19
5
votes
2 answers

Clustered indexes versus non-clustered indexes?

I am in charge of a smaller DB 300+ hundred megs 100'ish tables about 45 users hit it throughout the work day. Mostly reads, but a fair number of updates and inserts. I have been slowing learning the structure of the DB in order to get some…
RateControl
  • 1,207
  • 9
  • 20
5
votes
5 answers

What can cause long query durations without high resource usage?

In advance: sorry for the length of the question... unable to get the right balance between detail and brevity. We are having issues with the DB Server for our web application where queries that should (and usually do) run in a very short time (<…
JMusgrove
  • 1,119
  • 7
  • 8
1 2 3
…
71 72