Super User Stack Exchange
Super User Stack Exchange

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.

144 questions
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
  • 709
13
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
  • 141
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
  • 3
  • 7
  • 11
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
6
votes
1 answer

Unable to Connect to SQL Server 2008

I installed SQL Server 2008 on a PC with xxx.xxx.x.200. When I connected to the server from another machine(say xxx.xxx.x.81) using SQL Server Management Studio, I get the following error. TITLE: Microsoft SQL Server Management…
Rauf
  • 3,707
4
votes
3 answers

Does SQL Server 2008 R2 Express have Intellisense?

I don't have any Intellisense in SQL Server 2008 R2 Express Management Studio - is this supposed to work? I am connecting to a SQL Server 2008 R2 Express database on the same machine (no other databases here at home) and I have no Intellisense. Just…
Matt Frear
  • 211
3
votes
2 answers

Where do I run dbcc checkdb?

I was told to run dbcc checkdb on a Microsoft SQL server database. Exactly where am I supposed to run this? In the SQL Server Configuration Manager? If so, where do I actually type this command?
user1413
  • 4,404
2
votes
1 answer

How can I compare two huge tables?

I need to compare if two developers did the job correctly and created identical tables. The problem is more complex, but I will try to solve it somehow if I solve the problem of comparing two tables (let them be in different SQL Server 2008…
Robert Jung
  • 73
1
vote
1 answer

How do I set up a new database with SQL Server 2008?

In my start menu, I have Microsoft SQL Server Express 2008 R2 > Configuration Tools. In this folder, I have SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server Installation Center. Where do I go to create a new…
oscilatingcretin
  • 5,193
1
vote
1 answer

Do we need to install SQL Server 2008 SP2 after installing SQL Server 2008 R2 RTM?

I have installed SQL Server 2008 R2 RTM (Express) with Management Studio. But I am confused, do I need to install SQL Server 2008 (Express) Service Pack 2? Is there SQL Server 2008 R2 Service Pack 2?
Display Name
  • 2,239
0
votes
1 answer

How to share a SQL Server 2008 Standard edition database to another on a computer (wireless network)

Does anyone know how to set the properties of database to be shared through wifi network? I'm running windows 8.1 OS and the other computer I need to share with, is Windows 7. I tried to use 'adhoc' but seems like doesn’t work at all or maybe I used…
DjayPediA
  • 1
0
votes
1 answer

Time and date filter in SSRS 2008

I am looking for an expression that can filter a time and date column to 4 hrs prior from what the actual value is. Example: 5/27/2015 5:00:30 pm So I am looking how to get: 5/27/2015 1:00:30 pm
Kevin Brekke
  • 43
0
votes
1 answer

sql server 2008 Management Studio does not see my copied database

I copied my database (mdf and ldf files) from my server to the cloud. Previously I have done it from one local server to another. I put it in the same directory (MSQLSERVER/../../data, confirmed that the path in SQLServer for the data is that. But…
fred karmally
  • 1
0
votes
2 answers

SQL Server Reporting?

I have a SQL Server instance setup, and on one of the databases I have a lot of views defined. I have to connect to our VPN before I can connect to the database. I'm wondering if there is a simple web-based interface, or something in SQL Server…
kaes
  • 303