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
3 answers
How do I update the SQL Server 2008 to include the studio?
How do I update the SQL Server 2008 to include the studio?
Here is what I currently have on my machine:
I assume I am supposed to clidk on "SQL Server Installation Center"
From there I get this window:
and I assume I am supposed to click on the…
xarzu
- 109
- 5
0
votes
4 answers
Does sql server standard come packaged with windows server 2008 r2?
Does sql server standard come packaged with windows server 2008 r2?
Seth
- 127
- 1
- 6
0
votes
1 answer
Scripts to automate maintenance on thousands of databases?
We have a web application that, for government-regulated security reasons, requires each client to have their own database. As a result, we have a few thousand small databases that all have the exact same schema (each database is between 10MB and…
Beep beep
- 1,833
- 2
- 18
- 33
0
votes
2 answers
Efficient way of importing large amount of data into SQL Server 2008 from MySQL
Alright, to start, please don't comment on the switch from MySQL to SQL Server 2008 - I tried to resist this decision - I know it's not ideal, but it's the reality of what I am trying to do. I'm competent with MySQL and a newbie to SQL Server 2008,…
Tristen
- 23
- 1
- 3
0
votes
1 answer
SSIS package hangs on Setting Source Connection
I have an SSIS package that has been executing successfully for the last 7 years.
All of a sudden the package won't run and hangs at the Setting Source Connection step and has to be closed down via End Task. I can access all of the databases but…
kereberos
- 101
- 2
0
votes
1 answer
SQL 2008 publisher -> SQL 2000 subscriber: Is a pull subscription possible for merge replication?
I am trying to synchronize a SQL 2000 SP4 subscriber to a SQL 2008 publisher via a merge pull subscription. When the subscriber tries to run the merge agent, it fails the following error:
The process could not connect to Distributor…
Brian Dunzweiler
- 23
- 6
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
1 answer
Cannot install SQL Server 2008 R2 service pack 1
upgraded SQL 2008 t0 2008 R2 the other day.
Rebooted the server had the software team check the databases.
Everything worked fine
I tried installing 2008 r2 service pack 1 and the installation failed with a reference to look at the summary.txt…
0
votes
1 answer
Is it possible to install SQL instances with different Collations in a SQL Cluster
We have a two node active-active SQL Server 2008 Cluster. Running on Windows Server 2008 R2.
The three excisting instances have Latin1_General_CI_AS as the Server Collation. I need to add an instance with SQL_Latin1_General_CP1_CI_AS as the Server…
Michel Klomp
- 5
- 4
0
votes
2 answers
Can't Open SQL DTS Packages
We have a SQL 2008 server. When trying to open DTS packages we'd get this error:
"SQL Server 2000 DTS Designer components are required to edit DTS packages."
Installing SQL Server 200 DTS Designed got rid of this error, but now we get this:
"here…
Brad Dean
- 33
- 4
0
votes
2 answers
SQL server backups - backwards situation
Hi I'd like to know if it seems feasible to do things in this manner.
We have several application servers (a web server for intranet applications, a couple of different app servers). Each server is backed by it's own locally installed SQL Server…
Troy
- 15
- 5
0
votes
1 answer
MSSQL techniques to archive-backup content
We are now moving from a MySQL to a MSSQL 2008R2 database. As the project is a web application that we need to be able to scale well, we need to rework the way the DB handles data.
We have 3 separate environments: production, staging, and…
Mihalis Bagos
- 91
- 1
- 6
0
votes
1 answer
MS SQL Agent fails with domain account fails to restart MSSQLSERVER Service (2008R2 Standard)
I recently was asked to bring a new SQL server online. Having no experience with this I of course did quite a bit of research on best practices. The install went without any issues with the exception of the following:
Per:Reference (Many other…
MasterOfNothing
- 1
- 1
0
votes
1 answer
One SQL, lots of SharePoint 2010 Servers, and lots of Databases to clean
I have a dedicated server running SQL server and many web servers running SharePoint 2010 installations. All the SharePoint web servers are using the same SQL server for storing/creating databases.
As I know, When SharePoint is installed it creates…
Noor Khaldi
- 3,869
- 3
- 19
- 28
0
votes
2 answers
SQL Server 2008 Express R2 restores after restart (and fails)
Almost every time I restart the machine hosting a SQL Server 2008 R2 express server, the database goes through the restore process. Most of the time, the database will become stuck in the restore process.
This error was found in the windows event…
JeremyK
- 101
- 1
- 2