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
3
votes
7 answers

My database using sql server 2005 express is over 4GB, I have no money, am I screwed?

Any thoughts of how to solve this? I tried creating another database and putting some tables there, but actually there is just 1 big table with almost 3 million rows, this table is using all the space, so separating tables is useless. I though…
sergiogx
  • 335
  • 3
  • 15
3
votes
1 answer

Why might login failures cause SQL 2005 to dump and ditch?

Our SQL 2005 server began timing out and finally stopped responding on Oct 26th. The application logs showed a ton of 17883 events leading up to a reboot. After the reboot everything was fine but we were still scratching our heads. Fast forward 6…
Byron Sommardahl
  • 225
  • 2
  • 5
  • 11
3
votes
2 answers

Give developers read-only access to schema

We have a staging server where we do final acceptance testing before we go live. It's a copy of Live where devs have no more privileges than regular users. I'm trying to give the devs read-only permissions on data and objects on this server so they…
David Wimbush
  • 87
  • 1
  • 2
  • 7
3
votes
2 answers

How to encrypt connections to SQL Server with IPSec?

The SQL Server OLEDB provider can use SSL encrypted connections to SQL Server with an option in the connection string: Use Encryption for Data Specifies whether data should be encrypted before sending it over the network. The valid values are…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
3
votes
3 answers

MSSQL I/O performance degraded after SAN consolidation?

Recently I have consolidated all our Dell Equallogic SANs into the same group; previously each SAN was in its own group. They are all populated with 15k RPM SAS drives in RAID 6 so I haven't bothered to tier the storage of the new consolidated…
NaOH
  • 411
  • 2
  • 10
  • 19
3
votes
2 answers

SQL Server : Restore Database; Failed. "error not found"

I have just installed SQL Server 2005 on a fresh machine, and I'm trying to import 2 databases from one of my servers. This has worked fine for a box that I did this morning but now I'm getting some errors on this second box. I am doing the…
user155695
  • 290
  • 3
  • 5
  • 14
3
votes
2 answers

How to determine Read/Write intensive table from DMV/DMF statistics

This is a follow-up question on Stack Overflow question How to find out SQL Server table’s read/write statistics? The goal is the same as the previous question The goal here is to find out appropriate fill factor for indexes According to Mitch…
dance2die
  • 2,011
  • 7
  • 32
  • 41
3
votes
2 answers

How can I reindex sql server tables remotely?

A production database was moved to a SQL Server 2005 cluster, I only have dbo rights to the DB and do not have access to SQL Agent. I do have access to the older SQl Server 2005 system which I could use SQL agent. On the old system there was a job…
Dwight T
  • 209
  • 2
  • 7
3
votes
2 answers

SQL Server Management Studio not scripting all objects

i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the options being selected including all tables the…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
3
votes
1 answer

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our setup, what I investigated, our workaround, and will…
CWilliams
  • 31
  • 2
3
votes
1 answer

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 because SQL can't find/connect to the database. It…
Jason Kleban
  • 806
  • 3
  • 9
  • 20
3
votes
1 answer

How to hide a connection string in the DMZ

We are setting up an IIS Server on Windows Server 2012 in a DMZ, running off-domain. This server requires access to SQL Server 2005 on the other side of the firewall, inside our domain. We plan to use SQL Server authentication to achieve this, which…
Mr Black
  • 133
  • 5
3
votes
5 answers

Executing SSIS package

I posted my question on stackoverflow but I was told that it might be better off here. I have a problem executing my SSI package from command line. I created the package via SQL Server Business Intelligence Studio while logged in as a domain…
Saif Khan
  • 1,945
  • 2
  • 20
  • 25
3
votes
4 answers

Unix and Triggering MS SQL Server Integration Services Jobs

We have an AIX server which contains a lot of data, and once a night we dump that data to CSV for import into MS SQL Server for reporting reasons. At the moment, each step in the process is unlinked, and triggered simply on a timed basis - for…
Moo
  • 2,244
  • 21
  • 23
3
votes
2 answers

SQL Server 2005 Mirrored DB Recovery

Scenario: We want to use SQL Server 2005 Standard's version of DB mirroring along with a witness server in an Active Directory domain environment. The database is fed from a 3rd party app server that cannot be modified apart from the DB connection…
Matt Rogish
  • 1,512
  • 6
  • 25
  • 41
1 2 3
…
71 72