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

Track usage of columns or tables in Microsoft SQL server

We have a collection of very old, horribly designed databases and I have been given the green light to tear them out and restructure them. However, these databases have no normalization, numerous fields have been empty for years, or re-purposed…
kscott
  • 123
  • 2
  • 10
0
votes
2 answers

Configuring SQL server 2005 enterprise edition

What are the basic settings required for running SQL server 2005 enterprise edition in a local computer. When i take program from start menu it shows only sql server configuration manager, surface area manager, error reporting and a command prompt.…
Dilse Naaz
  • 21
  • 1
0
votes
2 answers

NT AUTHORITY\SYSTEM cannot login to SQL Server 2005 databases

A custom service which runs as Local System on a Windows Server 2003 server needs to login to a database running on a local instance of SQL Server 2005. SQL Server services runs as Network Services, so actually database login is not allowed for NT…
Danilo Brambilla
  • 1,031
  • 2
  • 15
  • 33
0
votes
2 answers

Native SQL logins timing out at login validation phase

The default SQL Trace of my instances shows the following issue for native SQL logins (non-domain accounts): Network error code 0xe8 occurred while establishing a connection; the connection has been closed. This may have been caused by client or…
sqlreader
  • 281
  • 1
  • 3
  • 8
0
votes
1 answer

Connect to SQL Server 2005 In Different Network

I need a help on SQL Server Remote Connection Issue. I have Windows Vista with SQL Server 2005 installed.I need client to connect to my system. My client is in VB6 uses SQL Native Client.Clients which are in the same network can connect connect to…
Tony Dsouza
  • 3
  • 2
0
votes
1 answer

MS SQL Hardware Configuration

About to order a replacement mirrored database pair to drive our multi-user web applications and looking for some guidance on some aspects. I have read various feedback on other posts but finding it hard to put the feedback in context for our usage…
Chris
  • 164
  • 2
  • 9
0
votes
2 answers

DHCP address leases to SQL Server database?

Is it possible to store the DHCP address leases in Windows 2003 to SQL Server database??
user1066699
0
votes
2 answers

Restore database to SQL server 2008 from SQL server 2005

I need to restore my database to SQL server 2008. Currently we are having our database in SQL Server 2005 in one server. We need to take the back up of that database and move that database to SQL server 2008 in another server. I can find the steps…
Karthik
  • 1
  • 2
0
votes
1 answer

Orphaned SQL Recordsets/Connections with IIS

I have an IIS 6 site running on Windows 2003 Server x86 with MS SQL2005 Enterprise edition running ASP Classic (no choice). The site runs very fast with about 8000 page views per hour. All of my SQL tables are indexed and I have used the profiler to…
Damian
  • 1
0
votes
1 answer

SQL Server database connections being dropped intermittently

Occasionally in one of our production environments (we have a dozen or so without different clients pointing to each) we get exceptions at different points in the process. The code doesn't do anything fancy - just your basic inserts and updates. …
Arthur Frankel
  • 125
  • 1
  • 2
  • 6
0
votes
1 answer

Error Connecting to server with SQL Server Management Studio Express 2005

Problem logging in with SQL Server Management Studio Express 2005? When I try connecting to a server in SQL Server Management Studio Express 2005 with Server Name as PC-Name\MSSMLBIZ\SQLEXPRESS or ./SQLEXPRESS and Windows Authentication it shows…
Garvit Khandelwal
0
votes
2 answers

adding columns to table results in 'low disk' error message

One table of our database has large amount of data. It has about 20 million records. We need to add 2 new columns into this table. We have 15 GB space on the drive. When we start the process to add new fields, this process eats all the memory and…
Yasir Malik
0
votes
2 answers

Install SQL Server 2005 on computer with an existing SQL Server 2008 installation

I have a Windows XP 64 bit workstation. I installed SQL Server 2008 R2 Standard x64. After that, I installed SQL Server 2005 Standard x64. Installation completed with no issues, but no instance was created. If I run 2005 or 2008 tools, there is no…
ahpitre
0
votes
1 answer

SQL Server 2005 Management Studio Language Settings

I'm working with a Korean language copy of SQL Server 2005. I'm not familiar with the software so I have to match buttons by hotkey, comparing with screenshots from tutorials when my limited Korean fails me. Is there a way to switch the whole…
user98149
0
votes
1 answer

Powershell SQL results comeback in hashtable i just need the value

I have the following script that runs a stored procedure and returns a value. The problem is it returns a hash table and using result.answer returns nothing. How can I get the value without the hash table attached? $SqlConnection = New-Object…
Brandan
  • 29
  • 2
  • 8
1 2 3
…
71 72