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
0
votes
2 answers

SQL Server database recovery issue

In SQL Server 2005 when I try to attach my database (MDF) it shows 'not a primary database', but this database has one MDF and one LDF only. How can I fix it?
user433177
0
votes
4 answers

Backup single table MS SQL SERVER

How to take a back up of single table and restore it back when I required. I mean,I need back of single table with all the indexes,constraints and data associated with that table. because I want to modify some of the data of the base table,before…
Dhiva
  • 1
  • 2
0
votes
1 answer

MSSQL: SSIS 2005 transfer logins task

I created an SSIS package to transfer logins from one server to another in SQL 2005 SSIS project using BIDS. I want to transfer all packages but skip 3. So I changed the maximum number of error count to 3. But it didn't help. can anyone please help…
Manjot
  • 333
  • 1
  • 3
  • 17
0
votes
1 answer

SQL server 2005 setup issue. (with SSIS)

I am trying to install sql server 2005 sp 2 x64 bit edition,after selection i am getting below error. TITLE: Microsoft SQL Server Setup None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is…
Dipesh
0
votes
1 answer

Slow Uninstall of SQL Server 2008 / 2005

Each of the components of SQL Server 2008 and 2005 take an age to uninstall - it's not that the bulk of the uninstall takes it's time, it's that it seems to get the the end of uninstalling each component and then take forever 'Configuring…
Will A
  • 101
  • 1
0
votes
1 answer

Connecting to SQL Server 2005 using 127.0.0.1\INSTNAME stops working if SQL Server 2008 is installed on the same machine

I have an application that connects to a named SQL Server 2005 Express instance using 127.0.0.1\INSTNAME. This has always worked. However, if I install SQL Server 2008 (any edition) on the same machine, the application can no longer connect to the…
jmatthias
  • 139
  • 7
0
votes
1 answer

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 server. On the reverse side, the 2000 server can…
ThaKidd KG5ORD
  • 329
  • 1
  • 7
  • 17
0
votes
2 answers

Can't connect remotely to database on SQL Server 2005

I am new to managing servers but I have just been given full access to set up an MS SQL Database on win server 2003. I have created a Database successfully and can connect locally (via remote desktop server) Problem is I can't connect to the…
david
0
votes
1 answer

Flush MSSQL Express in Memory Data to Disk Without Service Shutdown

I am attempting to configure a MSSQL 2005 Express db to flush its in memory data to disk so that the data can be captured by using disk snapshot software. I have been unable to find any particular way to accomplish this through any tools currently…
danorth
  • 65
  • 5
0
votes
2 answers

SQL Server installation

I have installed Visual Studio 2008 on my system (Windows Vista). I'm trying to install SQL Server 2005 to run applications. While installing I got only the configuration tools and no SQL Server Management Studio IDE. Where do I get that?
Saranyya
0
votes
3 answers

Microsoft SQL Server 2005 shrinking log file Consequences?

At the moment SQL Server 2005 is running a database that is 8,9GB in size. the log file is 20.1GB in size and the HDD is filling up fast. Now i know i can shrink the log file. but i can't find any answers as to what the Consequences are to doing…
Duncan Roosma
  • 103
  • 1
0
votes
2 answers

Error encountered while installing SQL server 2005

I am trying to install SQL Server on my machine that has windows XP. During installation system encounters an error while installing MSXML 6 Service Pack 2 (KB954459) and SQL server installation fails. I researched on web and people have recommended…
CSC
0
votes
1 answer

How do i archive newly added DB backups?

I'm using Windows Server 2003, Sql-Server 2005 and 7-zip for archiving. Each day maintenance plan adds all DBs to backup and i need to archive those but just those files. How do i create .bat or .vbs script which deletes previous archive adds only…
eugeneK
  • 410
  • 2
  • 8
  • 18
0
votes
1 answer

SQL Server 2005 Lock Pages in Memory on 32-bit system

On a 32-bit Windows Server 2003 Standard Edition SP2, I'm debating the pros and cons of /3gb + AWE + Locked Pages for SQL Server 2005 Standard SP3 CU4. The system only has 4GB of physical memory, however the developer's IIS service seems to be…
califguy4christ
0
votes
4 answers

Why some XP installs don’t automatically Start SQL2005 Service (Instance)

I have a number of XP machines that have a SQL 2005 Instance running on them, and they are set to start automaticly in Service Control Manager. On 1 or 2 of these machines when you reboot, the SQL Instance doesn't start. Nothing makes it into the…
Paul Farry
  • 231
  • 1
  • 11
1 2 3
…
71 72