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
6 views

SQLServer compatibility with DoctrineDbal and Unix/Linux

I'm designing a solution for a web portal. This portal will use the micro-framework Silex which provide database access through Doctrine DBAL libraries. My target DB is a SQLServer 2008 which is ...
0
votes
0answers
21 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
39 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
0answers
27 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
46 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
32 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
1k 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
535 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
58 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
117 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
1k 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
44 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
3k 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
128 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
85 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
207 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
933 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
174 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
100 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
719 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
381 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
648 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
39 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
557 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.
2
votes
0answers
51 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
214 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
3k 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
118 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
33k 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
427 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
224 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
112 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
2k 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
259 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
2k 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
538 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
2k 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
490 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
13k 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
664 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
365 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
3answers
9k 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
270 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
7k 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
53 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
91 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 ...