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

How to recover/restore SQLServer 2005 databases from MDF/LDF files

I have a SQL DB instance that was stopped/shut down improperly and the msdb system db along with the regular DBs have been "in recovery" for over 2 weeks now. sometimes after a reboot one DB in the instance will work for a while, while all the…
user44650
  • 137
  • 4
  • 11
0
votes
2 answers

Benchmark a new SQL Server

We have just built a new server running SQL Server 2005 sp3 64 bit. The plan is to migrate our production database over to this new server from the existing server. I would like to get an idea of the performance of the new server compared to the old…
damitamit
  • 71
  • 1
  • 6
0
votes
1 answer

sql server 2005

how to restore deleted row from particular table .? i have tranct log file
mohammad shamim
0
votes
1 answer

Scripting a database copy from MS Sql 2005 to 2008 without detach/backup/RDP

My goal is to move a single SQL 2005 database to a seperate 2008 server. The issue is my level of access to both servers. On each I can only access the database and nothing else. I cant create a backup file or detach the database because I don't…
James Santiago
  • 876
  • 5
  • 11
0
votes
1 answer

SQL Server 2005 Express: upgrading to SP3 in mixed-mode installations

I'm having trouble upgrading SQL Server 2005 Express SP1 to SP3. The SP1 install uses mixed mode authentication (so there is an sa password). This is the message I get: TITLE: Microsoft SQL Server Setup ------------------------------ None of the…
Jeroen Wiert Pluimers
  • 290
  • 6
  • 14
0
votes
2 answers

Cannot drop a table in SQL 2005

I have a SQL Server 2005 SP3 box that one of my developers created a temp table on that we cannot seem to remove because it somehow got brackets in the name of the table? SELECT Name, object_id FROM sys.objects WHERE Name LIKE…
David Mathis
  • 898
  • 2
  • 9
  • 21
0
votes
1 answer

MOSS 2007 Sharepoint Shared Services AD Import SQL/Search Error prevents user import

When attempting to import new AD users (Shared Services Administration > Shared Service > User Profiles and Properties) I receive an error on the top of the User Profiles and Properties page. "An error has occurred while accessing the SQL Server…
TrevJen
  • 264
  • 1
  • 7
  • 23
0
votes
4 answers

SQL Server Management Studio - Error connecting to remote DB

All right, here is the deal: I'm connecting to a Windows 2003 Server using VPN. On this server, there is a remote SQL Server 2005 Express engine. I can connect to the database using Visual Studio 2008. What I can't do though, is connect to…
Julien Poulin
  • 135
  • 3
  • 7
0
votes
1 answer

Connecting SQL 2005 to Oracle 10g

Environment: - Oracle 10g database over a windows 32bit 2003 server - SQL 2005 database over a windows 32 bit 2003 server. I am trying to connect the above databases through heterogeneous services. I have updated the following files: TNSNames.ora,…
Lorn
0
votes
1 answer

Adding FK Index to existing table in Merge Replication Topology

I have a table that has grown quite large that we are replicating to about 120 subscribers. A FK on that table does not have an index and when I ran an Execution Plan on a query that was causing issues it had this to say --> /* Missing Index…
Refracted Paladin
  • 345
  • 7
  • 20
0
votes
3 answers

sql server 2005 instance unresponsive and all db's are 'in recovery'

we've got a sql server 2005 instance that one of our guys messed up, i believe they killed the sql server service and restarted the computer, and when it came back all of our databases are "in recovery" and it times out every time we try to connect…
user44650
  • 137
  • 4
  • 11
0
votes
1 answer

Dump SQL Server Stored Procedures to Files

Is there a non-interactive (read: script-able) way to dump all stored procedures to disk? We keep versions of our stored procedures in the repository to track changes and for deployment and rollback purposes. Currently whenever we want to modify a…
Jake Wharton
  • 269
  • 3
  • 7
0
votes
1 answer

sql server permissions

Hi How can I set permissions againt existing windows groups in sql server 2005
ruben
0
votes
3 answers

How do I disable Windows authentication on a SQL Server instance?

How do I disable Windows authentication on a SQL Server instance?
leonita
0
votes
1 answer

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 9.0.4211 level. then I digged in the package using…
Manjot
  • 333
  • 1
  • 3
  • 17
1 2 3
…
71 72