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
Questions tagged [sql-server-2008]
1806 questions
0
votes
1 answer
Connecting remotely to an Sql server inside a LAN
Hello everyone,
I am using sql server 2008 inside my home lan. I've configured it to accept remote connections and I can now connect to the server from other pcs inside the lan.
The problems rises when I try connecting to the server from a computer…
vondip
0
votes
1 answer
ASP.NET Application Connection String and SQL Server Security / Permissions
I am deploying an ASP.NET application and SQL Server (2008) database on a live (production) server. The physical server is running both SQL Server 2008 and IIS 7 - it is provided by a hosting company and is not part of our internal network.
I have a…
Chris Cannon
- 103
- 3
0
votes
1 answer
How to Protect a Database Structure
All, I have a new application that uses an administration database (SQL Server 2008 R2) to enforce data structure constraints. It is important that the table structure of this database is maintained at all costs, and the biggest danger of the…
MoonKnight
- 103
- 3
0
votes
1 answer
How to either completely remove SQL Server 2008 R2 Installation or repair it?
I've installed MSSQL server correctly, then I took some wrong turns and I'm now left in a pretty undesirable state. I wanted to change the server instance to another drive, so I uninstalled SQL server and all of it's features from the Programs and…
bevacqua
- 327
- 1
- 3
- 11
0
votes
2 answers
An mdf file of a Sql server 2008 database is bigger than expected
I have a Sql server 2008 database that contains many images. In theory they should make up most of the space on the database.
I moved the images to Filestrem fields but the size of the mdf didn't decrease much at all.
How is that possible? How can…
Durden81
- 131
- 5
0
votes
6 answers
Connecting remotely to an SQL server inside a LAN
I am using SQL server 2008 inside my home lan. I've configured it to accept remote connections and I can now connect to the server from other pcs inside the lan.
The problems rises when I try connecting to the server from a computer outside of my…
vondip
0
votes
1 answer
how can I determine that I am consuming SQL CAL license?
assuming I have bought 5 User CALs and now I need to tag these licenses, can some tell me how to determine this?
Devinder
- 1
0
votes
1 answer
How do I add a linked server in SQL Server 2008?
I want to pull some data into my queries from a remote server (also SQL Server 2008), because some related data is on the remote server but not the local server.
The "add linked server" wizard in SQL Server 2008 asks me for a "Linked Server Name",…
Triynko
- 3,418
- 6
- 31
- 30
0
votes
1 answer
SQL-Server 2008 : Table Insert and Range Check ?
I'm using the Table Value constructor to insert a bunch of rows at a time.
However if i'm using sql replication, I run into a range check constraint on the publisher on my id column managed automatically.
The reason is the fact that the id range…
LB40
- 103
- 4
0
votes
1 answer
Can't login to SQL Server 2008 on Domain Controller
Possible Duplicate:
Cannot connect to SQL Server
I had SQL Server 2008 functional before I installed Active Directory and setup a domain (this is on Server 2008 R2, the only domain controller), but now I can't login to the SQL Server (from SQL…
David
- 461
- 1
- 7
- 22
0
votes
5 answers
Cannot backup databases from SQL Server 2008
I'm trying to back up the SQL Server 2008 database on Windows Server 2008, using instructions from:
http://msdn.microsoft.com/en-us/library/ms253070%28VS.80%29.aspx
Everything is pretty straightforward (just follow through the wizard to trigger a…
Contango
- 1,150
- 5
- 15
- 31
0
votes
3 answers
SQL Server 2008: Getting Login failed for user "Domain\User". Failed to open the explicitly specified database [CLIENT: IP.ADD.RR.ESS]
This is a very similar issue to " SQL Server 2008 login problem with ASP.NET application: Failed to open the explicitly specified database " which unfortunately seems to have gone unsolved.
My issue here is subtly different. Firstly the account…
GodEater
- 560
- 1
- 6
- 12
0
votes
1 answer
2 VMs with Win Server 08 - how to ping/connect to a DB?
In the past, I always installed SQL Server on the same machine as the server application that would be using it.
Now for the first time I need to install a MS SQL Server 2008 R2 DB instance on a separate system. One system has only the DB and…
Klaus
- 31
- 2
0
votes
3 answers
SQL Server 2008, should I set minimum server memory?
We move from this server:
SQL Server Express R2 (has a 1CPU/1GB ram limit as far as I'm aware)
2GB Ram
2 core 2.1ghz
To this server:
SQL Server R2 Enterprise
8GB Ram
4 core 3.2ghz
Everything seems to be working fine. Our MDF and LDF files for the…
Tom Gullen
- 385
- 4
- 8
- 24
0
votes
1 answer
How to restoring the Registered Server window in SQL Server Management Studio
Is there some way to restore the Registered Server window in SSMS ?
I don't mean restoring the individual server details, rather I mean the actual window
I've tried clicking the menu item "View \ Registered Servers" and the keyboard short-cut CTRL…
SteveC
- 271
- 3
- 8
- 21