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

SQL Server Files Local or NAS or SAN?

I have to install a new Server with SQL Server 2008, What do you recommend, One server with Raid 10 or the Files in a NAS? What about iSCSI should I use it? What about SAN? The server has 4Gb of RAM and that database file is about 2GB. To make my…
Jedi Master Spooky
  • 552
  • 1
  • 7
  • 14
15
votes
2 answers

Difference between "NT AUTHORITY\NETWORK SERVICE" and "NT AUTHORITY\SYSTEM"

I am installing MS SQL Server 2008 R2 and I got to the window where I have to set the service accounts. I want to know the difference between NT AUTHORITY\SYSTEM and NT AUTHORITY\NETWORK SERVICE. I tried to Google it but I found no well-defined…
Majd
15
votes
2 answers

What is a SQL Server instance?

When I install SQL Server 2008 Express in prompts me to create an instance and aborts if I don't. Then I see that information in an entry in Sql Server Configuration Manager on SQL Server Services. What is a SQL Server instance?
Pablo Fernandez
  • 7,438
  • 25
  • 71
  • 83
14
votes
6 answers

SQL Server Express for Production Databases?

We are about to roll out a dual web/internal transactional application where each client has their own database. Each database is very small - under 50MB each, so we were wondering if it would make sense to use SQL Express 2008 instead of the full…
Beep beep
  • 1,833
  • 2
  • 18
  • 33
13
votes
3 answers

How to restore a SQL Server database and shrink its files at the same time?

Let's say I have a SQL Server database whose data files have been created with an initial size of 100 GB, but it only contains 10 GB of data. A database backup will then be only 10 GB in size. I want to restore this backup to a different server (or…
Massimo
  • 70,200
  • 57
  • 200
  • 323
13
votes
8 answers

Activity monitor is unable to execute queries against server

Is there any fix to get SSMS activity monitor working? Problem: SQL Server Activity Monitor fails with an error dialog: TITLE: Microsoft SQL Server Management Studio The Activity Monitor is unable to execute queries against server [SERVER].…
mika
  • 1,466
  • 2
  • 12
  • 18
13
votes
10 answers

Can't remotely connect through SQL Server Management Studio

I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following steps below and am beyond any further ideas. I have…
FAtBalloon
  • 279
  • 1
  • 4
  • 12
12
votes
4 answers

Microsoft SQL Server Management Studio 2008 deleting multiple user tables

Is there an easy way to delete multiple tables in the database without dropping the database and recreating it? In this case we have over 100 to remove. I am happy enough to remove all user tables and reimport the needed data but can't touch any of…
Ryaner
  • 3,097
  • 5
  • 25
  • 33
12
votes
4 answers

How can I see who is connected to my db?

I was trying to rename a database and it said that it needed to be exclusively locked to perform this operation ... How can I check who is connected to it?
Alex Gordon
  • 455
  • 3
  • 14
  • 31
12
votes
5 answers

How do I restore a batch of transaction logs rather than one by one

I have a SQL Server database that backs up the transaction logs every 10 minutes, with an overnight full backup. Using SQL 2008 Management studio we seem to have to select each transaction log one by one. Is there any way to point it at a…
aSkywalker
  • 555
  • 3
  • 9
  • 15
11
votes
2 answers

How to enable remote connections for SQL Server 2008?

How do I enable remote connections on an SQL Server 2008 installation? I have created a rule in the windows firewall to allow traffic through port 1433, but that does not seem to be enough.
Kjensen
  • 1,039
  • 10
  • 28
  • 39
11
votes
6 answers

How can I have SQL Server Management Studio 2008 connect to my instances automatically?

I'm running a server with 3 database instances. Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else). Would it be possible to have it so that, when I open it,…
Daniel Magliola
  • 1,432
  • 9
  • 20
  • 33
11
votes
2 answers

Alias a linked Server in SQL server management studio?

Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server? I have a server, added by IP address, to which I do not have the login credentials - however as the connection is already setup I…
absentmindeduk
11
votes
4 answers

Is there a way I can use SQL Server management studio to find all columns that have column names that contain a certain substring?

I'm using SQL server management studio 2008. I have a huge legacy database with thousands of columns. It would be nice if I could search for all columns whose names contain a certain substring. Does anyone know how to do this? Thanks!
IsaacB
  • 335
  • 1
  • 5
  • 12
11
votes
5 answers

Database planning - Multiple Schemas vs Multiple Databases vs Single large database vs Partitions

We design websites for Realty companies. The websites are used only to display the information and all the websites share a common template. We have around 150 websites for different customers. Some third party data providers, provide us all the…
kishore
  • 872
  • 3
  • 13
  • 28
1
2
3
…
99 100