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

-5
votes
0answers
16 views

Attempted to perform an unauthorized operation sql server 2008 in Windows7

I am instaling sql2008 and it is showing the following error: Attempted to perform an unauthorized operation sql server 2008 I have tried: Run setup as administrator Create new user as ...
0
votes
0answers
11 views

SQL Server Witness Server Alternative

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
0
votes
0answers
22 views

Stopping (and starting) remote services when MS SQLServer stops/is available

We have an application (windows service, Java) running on server A and MS SQLServer 2008R2 running on server B. What's the best way to stop the application on server A if the SQLServer on server B ...
0
votes
0answers
30 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
27 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
28 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
62 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
57 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
84 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
42 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
2k 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
589 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
60 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
179 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
2k 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
48 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
149 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
91 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
229 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 ...
4
votes
0answers
1k 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
240 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
107 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
863 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
578 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
693 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
41 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
642 views

How to install Sql 2012 on Windows 8?

I am having trouble installing sql server 2012 on windows 8.
2
votes
0answers
56 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
220 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
127 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 ...
12
votes
6answers
40k 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
459 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
284 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
126 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
3k 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
280 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 ...
3
votes
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
599 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
2k 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
613 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
15k 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
767 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
379 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
11k 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
292 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 ...