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.

learn more… | top users | synonyms

0
votes
0answers
13 views

How to create installer for my visual basic project with sql server 2008 database?

Hi guys I have a visual basic project and I developed it using visual studio 2010 and sql server 2008 for my database. Now, I want to make an installer that will include my sql server database. I ...
0
votes
1answer
19 views

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 ...
0
votes
0answers
15 views

SSMS view designer - how do I give a table an alias?

I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible. Case in ...
0
votes
1answer
492 views

Remove column header from sql query output in powershell

I want to remove column header from sql server query output. I did the search but not found any solution. I have a script. $Database = "temp" $Server = "localhost" $AttachmentPath = "output.csv" # ...
0
votes
0answers
472 views

Windows could not start the SQL Server (mssqlserver) service on local computer error 17058

I'm working with a virtual machine on Windows 8. There is a SQL Server 2008 on the virtual machine. And in the services, when I try to start the SQL Server service I am getting an error like this:
0
votes
1answer
55 views

MS SQL Server 2012 drives

I am buying machine for MS SQL Server 2012 Standard and I have questions about drives and performance. How to locate OS, database, logs, backup on WD RE4 500GB and Intel SSD DC S3500 120GB? OS, ...
1
vote
1answer
87 views

Try to resolve logged error SQL Server/SQL Server 2008 R2

I have this logged error #10016 The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID ...
2
votes
1answer
729 views

Is SQLCMD part of the DB Engine or Client Tools?

We have hundreds of locations where our software is installed, and it used to use SQL 2005 Express. As part of an upgrade to our software, we are doing an automated upgrade to the DB Engine to SQL ...
1
vote
1answer
41 views

SSMS 2008 is stuck because Connect to Server window is hiding

Launching SQL Server Management Studio 2008 after rdp or similar display config funny business, the Connect to Server window is sometimes hiding in the corner of a monitor. The program seems stuck, ...
1
vote
2answers
2k views

How to start/open SQL Server Express 2008 in Visual Studio?

I have Windows 8 and have installed full-pack Microsoft Visual Studio 2010 Ultimate Edition. There was no error while installing Visual Studio 2010 Ultimate Edition. I exactly don't know which ...
1
vote
1answer
123 views

Install sql server management studio API only

I have already installed sql server 2008 R2 , but now i need to install sql server management studio also ( i mean just that API ony ) is it possible to install only this instead of uninstall sql ...
0
votes
1answer
79 views

Move multiple SQL Server 2008 databases from C: to D: at once

I have SQL Server 2008 R2 with 323 databases consuming some 14 GB on my C: drive, a fast SSD. Because I want to reclaim some space on my C: drive, I would like to move them to my D: drive. I have ...
0
votes
1answer
197 views

Error when install SQL server 2008 the application was unable to start correctly (0xc0007b)

"the application was unable to start correctly (0xc0007b).click ok or close button to installing application)" Error come when i try to install SQL server 2008 in my system. How can i fix this ...
3
votes
0answers
762 views

SQL Server ODBC authentication errors

I'm trying to connect to a SQL Server 2008 database from a 3rd-party application through an ODBC connection. I am having success when the ODBC is set up with Windows Authentication but not when it's ...
0
votes
1answer
142 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
0
votes
1answer
93 views

Windows XP, SQL Express, 3rd party application crash — how to check the possible lack of resources?

Summary: I need to log usage of resources on Windows XP machine to find if the lack of resources may be the reason for the application crash. I need your advice how to do that. Context: There is an ...
0
votes
1answer
619 views

How to un-install sql server 2008 analysis service only?

Initally I installed SQL server 2008 R2 Evaluation version. Then we bought licence key for SQL server 2008 R2 Web and wanted to update my licence, but unfortunately I installed analysis service when I ...
0
votes
2answers
327 views

Can I delete SQL Server from Windows 7 without secondary effects?

I'm trying to delete all unnecesary programs from my computer and SQL makes me doubt. I don't use it directly, but can't recall any program using it. Is it safe uninstalling?
11
votes
3answers
627 views

How to install multiple Microsoft applications without conflicts

                  For all the IT students, self-teachers, and new professionals Situation: The days of ...
-1
votes
1answer
37 views

SQL Server 2008 Express, just create a few tables and run queries? [closed]

I have installed SQL Server 2008 Express, as I just want to create a few tables and run queries against them. After installing I am a little unstuck. I have an "instance" running, but I am not sure ...
1
vote
2answers
513 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.
2
votes
0answers
49 views

SQL Server 2008 and Visual Studio 2008 [closed]

I have a database project to do. I can't install SQL Server 2008 on my PC (windows 7 64 bit). When I start it says Microsoft.NET Application Security. It go further though. But it says Older version ...
1
vote
1answer
205 views

SQL Server 2008 R2 service pack 1 not showing

I've checked my SQL server version and it says "Microsoft SQL Server Management Studio 10.50.1600.1". I've seen here that there's a SP1 for it. Why doesn't windows update offer me to d/l it? Should I ...
5
votes
2answers
2k views

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 ...
0
votes
0answers
46 views

Our application is responding different on client server

I have an application running on our local server and it works perfect. However when I deploy my application to our client's server there are problems. If i copy all the sources to another local from ...
0
votes
1answer
113 views

Fastest light-weight method of executing and displaying results of SQL query [closed]

Many if not most applications can display the results of SQL queries in some human readable format. However, they typically either must be open with an active window (SSMS or excel for example, both ...
11
votes
5answers
28k views

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 ...
2
votes
1answer
404 views

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 ...
1
vote
1answer
207 views

How to use the current date as an argument?

I have a batch script which extract SQL data to CSV file: bcp Database.dbo.MyTable out C:\Reports\Output.csv -s ServerName -T -c I need the name of the output file to contain the current date. For ...
1
vote
1answer
103 views

How to create a condition clause using a current computer time

I have an SQL View which contains a column with dates of the '2012-06-21 19:44:50.543' format. I need to entre the condition to show only lines with dates starting from the beginning of the previous ...
1
vote
1answer
1k views

How do I automate the exporting of a result set from an SQL Server database?

I have a View in an SQL Server 2008 database which I need to be exported into a CSV file automatically at the beginning of each month. As I understand, two procedures are needed: The SQL script to ...
0
votes
0answers
247 views

Cannot login to sql server 2008 express after the installation

After i have installed VS 2010 in windows 7 64 bit. I tried to install sql server 2008 express 64bit version. but the installation failed. saying some files is missing from the downloaded package. I ...
1
vote
2answers
1k views

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?
0
votes
1answer
475 views

Questions about setting up PHP-ODBC driver for remote SQL-Server-2008 connection on CentOS-6

I have CentOS 6 and PHP 5.3.3 VPS at GoDaddy. I have to interact with remote SQL Server 2008. I've seen many tutorials and quite lost here, so: There is a way to simply yum install it ? If not, what ...
1
vote
1answer
1k views

Renaming server - sql 2008 server instance affected

Will changing the computer name on which SQL Server 2008 is installed on affect SQL Server in anyway? Or will changing the computer name be transparent to SQL Server? For example: I plan to install ...
0
votes
0answers
1k views

SQL server 2008 R2 installation error

I have a windows 7,32 bit laptop. I am the administrator with all permissions. when I click on the SQL server 2008R2 set up file,it says : SQL server set up has encountered the following error: ...
0
votes
1answer
3k views

SQL Server 2008 Registration with Product Key

A colleague of mine gave me the SQL Server 2008 Standard ISO image and I used that while building a Virtual Machine. Now, when I installed SQL Server with that above mentioned ISO, I did not give it ...
0
votes
3answers
460 views

Error while installing SQL Server 2008 on Windows 7 Home Edition 64 bit

I am trying to install SQL Server 2008 on my Windows 7 Home Edition, Setup is giving an error attempting to perform unauthorized operation
3
votes
1answer
12k views

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 ...
2
votes
1answer
565 views

Excel 2010 not displaying calculated measures as currency

When connecting Excel 2010 to a SSAS 2008 R2 datasource, calculated fields(Standard Margin) do not display with the appropriate currency symbol. When I define the measures in the cube, I am setting ...
1
vote
1answer
352 views

Microsoft Update - how to make it work properly?

I`m using a wide range of microsoft products - Windows 7 Ultimate x64 with SP1 included, Microsoft Project, SQL Server 2008 R2 and Visual Studio 2010. After doing a full OS reinstall I tried using ...
2
votes
2answers
8k views

Windows 2008 R2 Memory is always full

We have a Windows 2008 R2 on a HP Server with 24GB of RAM. The only important software installed is SQL Server 2008 R2 and almost no feature or role is enabled on this Windows. But the problem is ...
1
vote
0answers
251 views

Export MS SQL database as *.dbschema

We have a production database and visual studio 2010 database project. We had to make some changes in database schema. Unfortunately we don't have previous database schema file for production ...
3
votes
2answers
6k views

SQL server 2008 and 2012 on the same instance of Windows

Is it a problem to have both of these installed on the same Windows instance? I.e. will one break the other or impact it negatively in any way?
0
votes
2answers
52 views

I need more advice on this data addition issue [closed]

I have a test program consisting of a textbox (textbox1), a button (save), and a connection to a database and a table called TestDatabase.mdf and TestTable (respectively). I am trying to save the text ...
1
vote
2answers
1k views

Lagging windows and mouse pointer in Windows 7

I'm using Windows 7 and on top of it I have installed Visual Studio 2010 and SQL server. For some time now I have been experiencing a laggy behavior. Explorer windows minimize and maximize with a ...
1
vote
1answer
90 views

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 ...
0
votes
1answer
972 views

Trouble enabling remote connections to SQL Server Express 2008 R2

I'm trying to enable remote connections but i'm having some trouble. Here's my setup SQL Express is installed on Win2k8 R2. Windows firewall turned off SQL Browser service started and running SQL ...
1
vote
0answers
561 views

Creating a New Database Across a Network with SQL Server 2008 R2

I appreciate that the above should not be done ('Creating a New Database Across a Network with SQL Server 2008 R2') for all of the reasons outlined here but a client wants to know how to do this and ...
0
votes
1answer
80 views

Install issue in windows 7 SQL Server 2008

I keep trying to install SQL Server 2008 on windows 7 but after a while and more than half installation i get this error: