Super User
Super User

Questions tagged [sql-server-2008]

Microsoft SQL Server, commonly referred to as simply "SQL Server," is the relational database engine developed by Microsoft. MS SQL Server 2008 was released on August 6th, 2008, and is major version 10 of the application.

Microsoft SQL Server, commonly referred to as simply "SQL Server," is the relational database engine developed by Microsoft. MS SQL Server 2008 was released on August 6th, 2008, and is major version 10.0 of the application. As with all databases, its primary function is to store and retrieve data as requested.

141 questions
77
votes
2 answers

Where is SQL Server Configuration Manager in Windows 10?

I just have upgraded to Windows 10 and I can't find SQL Server Configuration Manager. I have MSSQL 2008 and 2014 installed, but there is no SQL Server Configuration Manager in "All Apps" in the Start Menu. Below is a picture of how I used to find it…
malakrsnaslava
  • 2,893
51
votes
8 answers

Is it possible to open a SQLite database from within Microsoft SQL Server Management Studio?

Is there a way to open a .db file (SQLite database file) from within Microsoft SQL Server Management Studio? Right now we have a process that will grab the data from a Microsoft SQL Server database and put it into a SQLite database file that will be…
Brian T Hannan
  • 1,131
29
votes
7 answers

Move database from SQL Server 2012 to 2008

I have a database on a SQL Sever 2012 instance which I would like to copy to a 2008 server. The 2008 server cannot restore backups created by a 2012 server (I have tried). I cannot find any options in 2012 to create a 2008 compatible backup. Am I…
Rich
  • 274
22
votes
8 answers

Rule "Restart computer" failed when installing SQL Server 2008

When trying to install SQL Server 2008 Developer and Enterprise editions on a Windows 7 box I've got this message: Rule "Restart computer" failed. A computer restart is required. You must restart this computer before installing SQL Server. Of…
Pablo Fernandez
  • 11,649
22
votes
3 answers

Run an SQL Query With a Parameter from Excel 2007

I have a query in an Excel table. I followed this to do it. But how can I add a parameter from a cell into my query? I am looking for a way to do this: select * from dbo.Customers where CustomerID = Cell.A2 The Cell.A2 does not work. But how can I…
Vaccano
  • 6,806
17
votes
2 answers

Free Alternatives for SQL Prompt

Is there any free/open source alternative of SQL Prompt? SSMS 2008 R2 intellisense is good but I need it for code optimization. For example it should notify me when there is an unused variable declared.
IsmailS
  • 719
14
votes
4 answers

Viewing table relationships in SQL Server Management Studio

In SQL Server Management Studio, I have relationships set up between tables. Is there a way to display a view of all the tables with the adjoining lines like in Microsoft Access? Do I need to open a new query and run something or is there a button…
LtDan
  • 151
13
votes
1 answer

Why don't I have SQL Profiler on SQL Server Management Studio?

I'm running SQL Server Management Studio 2008 (Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )) However I cannot find the option to open SQL Profiler. I was under the impression that this was installed with SSMS…
Curtis
  • 556
11
votes
3 answers

How to install multiple Microsoft applications without conflicts

                  For all the IT students, self-teachers, and new professionals Situation: The days of internships, OJT, and "practical" entry-level positions are rapidly declining in favor of industry experience and domain specialization.…
Josh Campbell
  • 860
  • 1
  • 7
  • 21
10
votes
3 answers

Change SQLEXPRESS instance name

I installed VS2010 and it automatically installed SQL Server 2008 Express. Now, the installed instance is called SQLEXPRESS, therefore to connect to it I have to use 'localhost\SQLEXPRESS' or '.\SQLEXPRESS' or something like that. I want to rename…
willvv
  • 683
10
votes
2 answers

SQL Server Management Studio Color Schemes?

Is there a way to apply color schemes and themes to SQL Server Management Studio? I really enjoy the ones for Visual Studio 2005/2008/2010 and would love to have something like that. Color Schemes for Visual Studio: Create and share Visual Studio…
spong
  • 2,047
8
votes
2 answers

Sql Server Management Studio: Change Prefix or Suffix characters

I have an instance of SSMS 2008, for which the option to edit data in a table doesn't work. If I right-click on any table in the Object Explorer and select 'Edit top 200 rows' I get an error dialog 'Invalid prefix or suffix characters. (MS Visual…
LondonPhantom
  • 1,049
  • 3
  • 11
  • 16
8
votes
3 answers

How to remove a broken installation of SQL Server 2008?

After installing the Service Pack 2 of Microsoft SQL Server 2008, the SQL Server failed to start. Trying to repair this, I've done some stupid things, which results now in the situation in which I cannot even install a fresh copy of SQL…
Arseni Mourzenko
  • 1,879
7
votes
5 answers

What to enter as "Server Name" in SQL Server Management Studio

When I start SQL Server Managaemnt Studio (SSMS), I'm having a problem in connecting to the database. What will be the 'server name' if my computer's name is Rakesh?
Rakesh
  • 81
7
votes
5 answers

try to attach to a database file but can't browse folder which contains the file

I am trying to attach to database file (*.mdf, *.ldf) that I placed in the same folder as all my other SQL Server databases. I begin the attach by attempting to browse to the folder which contains the db files as well as all of my active database…
Ivan
  • 2,364
1
2 3
…
9 10