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

3
votes
1answer
67 views

Can't list SQL databases like directories with PowerShell

I'm trying to list databases with PowerShell. I'm able to use Inkoke-Sqcmd cmdlet, but I can't list databases with this command: dir SQLSERVER:\SQL\myserver\sqlinstance\Databases Get-ChildItem : No ...
0
votes
0answers
35 views

Could not connect to remote MSSQL server

I am having a Microsoft Azure cloud server with Windows 2008 R2 Datacenter operating system and I have a web application running in it. I use this server as a testing server and hence no reserved IP ...
0
votes
0answers
23 views

Export from SQL server 2008 to Excel 2013 put results on specific cell

I'm using SQL Server 2008 also i have Excel 2013, i have query to return count, and now i'm looking to export the results to excel sheet that "already created" and put the results on specific cell, ...
0
votes
0answers
506 views

Unable to connect to sql server 2012 with SSL encryption enabled using sqljdbc4

I am trying to connect my web application to SQL server 2012 with SSL encryption enabled using sqljdbc4 but i get the below error : com.microsoft.sqlserver.jdbc.SQLServerException: The driver ...
0
votes
0answers
148 views

Cannot install SQL Server 2008 R2 express. Compiler returned error 0x8007005

First off, I'm having a very similar issue to this StackOverflow post here: http://stackoverflow.com/questions/31681386/sql-server-configuration-manager-wont-start-wmi-returns-error# Installing SQL ...
0
votes
1answer
812 views

Updating MS SQL Server from 10.50.1600 to 10.50.1617

How do I update my MS SQL Server from the version 10.50.1600 to 10.50.1617? I have downloaded the KB from here https://www.microsoft.com/en-us/download/details.aspx?id=26304 but i am still not ...
0
votes
1answer
51 views

Creating a database in Visual Basic 2010 Express

I'm studying computing and I need to make a program for my project. My project is a fast food ordering system which needs a database. While trying to add a SQL Service Database I get an error message ...
1
vote
0answers
33 views

Sql server 2008 R2 is losing Intellisense after installing Visual Studio 2010 SP1

after installing service pack 1 on visual studio 2010 , i have lost Intellisense in sql server 2008 r2 , what should i do in order to fix this issue ?
0
votes
1answer
68 views

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

SQL Installation hanging on windows 10

I've tried installed every version of SQL Express I can get my hands on (And I've got the MSDN SQL 2016 CTP 2). Everythings hangs, and always at this point. I've a feeling its a .net related issue ...
0
votes
1answer
68 views

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

SQL Server not working after upgrading windows 10 from windows 8.1

My Sql server 2012 has stopped working and now its not letting me login. Here is the error: https://drive.google.com/file/d/0ByGXmosQgHUqdGw4alFSb3otVkk/view?usp=sharing TITLE: Connect to Server ...
0
votes
0answers
18 views

Data transfer in sql server 2008

I have following requirement In SQL server 2008,Trying to implement in stored procedure source table T with 100000 records need to be insert into destination table T1.A Job will be schedule for ...
0
votes
0answers
20 views

SQL Server 2008 doesn't want to connect

I'm brain new into SQL Server and just installed Microsoft SQL Server 2008. Now I'm trying to starting it up but doesn't want to connect. Server type: Database Engine Server name: .\SQLEXPRESS ...
0
votes
1answer
212 views

Can't install SQL server 2008 or SQL Server 2014

When I try to run the SQL SERVER 2008 setup, it shows the following error and exits: SQL Server Setup has encountered the following error: Unable to cast object of type ...
0
votes
0answers
24 views

Make changes in excel external datasource and send them to Sql Server?

I'm using data from Sql server as external data source in Excel. But if I change data in excel, then the data won't change in sql server. Can I make changes in excel and send them to sql server? I'm ...
2
votes
1answer
163 views

How to pick rows in MS SQL based on column values?

I want to pick SourceId & Currency based on Count value. Problem is within a set I've to ignore all data where Count = 0 if there is any value greater than 0 but if all the counts are 0 within a ...
2
votes
2answers
372 views

Cannot uninstall SQL Server 2008 from Windows Server 2012 r2

I have install SQL Server 2008(64-bit) express on the virtualbox in virtual machine, with guest os Windows Server 2012 R2(It is also domain controller). After the installation, I decide I would like ...
0
votes
1answer
32 views

SQL server connects after browser restart

I am using SQL server 2008 trying to connect the server using management studio using ssms with server name including ports and named instance with SQl authentication . Windows firewall is disabled . ...
0
votes
1answer
66 views

SQL Server 2008 Backup to networked drive

When I go to backup a SQL database - I only see options to do the backup on a local disk. Is it possible to backup to a network drive directly?
0
votes
1answer
259 views

Mysql Connector crash on SQL Server 2008

I would like to create a linked Server betwenn my MYSQL Server and a SQL Server 2008. I already installed the MYSQL Connector ODBC drivers 5.1 (previously the 5.3 Version but same problem) on my SQL ...
0
votes
0answers
109 views

SQL server express 2008 failed to install

I am attempting to install SQL Server 2008 Express Edition as part of Visual Studio 2010 in Windows 8.1 and it gives the following fail message: SQL server 2008 express service pack ...
0
votes
0answers
37 views

Change SQL server back to a trial

I need to convert a SQL Server 2008 instance on a VM (which is licensed) back to a trial. What are the steps to do this? REASON for this: Need to give a VM with a custom solution on it to a 3rd ...
1
vote
1answer
238 views

Move SQL Server 2008 to virtual machine

I have a physical server that uses SQL server 2008 in managing my warehouse. We desperately want to virtualize this server. Would I need to buy a new SQL server license? Or is there a way to use ...
0
votes
1answer
242 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
1answer
117 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
3k 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
1answer
68 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
2answers
1k 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
6k 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
80 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
8k 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 ...
2
votes
1answer
228 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
150 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
306 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 ...
6
votes
1answer
2k 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
509 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
132 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
2k 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
2k 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
908 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
45 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
968 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.
2
votes
0answers
71 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
276 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 ...
6
votes
2answers
8k 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
168 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 ...
24
votes
6answers
79k 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
604 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 ...