Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008]

A version of Microsoft's database server, released in August 2008. This is different than SQL Server 2008R2.

SQL Server 2008 is Microsoft's version of SQL Server following SQL Server 2005. A list of the new features can be found here

1806 questions
0
votes
2 answers

SQL Server 2008 - Changing Identity increment of a primary key in a table

I am changing the increment (making it 2 instead of 1) in identity of a column. SQL Server giving me the following error while making change to DB. I searched on internet but some of people saying that this can be a hardware issue but I've tried the…
Tausif Khan
0
votes
5 answers

Can no longer connect to SQL Server 2008 from another machine

Excuse me if this is too open-ended but, I have a Windows Server 2008 R2 Standard. It's running a SQL Server 2008 database server. (all 64bit if that matters). Earlier today they had a power outage. After the power came back on no clients could…
Jeff
  • 277
  • 3
  • 14
0
votes
1 answer

SQl Server table using too much diskspace

I have two identical tables in two seperate databases on the same instance of SQL server, defined as follows (note this is third party software so I can't change the table schema):- EDIT: [RouteParamXml] nvarchar NOT NULL is always an empty…
David Hayes
  • 442
  • 4
  • 12
0
votes
2 answers

Various logins feature of sql management studio 2008

In SQL management studio, you can open a New Query by right clicking on the Server Group itself rather than a registered server. When you do so, at the bottom right, you can see the user as and the database as . In this…
Rashmi Pandit
  • 194
  • 2
  • 12
0
votes
1 answer

Importing registered servers from sql mgmt studio 2005 to 2008

I have just got SQL Server Mgmt Studio 2008 installed on my machine. Previously I was working with SQL Server Mgmt Studio 2005. I had stored a number of databases under Registered Servers in 2005. I am able to export these to a .regsrvr file from…
Rashmi Pandit
  • 194
  • 2
  • 12
0
votes
1 answer

Can SQL 2008 and SQL 2008 R2 reside in a single machine?

I do know that it would be much better if I try it first. But the problem is that its my client's dedicated server with many websites running on it. So, I cannot actually test that there. The server is Windows Server 2008. My queries are Does SQL…
naveen
  • 123
  • 12
0
votes
1 answer

Server Configuration

Recently we have got problems with performance in SQL Server 2008 Enterprise. One idea to solve it is to scale up, i.e. improve hardware of the server. SQL Server 2008 has 2 instances that are running under 64-bit Windows Server 2008…
Timofey
  • 145
  • 1
  • 7
0
votes
2 answers

Can the 'Security type' of a wireless network prevent a connection to SQL Server 2008?

I have a dev instance of SQL Server 2008 running on a Windows 2003 virtual private server that I can access without problems from SSMS running on my laptop, connected to my wireless network at home. But, when I take the laptop to my office and…
user50623
  • 103
  • 2
0
votes
1 answer

MS Analysis Services + IIS - configuration/connection issue

(I am not a professional windows server admin and its my first time dabbling with analysis services.) I am trying to get the Analysis Services up and running such that I can fire MDX queries via XMLA. Here is what I have done so far (on a standard…
amol
  • 103
  • 4
0
votes
3 answers

SQL Server 2008 - Restore database without restoring transaction log (LDF)

I have a production database with Full recovery mode where the MDF and LDF files are approx 80GB each. We have a test server that we restore this database to on a regular basis for dev / test purposes, etc. At the moment the restore has happened, we…
Robin Day
  • 506
  • 1
  • 8
  • 19
0
votes
1 answer

your sql server installation is either currupt or has baan tempered with (unable to load SQLBoot.dll)

we are getting this error on live server and need urgent reply. "your sql server installation is either currupt or has baan tempered with (unable to load SQLBoot.dll)" Thanks.
Sami
  • 101
  • 2
0
votes
3 answers

Copying SQL Server 2005 Databases

We currently have a single SQL server (2005, on a Windows server 2003 machine) with 3 DBs on it that I would like to just straight copy so that I can run some test on them for an upgrade. I don't think I can do this with the copy DB wizard as I am…
Tablemaker
  • 1,149
  • 1
  • 11
  • 23
0
votes
1 answer

How do i grant my windows user access to a production database restored to my local machine?

So I am trying to migrate schema changes to my production system. To do this I want to first test the schema changes on a local backup of my production database, so I downloaded the latest backup from the server, restored it to my localhost's Sql…
KallDrexx
  • 306
  • 1
  • 3
  • 12
0
votes
1 answer

What hosted server configuration do I need to consider for a medium-performance web-application?

I have a Microsoft ASP.NET MVC web application with SQL Server 2008. Currently running on a single server, performance is reasonable. However I now need to deploy the same application to support much higher volumes. There are also a number of…
Mark Chidlow
  • 123
  • 3
0
votes
2 answers

Hide SQL Server 2008 from attackers

I am using an MS-SQL Server 2008 instance as back-end DB server for a project. I did some security tests on the machine hosting my project and SQL Server and got the following report on SQL Server: On port 1853/TCP a database server is running…
user76678
  • 349
  • 3
  • 5
  • 16
1 2 3
…
99 100